DSXchange

hi i have a string like

87658799_qw456huji78_AT_TIME1

i should extract the first '_' delimited field from the string i.e. 87658799
how could this be done through a transformer. can some1 provide the exact function. and also the first '_' string may have any length. nothing can be considered as a constant here.

You can use a field function. Field(InputCol,"_",1).

Or the shorthand version:

... which compiles to precisely the same code as the equivalent Field() function.