Escaping quotes
From Planfix
If one of the arguments of a function is a string with quotation marks, then you must escape these internal quotation marks.
FUNCTION ("string \"quotation mark")
For example, there is a string, and you need to obtain a link:
<a href="https://site.com/offer/anglegrinder-1092">Brushless angle grinder</a>
Use the function REGEXPFIND, make sure to escape the inner quotation marks around the link (highlighted in red):
REGEXPFIND({{Task.String for link}};"(?<=href=\").*?(?=\")")
In the end, you will obtain the desired link in the calculated field:
https://site.com/offer/anglegrinder-1092
All escapable special characters
| Written Inside the String | Remains After Processing | |
|---|---|---|
| \" | -> | " |
| \\ | -> | \ |
| \n | -> | newline character |
| \t | -> | newline character |