REGEX_REPLACE to replace text in variable

Question

Dear community,
first of all I really appreciate this forum, even if just as a silent participant so far. I’m pulling my hair out trying to replace strings in variables to make them ready for webmerge/formstack documents.
Input string: my webmerge variable

Wanted result: {$my_webmerge_variable}
Formula I am using: REGEX_REPLACE(REGEX_REPLACE({regex test},"\A","{$"), “\s”, “_”)

Result I am getting: {$my_webmerge_variable
How do I get the closing brace = } at the end of the variable? I tried $ and \z but they don’t seem to be working. Thank you all in advance, any help is much appreciated  :slightly_smiling_face:

ScottWorld · Accepted Answer

Welcome to the community, @FrankLovesAirtable!

I’m not a REGEX expert, but are you just looking to add brackets & replace the spaces with underscores?

If so, you could just do it simply like this:

"{$" & SUBSTITUTE(Input," ","_") & "}"

FrankLovesAirta · Answer

Welcome to the community, @FrankLovesAirtable!

I’m not a REGEX expert, but are you just looking to add brackets & replace the spaces with underscores?

If so, you could just do it simply like this:

"{$" & SUBSTITUTE(Input," ","_") & "}"

Dear @ScottWorld,

you help is very much appreciated and your solution works perfectly well. This function also seems to be more of the standard repertoire from Airtable so to speak, using this one from now one. Tagged as Solution. Thank you.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded