Get rid of “Commas”

92 viewsColumn Manipulation RegexMatch
2
0 Comments

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

1 Answer

1
9.13K 0 Comments

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