Replace command -Ignore case

[shugup2923]

How can we use case insensitive value in Replace command-
| replace "name" with "entity" in description

will it replace name , NAME, Name, NaMe etc with entity ????

If not how can we ignore case with replace command.

[renjith_nair · Accepted solution]

@shugup2923

Try

| eval description=replace(description,"(?i)name","entity")