New answers tagged regex
The short answer is: no, you can't do this. The long answer: IFTTT does not have a regular expression scraper, at least as of this tweet: https://twitter.com/grmeyer/status/240888420677873664 IFTTT does not legitimately let you create your own THIS conditions or THAT actions. Illegitimately, you can use https://github.com/captn3m0/ifttt-webhook to ...
I would use the following formula to obtain an URL. Formula =IF(ISEMAIL(A2), REGEXEXTRACT(A2,"@(.+)"), IF(ISURL(A2), A2, IF(ISURL(REGEXEXTRACT(A2,"@(.+)")), REGEXEXTRACT(A2,"@(.+)"), "No valid entry" ) ) ) Copy / Paste ...
This formula will do the job: =regexextract(A1;"@(.*)") If no @ is found, the original value is shown. The =regexextract function (documentation) executes the regular expression parameter (@(.*)) against the value of cell A1, and returns the matching group.
Top 50 recent answers are included