Originally posted by: Rajkumar_Perla

Dear All,

I am new to WTX so couldn't aware of mixed usage of functions.

For example, I am getting a filed in the input like <Session>987:123:222:44></Session> it is made up of 4 components separated by a : (colon)

The components contains variable number of length, so it could be like 1.22.3.456 or 11.2.4.4 like that.

I would like to map third component i.e. 222 to the output field. 

Looking for your valuable suggestions how to write a rule to fetch specific component.

Originally posted by: PaulBrett

Use the WORD() function.

=WORD(Input,":",3)

...would map the 3rd word, with a ':' delimiter.

Thank you.

Paul

Follow me on Twitter

Originally posted by: Rajkumar_Perla

Thanks a lot Paul, it worked.