Results 1 to 2 of 2

Thread: Exporting from excel into a specific format

  1. #1

    Smile Exporting from excel into a specific format



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,


    I'm new here, so sorry if I've posted in the wrong place, and I know nothing about computers so sorry in advance if this is a stupid question. I'm trying to export data from excel in a specific format. I've attached an example of what the excel file looks like. The format I want it to be in is in the first text file (samp_inp_2b.txt). When I export from excel as unicode or tab delimited it results in the second text file (sample2db.txt). As far as I can tell the two text files are the same but the line breaks are different, in the first one the linebreaks are there but don't display for some reason (at least in notepad). Does anyone know how to export data from excel to get the first text file format? If anyone knows how to directly convert between the 2nd and 1st text files that would also do the job.
    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Excel Version
    Office 365
    The easy answer is to use Unix2Dos /Dos2Unix see http://unix2dos.win7dwnld.com/
    Dos (i.e. windows) finishes of with an end of row and a line feed (second file) whilst the first only uses end of line, see http://stackoverflow.com/questions/2...-unix-mac-os-x
    (sorry rushing off to a meeting)

Posting Permissions

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