Replace space with underscore only on the first space.

(1) Share

Report

Posted on by xvzms

103

Hi!

I have users whose first name and last name are one word, and there are also users whose first name is one word and the last name is two words:

Jelle van Assen
Marlijn Smink
Arnout van Rijswijk

I want the space to be replaced with an underscore only on the first space.
For example:
Jelle_van Assen
Marlijn_Smink
Arnout_van Rijswijk

Please tell me how can this be implemented?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @xvzms

Follow the below:

The expression I used is as follows:

concat(first(split(outputs('Compose'),' ')),'_',trim(last(split(outputs('Compose'),first(split(outputs('Compose'),' '))))))

Thanks

Was this reply helpful? Yes No
Verified answer

xvzms 103 on at

Like (1)

Report

@abm Thank you very much!
You are the best!

Was this reply helpful? Yes No