"Insight - Asset Management": regular expression in import configuration

[Sebastian]

Hi,

I need help preparing a regular expression that will allow me to get unique values ​​between the "," sign relative to the total. I would like to use this expression for this

(?=)(.+?)\,(?=(.+\,)?\1(\,|$1))

unfortunately, to achieve this you need to use the "replace" function described in javascript. Unfortunately I haven't found any about this in relation to Jira and Insight.

[Chris Schneider]

Best way to learn about regex is one of those website, where you can prepare and test your regex. I prefer: regex101: build, test, and debug regex.

[Peter-Dave Sheehan]

What type of data source are you importing from? If it's a database, maybe you can split the data in your selector/sql statement