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 !!!
PATINDEX Equivalent
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
PATINDEX Equivalent
Thanks
Deepak Patil
Convince Them Confuse Them .. What's the difference?
Deepak Patil
Convince Them Confuse Them .. What's the difference?
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am