How to remove duplicates of values after 'extract by pattern'?

[botbuilders_tech]

I use regex to extract some tracking IDs from webhook input.
when using advanced response option, I am getting the below Result

["GTM-NDL2SG5","GTM-NDL2SG5","GTM-NMW4Z2Z","GTM-PLMC79W","GTM-P3DB5M4","UA-81353324-1","AW-877300671"]

as you can see, there is a duplicate value in the above line.
How can I remove this duplicate?

I tried to use spreadsheet formula, but it doesn't work.
any workarounds for this?

 

[Pabblymember11]

Hey @botbuilders_tech

You can try using the "Text Formatters" Extract Pattern action event to extract the unique values from your string.

For this, you can refer to some of the online Regular Expression tools available.

RegExr: Learn, Build, & Test RegEx

RegExr is an online tool to learn, build, & test Regular Expressions (RegEx / RegExp).

regexr.com

regex101: build, test, and debug regex

Regular expression tester with syntax highlighting, explanation, cheat sheet for PHP/PCRE, Python, GO, JavaScript, Java. Features a regex quiz & library.

regex101.com

I hope this might help you out.

Thanks