topic script syntax in App Development

script syntax

Krish2459_58 — Mon, 10 Mar 2025 08:30:39 GMT

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 — Mon, 10 Mar 2025 09:19:58 GMT

There are multiple ways, this is one option:

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

rwunderlich — Tue, 11 Mar 2025 03:41:46 GMT

Here's another:

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