Home

Data Cleansing – Removing Special Characters From Names and Addresses

I’m wondering if anyone has a best case solution for replacing certain fields (ie non-ASCII characters, for us the typical instance is accented characters that are common in certain shipping regions).

Right now we are passing our warehouse a file based on saved search that needs non-ASCII characters removed or replaced. I could write up a long series of replace()functions to do this but feel like there is a better way. Maybe even an API call that does data cleansing?

We utilize Shopify as our e-commerce platform – that would be another point where we could use data-cleansing before orders are imported into NS.

Rookie Asked on January 21, 2021 in Other.

Steveklett

Are you using Celigo for Shopify <> NetSuite integration? If so a script in IO would be a good solution and easy.

If not or you want to try doing it in NetSuite, you can see if you can use the SQL function 


REGEXP_REPLACE

https://www.techonthenet.com/oracle/functions/regexp_replace.php

on January 22, 2021.
Cancel
Add Comment
Cancel
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor