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 |
Hi @hellyars
Perhaps I'm not understating, but can you get away with using?: Replace([TXT], "€“", "-")
@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).
User | Count |
---|---|
63 | |
28 | |
23 | |
23 | |
22 |