Forum Discussion

StephenStephen's avatar
StephenStephen
Qrew Assistant Captain
9 years ago

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

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?
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    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.