DSXchange

Is there an equivalent for the MSSQL Patindex in Datastage?

Requirement is to convert like the following --


Source Target

ABC-DEF ABC
EFGHI-KL EFGHI
A-B A
-JKL NULL

(substring from 1 till it finds the first occurence of "-").

Thanks !!!

Use the index function to locate the first "-" character, then search the forum for one of many ways to extract a substring from a string.

Actually, the Field function is probably even easier.

Mike

Yes , I think I got it --

FIELD (COLUMN , "-" , 1) will solve it...