Hi @Anonymous
As far as I know about regex you use it like a "select query on a string", meaning you'll select/filter the relevant chars from a string. In other words, you can't modify/change contents (at least, I've never seen that kind of implementation PURELY using regex). What I've seen a lot of times is a conjunction of regex with Javascript for the replace part.
That being said, what you could try to do is to retrieve all data as is and then transform the data table in a later stage in order to replace commas for a blank space between the thousand or decimal separator (don't know which system you are using) as already mentioned by others here. Please notice you'll lose your data table structure if you try to directly replace values because replace action expects a string and will return a string. If you need to maintain your data table structure, you have to:
- Use replace to generate a string (let's name it replaced) with the replaced value from data_table[row_index][column_index]
- Use set variable to update the data_table[row_index][column_index] with the replaced value
Something similar to this:
Sample source and data table after replacing values:
Still, I don't see much use cases why you would want to do that because usually when we want to retrieve a value from a data table we do it by reading row by row (and by doing so most of the times you will create a variable, working with a copy of the data table data). The only reason I can see a need for a change in the actual data table values is when you want to update a csv file. I've done it by applying the technique mentioned above.
