find the number of delimiters in the row

[dodda]

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

[Kryt0n]

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

[gateleys]

Code: Select all

DCount()