Hi @JMP - I am looking at ratings and review text from certain products. Some of the reviews are duplicated, but the text string within each cell is different. I noticed this when sorting the table and looking at individual cells. See below for example:
"A holy grail whether Im traveling or at home I must always have with me. They offer this product literally anywhere I\u2019ve travelled in the world so I appreciate the global continuity." - Row 1
"A holy grail whether Im traveling or at home I must always have with me. They offer this product literally anywhere I’ve travelled in the world so I appreciate the global continuity." - Row 2
It looks like "\u2019" is substituted for " '(apostrophe)". Is there way in JSL with "if" statements to search & tag in a new column this "\u2019" text from the full review text.
if :review_text == "%\u2019%", "duplicate", :review_text != "%\u2019%", "original")
// I want to find a portion of the script within in each cell.
Hopefully, you can help guide me on the right JSL code.
Thanks,
Rishi
Your syntax is way off.
See the If() function for conditional action and the Contains() function for character strings.
