Transformatio field

[mario-sarkis]

hey all,

if i have for example this field key: ''1234|Account|Domici"

‌i want to transform it into 3 field first one :1234

Second one :Account

Third one : Domici

hope u can help

[luciancotea]

see SubField() in help.

[sunny_talwar · Accepted solution]

Try this may be:

SubField(FieldKey, '|', 1) as FirstField,

SubField(FieldKey, '|', 2) as SecondField,

SubField(FieldKey, '|', 3) as ThirdField,