How to get the substring from the string in DS transformer

[sharma]

Hi ,

I want extract substring ( e.g starting from 4th place to 10th place ) from a giving string of length 100.

e.g.
Given String:

STR= "abcd,ef,ghi,jkl,123,4rf,gfr,ser.........."

I want to extract "ef" from the above mentione given string.

I want to check the substr(6,7) ='ef'.

How would i do in the datastage transformer.

Can somebody help me out.

Thanks

[kandyshandy]

STR[6,2] will work

[srimitta]

"abcd,ef,ghi,jkl,123,4rf,gfr,ser[6,2] = ef

Assuming data string is left justified, fetch 2 bytes from string position 6.

[sharma]

There is no such function STR(x,y) in the DS.

[chulett]

They didn't say there was. The square brackets are the substring operators, so they showed how to take 2 characters from a field named STR starting from the 6th position.

[sharma]

Ohh!!!
Thanks ...Its working now.

Thank you very much.

[Nagaraj]

Sharma,

can you please post the code as well so that it is marked as completely solved.

Thanks

[sharma]

here is the small piece of test code that i have written in the transformer stage to test my sample data.

If ( DSLink3.col1[5,2] ="xy") Then "valid" Else "invalid"

[sharma]

here is the small piece of test code that i have written in the transformer stage to test my sample data.

If ( DSLink3.col1[5,2] ="xy") Then "valid" Else "invalid"

[Nagaraj]

Perfect thanks,

i just want all the issues or concerns discusssed here are marked as complete with solutions mentioned

Thanks once again.

[chulett]

Then it seems it is time to ask that the topic be marked as Resolved using the big button at the top of the screen.