I’m using Make with Pipefy and Google Sheets to fill some coluns with information from a survey.
Im current receivng de person nome like this: [“Priscila Cardoso da Silva”], I want to remove [" and "] from de beggin and the end of the persons name.
I’m using the Replace function with the regex ["(.*?)"] and repleacing to a emptystring but is not working.
I would get rid of regrex if you always have the same format of the names.
I did this and it worked well:
function here: {{replace(replace(22.name; “[”“”; emptystring); “”“]”; emptystring)}}
You are a life saver, work perfect! Thanks!
Can your mark as solution please thank you!!! 
Welcome to the Make community!
You had the right idea, but what you needed to do is to use an “OR” to match both opening and closing brackets.
Example: https://regex101.com/r/waBQ78/1
Then, in your replace function, you need to begin and end with the regular expression delimiter /
and then finish off with a g - to indicate that you want to remove more than one match (both opening and closing brackets)
i.e.:
/(\["|"\])/g
For more information, see Text Parser in the Make Help Center:
Match Pattern
The Match pattern module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a regular expression (aka regex or regexp), which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.
- The complete list of metacharacters can be found on the MDN web docs website.
- For a tutorial on how to create regular expressions, we recommend the RegexOne website.
- For an easy, quick regex generator, try the Regular Expressions generator.
- For experimenting with regular expressions, we recommend the regular expressions 101 website. Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel.
Hope this helps!
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!