Zoho Analytics Regex Support
When can we expect full regex support in Zoho Analytics SQL such as REGEXP_REPLACE? Sometimes I need to clean the data and using regex functions is the easiest way to achieve this.
Regex in Zoho Mail custom filters is not supported - but it works!
I recently asked Zoho for help using regex in Zoho Mail custom filters and was told it was NOT supported. This was surprising (and frustrating) as regex in Zoho Mail certainly works, although it does have some quirks* To encourage others, here are 3 regex
Implement Regex in Layout and Validation rules
Hello all, We are excited to announce that users can now implement Regular Expressions (Regex) in our layout and validation rules. This new functionality allows for more flexible rules to be created when designing and validating forms. What is Regex?
Validation rules for fields used in blueprints
Dear community, I'm designing a blueprint for me leads nurturing process and I've noticed an issue with the validation rules applied for fields. I've applied a validation rule for the "PHONE" field and it's working just fine when I insert a new phone
Zoho Mail - replaceAll() Regex Script
Hello! I am trying to apply the regular expression /<.*?\>/ in a Zoho Mail script with the replaceAll() function. It never seems to work even though I can do it just fine on for example JSFiddle. See sample here. My goal is to replace all occurrences
How do I identify records with same mail domain using API?
I want to get the count of records with email domain "@xyz.com" But using regex in search query API doesn't yield desired results I queried the records that ends with @igdtuw.ac.in , But this isn't giving any results.
How to check if string contains any digit
How do I check if a string contains a any digit/ number? this is the code I cant seem to get working Str = "1Mustard Mustard23"; if (Str.contains("[0-9]")) { info true ; } else { info false ; }
String manipulations
Hello, I have this string: Name1-Color-1.jpg - https://example.com/100 Name2-Color-1.jpg - https://example.com/102 Name1-Color-2.jpg - https://example.com/103 Name2-Color-2.jpg - https://example.com/101 I need for example, the URLs that are Name1-Color
RegEx in Creator using replaceAll function
I am having trouble wrapping my head around the use of replaceAll and RegEx in Zoho Creator. It's my understanding I can't capture groups like I would with JS or Python. Can anyone provide guidance on how I could accomplish the following? str = "abcdefgh Record Date: 2020-04-05\n. abcdefghijklmnop" I'm trying to capture the word after Record Date:, and between \n. In other words, I'm trying to use the function to return only 2020-04-05.
12 Hour Time: Simple Solution
EDIT 07-FEB-2012: I made a free marketplace app for you all to test https://creator.zoho.com/public/showAppInfo?canvasurl=kqpjzaljg There are a number of posts here about TIME in ZOHO Creator. Many have requested ZOHO supporting a 12 hour format. With some help from Gave a while back, I have been using a rather long function to verify if a user typed in proper 12 hour format (i.e. 12:15 am or 05:00 pm but NOT 1:15 or 07:00 PM). I found a better way to do this that only uses a few lines of code.
On Input - Avoiding Infinite Loop
I have a nice routine to validate a UK phone number, but I want to update the field with the reformatted number (spaces removed) as part of the routine, which just sends me in an 'on input' infinite loop ? Any suggestions ? Thanks Neil // Set RegEx Variable Match Strings UK_Phone_RX = ("^(((\+44\s?\d{4}|\(?0\d{4}\)?)\s?\d{3}\s?\d{3})|((\+44\s?\d{3}|\(?0\d{3}\)?)\s?\d{3}\s?\d{4})|((\+44\s?\d{2}|\(?0\d{2}\)?)\s?\d{4}\s?\d{4}))(\s?\#(\d{4}|\d{3}))?$"); UK_Mobile_RX = ("^(\+44\s?7\d{3}|\(?07\d{3}\)?)\s?\d{3}\s?\d{3}$");
Regular Expressions In Zoho Mail Search?
Hi! Does either the regular or the advanced search box in the Zoho Mail web interface support regular expressions? Thanks. D.