Hi,
I think this is a easy question to the experts in Regex, I'm not one of them.
I will get rid of a comma with help of Regex in a Queries. The data I have are 5,555 and I will have a results as 5555 instead. I have tried lots of syntax but with no good luck.
Any suggestions where I also can dig deeper into Column manipulations?
Br,
Thomaz
Tom Waterbley [SLC] [DevOps Catalyst] Answered question 2 days ago
Hi Thomas,
I thought it would be possible with a regex like '^(([^,]*)(?=,)?)+$', but apparently that doesn't work. The problem is that a regex match is always consecutive. It's not possible to skip characters.
A custom operator or ad-hoc data source will probably be needed to achieve what you want.
Kind regards,
Tom
Tom Waterbley [SLC] [DevOps Catalyst] Answered question 2 days ago