Replace function - remove spaces from output

Hi im trying to remove spaces and replace it with underscore _ from an output, what is the best way to do it

Is replace{ DATA, ;_}
Will work?

Cheers

Hello @Tiran_Yasinov,
Welcome to the community.

Try this {{replace("test string to replace space with underscore"; space; "_")}}

Also, check this answer related to this topic.

I hope this helps.

Hi mate,
thanks for your replay,


in the image you can see i have created it as you said, do i need to literlly write the work “space?” as still not working properly and giving me the output with space between the words,

Cheers

@Tiran_Yasinov,
If you directly type the space(" ") then that’s not work.
There are a couple of default Make’s keywords and {{space}} is one of them which needs to be used here.

There are couple of way to do it.

  1. Use the Mapping Dialog Box, In the mapping dialog box, Search for the word space, then select it from it.

  2. You can write keywords surrounded by double curly braces, Like {{space}}, {{emptystring}} etc. (You need to know which word is used specific to which keyword.)

  3. Another simple option is just to copy it from another’s created syntax. As per my last response, I’ve copied it from Make’s scenario and surrounded it in the code block.
    Just copy my given formula and change the input variable it works.

I hope this helps you.


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best as Solutions :white_check_mark: and give :+1:
If you need expert help or have questions? Contact or comment below! :point_down:

Hi thanks for your reply,
i have tried and its still not working…

and then when i run it once:

any idea?
cheers

Hello @Tiran_Yasinov,
Your added underscore is wrong.
Underscore needs to be added as normal without quotes.

The syntax looks like this.