sub string

[raadwiptec]

Hi all,

My output data below looks like this . In the qlikview script I am concatenating 2 columns .so I get below result

954379543867 ¦  decode

38473843 ¦ capcitors

985764543988590 ¦ cables

using the expression can I take the values after the symbol  '¦'

[morganaaron]

SubField([Your Field Name], '¦', 2)

[sasiparupudi1]

Trim(SubField([Your Field Name], '¦', 2))

[ecolomer]

For the first field:

Trim(SubField([Your Field Name], '¦', 1)) as First

And for the second:

Trim(SubField([Your Field Name], '¦', 2)) as Second