Results 1 to 4 of 4

Thread: Nanocom CSV file

  1. #1
    Join Date
    Dec 2016
    Location
    New Lambton, NSW
    Posts
    698
    Total Downloaded
    0

    Nanocom CSV file

    Hi,

    Just downloaded some input fuelling mode file from the nanocom and they will not display as a table in excel?? appear to have ; in the spaces between the numbers and all numbers are combined in one cell/line????


    I've logged files previously in instrument mode and these display without manipulation i.e. just open and headers line up with readings etc.

    Any ideas??

    Cheers Lemo

  2. #2
    Join Date
    Jan 1970
    Location
    Perth WA 6149
    Posts
    1,308
    Total Downloaded
    0
    The nanocom unfortunately uses a non standard CSV format.

    In excel delete the first couple of lines till you reach the header name row. Select the column with the data and go to the data tab and select convert text to rows, choose delimited and select ; as the delimiter click ok and you should be ok.

    As I'm in the iPad the above is from memory but it should be close enough that you'll be able to muddle through.

    cheers

    Steve

  3. #3
    Join Date
    Jul 2014
    Location
    west of Transylvania
    Posts
    3,534
    Total Downloaded
    0
    Save the CSV file in the computer, open excell blank page, go to Data - File - "From text" select the csv where you saved it and open next as "delimited", put ; as "others" delimiter then next and finish
    Discovery Td5 (2000), manual, tuned

  4. #4
    Join Date
    Dec 2016
    Location
    New Lambton, NSW
    Posts
    698
    Total Downloaded
    0
    Quote Originally Posted by sierrafery View Post
    Save the CSV file in the computer, open excell blank page, go to Data - File - "From text" select the csv where you saved it and open next as "delimited", put ; as "others" delimiter then next and finish
    Thanks!! Worked a treat!!

    Cheers Lemo

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search AULRO.com ONLY!
Search All the Web!