ASCII Import Help

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

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"
 
Hi Matt,

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

Dan
 
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.
 
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
 
Back
Top