Unanswered

Help with function

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
Re: Help with function

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Help with function

@Paulie78 Thank you! This worked perfectly.

Was this reply helpful? Yes No