EscapeRegex / String Layer

Escape special regex metacharacters in strings to create literal pattern matches. Similar to Python's re.escape(), Rust's regex::escape(), or R's quotemeta(). Ensures strings can be safely used as literal patterns in regex operations.

Escapes the following characters:

. ^ $* + ? () [] ∣ < / l i >< l i > A n yo t h erre g e x m e t a c ha r a c t ers < / l i > C o mm o na ppl i c a t i o n s :< l i > P re p a r in g se a rc h t er m s f orre g e x ma t c hin g < / l i >< l i > M akin g l i t er a l s t r in g p a tt er n sre g e x - s a f e < / l i >< l i > P rocess in gu ser in p u t f or t e x t se a rc h < / l i >< l i > B u i l d in g d y nami cre g e x p a tt er n s < / l i >< l i > S ani t i z in g d a t a f or p a tt er nma t c hin g < / l i >< l i > C re a t in g e x a c t ma t c h p a tt er n s < / l i > E x am pl e t r an s f or ma t i o n s :< l i > h e ll o . w or l d \to h e ll o . w or l d < / l i >< l i > (d a t a) \to (d a t a) < / l i >< l i > [2023] \to [2023] < / l i >< l i >$ 19.99 → $19.99

Table

Select

column

The string column to escape. Common input types:

File paths (C:\folder\file.txt)
URLs (http://example.com/path?q=1)
Product codes (A-123.45+)
Version numbers (2.0.1-beta)
Mathematical expressions (x+y*z)
File patterns (*.txt)

AsColumn

name

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.