Help with function

[skarthanal]

Hi everyone,

I need help with a string function.  I have a variable for example 1.2.0 and i want to convert that string to 1.20  In Excel i would just use the Substitute function but with PA I only see a replace function which works but it allows me to replace all occurences of the '.' not certain instances?  How would i go about doing this?

Thanks in advance!

[Paulie78 · Accepted solution]

Try this expression:

concat(split('1.2.0', '.')[0], '.', join(skip(split('1.2.0', '.'),1), ''))

You could replace the hard coded 1.2.0 with the output of a compose action or a variable.

[skarthanal]

@Paulie78 Thank you!  This worked perfectly.