DSXchange

hello

i have one requirement where i need to read the first record from the file and count the number of delimters (;) in the row.

ex:
input file first record
123;456;789;234;567;456

then i need that record and count the number of delimters (;).

the count should be 5.

is there a way that i can achive this in the datastage job

dodda wrote:hello

is there a way that i can achive this in the datastage job

Indeed there is... have a read of the String Functions help page