Need after data '|'

[priyarane]

Hi Community,

Need data after '|'...

My data looks like below.

Dim:

ABCD|1234

DEFG|5678

I need to have data to be display like:

Dim:

ABCD

DEFG

[Kushal_Chawda · Accepted solution]

try

subfield(Dim,'|',1) as Field

[sasikanth]

hi,

Try some thing like

field_Name&'|' as New_field

[vipin_mishra479]

Try this in script

Subfield(Dim,'|',1) as Dim

[arasantorule]

Hi,

Please use Subfield('ABCD|1234','|',-1) .

Also please ensure only one '|' is available in the string to ensure the accuracy.

Thanks