- Posted by
- I figured out the solution, had to do the following: Had to leave it formatted as 000085.7Q in the text editor. Dropped it into Excel and did the Find/Replace to leave it formulated as 000085.78- ensuring all the columns in question were formatted as TEXT. Imported into an Access temporary table whe...Posted in Scripts
-   Topics
-   Views
- SirRoshua
Apr 13, 2008
- :!: I have tried everything I know to convert an EBCDIC Character Overpuch Currency Value into ASCII format with a floating point leading sign value. For example, the following is the original state of the value (the comma I have added to seperate fields as a precursor of an import into SQL): 000089...Posted in Scripts
-   Topics
-   Views
- SirRoshua
Apr 12, 2008