... fields.
When you use parentheses or comma in the value for a criteria, you must escape them using a backslash. Further, you must encode the value.
Example:
Consider the search term:
((Last_Name:equals:Burns,B)and(First_Name:starts_with:M))
After ...
... that in the following regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash:
v_Test1 = 12.300;
info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$", ...
... sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company ...
... for Inventory OAuth 2.0 Connection - Custom Service - on account server COM
https://deluge.zoho.com/delugeauth/callback
Problem: Split a string with the escape character/backslash character
Trying ...
... = v_MyString.replaceAll("[^0-9]","");
// yields 123
The following is used in searches to escape special characters with a backslash:
v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)";
v_FormattedString ...
... 26 (Control+Z).
\\ A backslash (“\”) character.
\% A “%” character.
\_ A “_” character.
Additional
An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so:
INSERT ...
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.