Consulting

Results 1 to 4 of 4

Thread: Import Text File Problem

  1. #1

    Import Text File Problem

    Hi,

    I have a large text file that I am having a problem importing because it has a funky delimiter. Here is a slice. Can anyone help?

    Thanks

  2. #2
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Can't you just use the | as the delimiter?

    It's available on the keyboard.

    On mine it's above the \ next to Z.

  3. #3
    Norie,

    Thanks!

    For some reason my | key is chipped or something so the vertical line looks broken in the middle. Ergo, I thought it was something completely different. However, after you said that you had it on your keyboard I figgered I HAD to have it on mine too.

  4. #4
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    I don't think it is chipped.

    It looks like that on my keyboard too.

    I'm trying to remember what the symbol is actually called, I think it might be a 'pipe'.

Posting Permissions

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