how to add quotes each word in string(these are my attributes name)

sgnarkhede2016

how to add quotes each word in string(these are my attributes name)

e.g.
query=Sachin,Amit,Clara,Josef'

它应该转换成
query='Sachin','Amit','Clara','Josef'

kayman

\^ escapes your special symbol, so instead of starting at the beginning of your attribute (what would happen with ^) your expression is now looking for the character ^ instead.

You will also only find matches that are word + word, so if your attribute is existing of a single word it will fail also.

What would probably work better is something like this :

^(.*)$ which means just select my whole attribute value from beginning to end, and replace with "$1" , so quot + stored result + quote

(删除ed User]

@sgnarkhede2016

Hello

I think you can use Replace operator. Read the document please and take a look at other link
https://docs.www.turtlecreekpls.com/latest/studio/operators/blending/values/replace.html

https://community.www.turtlecreekpls.com/discussion/comment/63890#Comment_63890

I hope this helps
mbs

sgnarkhede2016

but in replace operator i need to pass "regex" it not working for me
e.g
Sachin N
Jonn Clara

I have passed "replace what" \^(\w+ \w+)
"replace by" \("\w+ \w+")

I want above string as "Sachin N" and "John Clara"