how to use substring in transformer

[austin_316]

i have a column whose data is like
JOB_ID_NAME=1 or JOB_ID_NAME=12 or JOB_ID_NAME1=1 or JOB_ID_NAME1=112 etc.
i have to get the data which is after '=' from these records like for above records the output shud be 1 or 12 or 1 or 112 .... how can i do that. here the data before and after are dynamic. They are different for each and every row.

[ArndW]

Code: Select all

FIELD(In.StringColumn,"=",2)

will give you what is after the '=' and before the next '=' (if present). Is that what you were looking for? If not, please also specify if this is a Server or a PX transform, as Server has additional string manipulation functions which are not present in PX.

(corrected syntax per Craig's hint)

[chulett]

You'd need to post examples of your actual data for anyone to provide more cogent help.

Arnd, your syntax example is... lacking.

[austin_316]

actually i was also thinking on the same lines.but was not sure if i can give it that way...but tried as per ur suggestion and got it...thanks alot

[ray.wurlod]

This would be quite simple as a routine. It needs one input argument (the string to be parsed) and will return a delimited string containing the values found.

Code: Select all

FUNCTION GetValues(aTheString)

If UnAssigned(aTheString) Or IsNull(aTheString)
Then

   Ans = @NULL

End
Else

   TheString = UpCase(aTheString)                        ; * handle "or" or "OR"
   TheString = Ereplace(TheString, " OR ", @VM, -1, 0)   ; * convert to dynamic array
   Values = Fields(TheString, "=", 2, 1)                 ; * extract that which follows "="
   Ans = Trim(Values)

End

RETURN(Ans)