parcing in datastage

[sainath]

Hi
I have a MSC text column and i have to to parscing based on following conditions.

1.search for ( ) and then data in ( ) have intch code,PNO,text.if found populate this data in seperate columns .

can you tell how i can do in datastage.
thks

[kcbland]

Sounds like you need to write a DS Function that will do your specific string parsing. Useful DS BASIC string functions are INDEX, FIELD, SUBSTR, LEFT, RIGHT, and COUNT.

[sainath]

Hi
I dont have any delimitors between each feild in order to use the
DS functions.
can any one please share your idea for problem solving.
thks
sai



I have a MSC text column and i have to to parscing based on following conditions.

1.search for ( ) and then data in ( ) have intch code,PNO,text.if found populate this data in seperate columns .

can you tell how i can do in datastage.
thks

Sounds like you need to write a DS Function that will do your specific string parsing. Useful DS BASIC string functions are INDEX, FIELD, SUBSTR, LEFT, RIGHT, and COUNT.

[sainath]

Hi
I dont have any delimitors between each feild in order to use the
DS functions.
can any one please share your idea for problem solving.
thks
sai



I have a MSC text column and i have to to parscing based on following conditions.

1.search for ( ) and then data in ( ) have intch code,PNO,text.if found populate this data in seperate columns .

can you tell how i can do in datastage.
thks

Sounds like you need to write a DS Function that will do your specific string parsing. Useful DS BASIC string functions are INDEX, FIELD, SUBSTR, LEFT, RIGHT, and COUNT.

[ray.wurlod]

Doesn't matter. You can extract the contents of the parentheses with Field(Field(TheString, "(", 2, 1), ")", 1, 1) - possibly having used the Index() function in an If statement to determine whether there are parentheses.