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