Results 1 to 3 of 3

Thread: text (2000)

  1. #1
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    text (2000)

    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!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: text (2000)

    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:
    <code>
    =Left([FullPart], InStr([FullPart], " - ") - 1)
    </code>
    and for the description:
    <code>
    =Mid([FullPart], InStr([FullPart, " - ") + 3)
    </code>
    This will only work if
    - The FullPart field is always filled in, and
    - The FullPart field always contains " - ".

  3. #3
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: text (2000)

    Thank you Hans!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •