Search code examples
google-cloud-data-fusion

Replace dot in datafusion wrangler not working

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: enter image description here After replacing dots (.) : enter image description here

Same cell/row but replacing spaces and number 1 enter image description here

Solution

  • 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: enter image description here

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

    enter image description here

    enter image description here

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

    enter image description here

    enter image description here

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