We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dealing with reisidule character (hyphen) issues

hellyars
13 - Pulsar

I have a text format input issue.

 

I am importing 20 plus text files compiled by copying and pasting tables from a single PDF source.   (I have the Intel Suite, but the Computer Vision tools do not work with these simple tables.)  I set up a batch macro to process each table (as they are formatted the same).  I have Code Page set to ANSI - Latin I.   This works for the majority of the input files.   But, in the case below it does not.  There should be a hyphen between AH and 64.   How can I search out and find these hold outs post-input?  Note: I can resolve the issue for this file switching to UTF-8, but then all the hyphens in the other files are messed up.

 

 

 

Inputs As.. using ANSI - Latin 1

 

Should be...

AH€“64 APACHE BLOCK IIIA REMAN

AH-64 BLAH BLAH

 

2 REPLIES 2
HomesickSurfer
12 - Quasar

Hi @hellyars 

 

Perhaps I'm not understating, but can you get away with using?: Replace([TXT], "€“", "-")

hellyars
13 - Pulsar

@HomesickSurfer  because I don't want to have to hunt and find every instance and variation of the same text translation error.  But, your solution does work (no complaints in that direction).

Labels
Top Solution Authors