script syntax

[Krish2459_58]

Hi,

I have a column valuse like this  UserDirectory=MZDMG; UserId=krishk.

I need to get the output like this MZDMG/krishk

Please help.

[henrikalmen]

There are multiple ways, this is one option:

=replace(subfield([mystringfield], 'Directory=',2), '; UserId=','/')

[rwunderlich]

Here's another:

=TextBetween([mystringfield], 'UserDirectory=',';')
& '/'
& TextBetween([mystringfield], 'UserId=','')