Replace dot in datafusion wrangler not working

Question

I need to remove dots from a number in Google DataFusion. For this I'm using the Wrangler transformation, but I'm having troubles with one file, because if I replace the dots, the whole cells gets empty. If I replace any other character, it works. What can be the trouble?

Thanks!

Original Value: After replacing dots (.) :

Same cell/row but replacing spaces and number 1

Answer 1

The find and replace function of the wrangler is similar with "sed" wherein it applies regular expressions.

Period (.) matches any character except a newline character.

Here is the original data:

I tried this on my own project and here is the result when using the un-escaped period:

You need to escape the period symbol (.) so it will treat it as a regular period. Here is the result when escaping period:

As you can see, the period(.) was removed before "jpg".