I have a CSV file with data having special character in it. I want this special character to be converted to normal character.
For example : Ñewton to Newton
Have you tryed with Data Process Shape, search/replace ?
Yes, Leif that option works, but in that case i have to do it for all the 26 letters.And also sometimes the character will have 2 dots(..) above the character.So is there any other way that i can do it
Okay. In that case you could pass it through a Groovy Script in a Data Process Shape.
Is there any class i need to import to perform this.
Try to take a look at this:
Removing characters from a field using Groovy
Happy to help.
Retrieving data ...