ASCII Import Help

[mattc66 via AccessMonster.com]

Hi All,

I have some data that comes to me in an ASCII format. Below is a sample. The
trouble is the data ontains double quotes used to identify Inches. But the
ASCII format deliminats using double quote and comas. Is there a way to
control the import so that I don't loose that data. What is happening now is
if it finds data like the below it this it's at the end of the line right
after the 48" as seen in the below example.

"3155-01","THERMOSTAT,48" CAP,EA5L-48",80,0.00,0.000,22.735,23.510,"EA"
"3155-02","THERMOSTAT,84" CAP,EA5L-84",80,0.00,0.000,18.300,23.510,"EA"

 

[dan dungan]

Hi Matt,

How many records are you working with? Is it static data or will you
get new files to import regularly.

Dan

 

[mattc66 via AccessMonster.com]

There is about 2000 lines of data. Is it static? It comes from the same
source, but the information can changes, like the product descriptions and
the cost and qty. The number of feilds doesn't change. However the issue is
at times the user may place the double quote for inches and the ASCII import
thinks that is a line break order feild break.

 

[dan dungan]

Hi Matt,

If you have text pad you can scrub that file with search and replace.

Textpad has a free trail download.

I'm going home now but I'll check in tomorrow.

Dan