Script PRob

[nikhilgarg]

Hey,

I ahve id as:  ABC\gnikhil

In my script, i want Id as : gnikhil only. How to acheive this?

thanks

[prieper · Accepted solution]

SUBFIELD(MyField, '\', 2)

Peter

[fvelascog72]

Try:

Subfield([FIELD],'\',2)          as "FIELD"

[#4]

Use SubField function in script

SubField(<your field>,'\',2) as <your field>

the third parameter indicates the column that interests you after the split, and the count starts at 1