Importing a file with both UPC Code (12 digits) and a Field containing COMMAS to CSV

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
We have a field called "Catalog Description" that is a multi-line Text field that often contains commas. There is another field called "UPC" that is 12-16 digits.

1. To avoid the UPC being converted to Scientific Notation when opening in Excel, you must used the "Import" function.  You then select "Comma" as the delimiter and mark the UPC field as TEXT (Not General) and then import. This correctly formats the UPC Code field on import.

2. However, This is causing export errors for the "Catalog Description" field that holds many commas, causing the rest of the data columns to be mis-imported. Any thoughts?
Photo of Stephen

Stephen

  • 760 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
I know this will add a step, but what if you import them in two different imports?

I'm assuming you have some unique field that is deciding the "key" field.  (I hope its not one of these 2 in question, if so, forget this idea)

But if it works you can import two different excel files as a possible work around.

Where is the data coming from?  you might consider an integration if at all possible.