Stripping Unicode

AETLP x32 v6.3.7.30

Hi

We are getting a file that has a Unicode character in it which I need to strip (or replace with blanks). I have attached some screen shots of me trying a RegEx that works on a RegEx Testing site I use but it doesn;t seem to give the desire result in AETL.

Any ideas?

I could go the other way and specify the characters I need to keep. But thought it would be good to see if I can do itt hrough exclusion first.

Can you attach a file example please

Hi.

I have attached a sample csv file and an AETL .ATS file as well to show the transformation elements I have tried including Replace RegEx

Without going into specifics (and back story) the value that is coming through is actually a Bullet Character which are popular in PDF files.

The easy workaround is to use the Keep Characters Transformer and specify all of the ASCII Printable characters. this is easy and reusable.

One of the RegEx Replace Transformation Actions gives an odd result in that the expression [\x00-\x1F]|[\x7F-\xFF] just about does what I need except that one portion of the input string is not 'replaced'.

Open data reader properties and set source file encoding to UTF8
Then use the delete characters function to remove •
That would be the fastest option

Thanks.

Yep that would be the quickest and most intuitive. But how did you get the Bullet point in the text box?

I ended up copying from your post via the browser dev tools

cheers

I used notepad ++. I think should be also possible to copy it from data reader grid