Lovely!

Thanks a million.

I need to clean some fields from unwanted characters.
My thoughts was to just create a string expression in my existing tMap, and I came up with this:

StringHandling.CHANGE(row1_with_new_CRC.email,"\\","")

It is supposed to remove backslash from "dirty" email addresses.


This results in an error:

Exception in component tMap_1
java.util.regex.PatternSyntaxException: Unexpected internal error near index 1
\
^
    at java.util.regex.Pattern.error(Pattern.java:1730)
        ...
        ...



Is there another way to identify and remove backslashes in a tMap?



- update -
With the tReplace component a search for "\\" and replace with "" is possible,
but it would be much more tidy to do this within tMap

Any ideas why StringHandling.CHANGE(row1_with_new_CRC.email,"\\","")  is generating the above error?

- end update -



Regards,