07-16-2008 9:50 AM
Hi,
i have two string type
1. DIM0CALMONTH DIM_NAVATR001 abbbbb
2. DIM0CALMONTH DIM0COSTCENTER kyf0hdcnt_last02 kyf0hdcnt_last
and i wont to get i fields1 kyfd3nrqb23k9zv
and in fields2 kyf0hdcnt_last02 kyf0hdcnt_last
the string is static for the 2 first words but is change is e.g.
string 1 :DIM0CALMONTH DIM_NAVATR001 cddddd
Regards
07-16-2008 10:39 AM
Hi
Try...
REPLACE ALL OCCURRENCES OF REGEX 'DIM' IN <str_variable> WITH ''.*
Hope this would help you.
Murthy
07-16-2008 10:39 AM
Hi
Try...
REPLACE ALL OCCURRENCES OF REGEX 'DIM' IN <str_variable> WITH ''.*
Hope this would help you.
Murthy