<@U3N7BKJ79> you could probably do it with `REGEXP...
# suitescriptm
michoel
07/26/2018, 11:23 PM@neerajrtiwari you could probably do it with
REGEXP_REPLACE👍🏼 1
n
neerajrtiwari
07/26/2018, 11:25 PMThanks, I was thinking if REGEXP_SUBSTR will do the trick or not.
neerajrtiwari
07/26/2018, 11:25 PMI will try this.
neerajrtiwari
07/26/2018, 11:29 PM@michoel I looked at answer id: 31804. I guess REGEXP_REPLACE won't work for us as I am not trying to replace keyword with something else. But rather - I am trying to display the unique value (for each row) that follow the keyword.
neerajrtiwari
07/26/2018, 11:30 PMthe field I am evaluating is {message}
m
michoel
07/26/2018, 11:33 PMYou can use capture groups so you match the whole field and replace it with what you want to extract. E.g
^.+Customer Name:(.+)$\1👍🏼 1
n
neerajrtiwari
07/27/2018, 10:37 PMThis helped us. Thank you!
2 Views