How to process large number of records in TIBCO BW

[Manu Sharma 2]

Hi All

I have one file where I have thousands of records,

I want to convert those records to a single string with comma separated record

Eg in file abc.txt

123

789

908

678 like this I have n number of records

But I want all the records to be in one string eg 123,789,908,678 and so on

 

Could you please help how to solve this.

 

Thanks in advance --

[Julio Gimenes 2]

Hi,manu.sharma1191!

You can read the file and under the transformation activity use functions normalize-spaces() and translate(), to remove additional spaces and to replace the remaining spaces to coma.