text (2000)

Topic

New Reply

Please let me know how to import this excel file or work with it once it has been imported. The original file that they gave me had the part number in one column and then the description. Now it’s coming over combined and they say that this is the only way that the pricing file can come over.

I’ve worked with a csv file a little bit so I tried that. I may not have selected the correct settings but I couldn’t use comma because some of the descriptions use commas, I thought that I could use space because there is a space after each part number but for some reason, that combined part of the other column and I had a bigger mess…

The format seems to be consistent. It comes across as the part number, space, hyphen, space and then description. 3 Samples:
1) N688FL – REFRIGERATOR/LP-AC/FAN-BLK
2) 34220 – AM STYLE PLUS, HIGH BLACK
3) 38218 – SIL+ HI BLK 12V CHR HW RVWS

Any assistance you can offer will be appreciated.
Thanks!

Reply | Quote

Replies

You can import or link to the Excel table. You’ll get the part in one column. Yo can then use a query to split the part into a part number and a description. Let’s say that the combined field is named FullPart.
In th query, you could create a calculated column for the part number:

=Left([FullPart], InStr([FullPart], " - ") - 1)

and for the description:

=Mid([FullPart], InStr([FullPart, " - ") + 3)

This will only work if
– The FullPart field is always filled in, and
– The FullPart field always contains ” – “.

Reply | Quote

Thank you Hans!

Reply | Quote