Need UDF for splitting string

[former_member229310]

Hi All,

I have an input field with the payload value in the source structure as xxx_abc_yyyy_2010.txt .

I need string abc for one of the target field1 and 2010 for another target field 2.

Please suggest.

Thanks.

[Former Member · Accepted solution]

Hi,

your requirement is a simple text formatting and can be achieved by substring function.

So better you use the standard function itself as these are precompiled and enhances your scenario performance.

cheers,

Abhishek.