Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Exporting data as a pure single text stream - challenge

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need to export a load of sheets for importing into an EDI system. I have tried with various text, tsv, csv files with various delimiters.
    I can get each line of the sheet exported correctly but I actually need the whole file on a single continuous data stream (ie no line breaks)
    There can be several hundred lines on the sheet.
    I could happily put everything on a single line in the spreadsheet and then save as a csv however I doubt there are enough columns to support the size of the sheet
    Does anyone know how to do this either with an export, macro/vba or even an external programme that takes my csv and converts the line breaks to commas

    Thanks
    Rob

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    There are size limitations to strings, however, this could easily be resolved with a binary write to a file.
    Post a sample of your data.
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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