string extract

Sgiri1 · Post by **Sgiri1** » Tue May 05, 2009 1:43 am

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.

mahadev.v · Post by **mahadev.v** » Tue May 05, 2009 2:54 am

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

ShaneMuir · Post by **ShaneMuir** » Tue May 05, 2009 3:01 am

Or the shorthand version:

Code: Select all

InLink.InputCol['_',1,1]

ray.wurlod · Post by **ray.wurlod** » Tue May 05, 2009 4:15 pm

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