... sample data
v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland";
// regex to replace a comma found between 2 double-quotes to a string of your choice
v_FormattedString = v_Test.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false);
info ...
What
A more comprehensive post on some other regex (regular expressions) to format values in Zoho.
How?
The following will remove any non-digits:
v_MyString = "Hello World 123";
v_MyFormattedString ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.