Escaping quotes

From Planfix
Jump to: navigation, search

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="">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:

All escapable special characters

Written Inside the String Remains After Processing
\" -> "
\\ -> \
\n -> newline character
\t -> newline character

Go To