0

How to remove special characters from a string in Data Modeler?

Sometimes when you are importing data from a source, a column may have non-alphanumeric characters (aka special characters). How can I remove these characters?

For example, if I have a column called Description and one of the rows has a value of Product-123@100XTY_v1.  I would like to return Product 123 100XTY v1.

1 reply

null
    • Jason_Picker
    • 3 yrs ago
    • Reported - view

    One way to do it would be to use the Replace node and leverage the Regular Expression or REGEX syntax.  Here is an example:   [^0-9a-zA-Z]+

     It will remove all the special characters.  On the "Replace with" property you can leave it blank or you can just add a space.

Login to reply

Content aside

  • Status Answered
  • 3 yrs agoLast active
  • 1Replies
  • 15Views
  • 1 Following