CSV Export and Data Parsing

Hi all!
Looks like this is the correct forum after looking at other posts.

I have a program that exports inventory in a space delimited text file...Example

STK DESC.
0000A1001 Item number 1
0000A1002 Item number 2
000001003 Item number 3 but no alpha in item number

So basically what happens is I import this data into excell to clean out some garbage, export it to CSV to import into many other applications. Pain in the butt I know, but need to do it anyhow.

When I export to CSV the stock numbers with alpha's in them keep the leading zeros. The stock numbers without alpha's remove the zeros(assuming it's because it's a true number and excel figures it's not needed at export time).

The deal is this, when I then import this file into the new applications, some of them deside to then go further and rip more zero's off the alphas, and some do not. Which creates a problem, because we then send images file named by the stock number. Now i have two different applications that require two different file names( 0000A1001.JPG and A1001.JPG) to match up properly.

To simplify this and make this long story short.
I need to rip all the zeros out of both the numeric and alpha stock numbers prior to exporting


Thanks
Josh

Josh,

If the stock numbers are all uniform, then after importing
the file, do a text to column (Data/Text Columns) on the
column containing the stock numbers. Use the fixed width
options and put a break just before the Alpha.

Charlie O'Neill

-----Original Message-----
Hi all!
Looks like this is the correct forum after looking at
other posts.

I have a program that exports inventory in a space
delimited text file...Example

STK DESC.
0000A1001 Item number 1
0000A1002 Item number 2
000001003 Item number 3 but no alpha in item
number

So basically what happens is I import this data into
excell to clean out some garbage, export it to CSV to
import into many other applications. Pain in the butt I
know, but need to do it anyhow.

When I export to CSV the stock numbers with alpha's in
them keep the leading zeros. The stock numbers without
alpha's remove the zeros(assuming it's because it's a true
number and excel figures it's not needed at export time).

The deal is this, when I then import this file into the
new applications, some of them deside to then go further
and rip more zero's off the alphas, and some do not.
Which creates a problem, because we then send images file
named by the stock number. Now i have two different
applications that require two different file names(
0000A1001.JPG and A1001.JPG) to match up properly.

To simplify this and make this long story short.
I need to rip all the zeros out of both the numeric and
alpha stock numbers prior to exporting


Thanks
Josh

.