find fields value in string

[Former Member]

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

[former_member787646]

Hi

Try...

REPLACE ALL OCCURRENCES OF REGEX 'DIM' IN <str_variable> WITH ''.*

Hope this would help you.

Murthy