The Nanoscale World

splitting 1 column of data into multiple columns after ascii export

rated by 0 users
Not Answered This post has 0 verified answers | 4 Replies | 3 Followers

Top 100 Contributor
9 Posts
Points 100
Bruker Employee
Mayur Savla posted on Sat, Oct 1 2011 7:22 AM

I have a 512 lines and 1024 samples per line raw image.

I was able to export data using nanoscope analysis ascii export function.

The data gets exported as 1 coulum with 1024*512=524288 rows.

Is there a way to split the data so that I have 512 rows (representing the number of lines in my scan) and 1024 columns (representing samples per line in my scan) in excel or any other software?

  • | Post Points: 14

All Replies

replied on Sat, Oct 1 2011 6:24 PM

Sounds like a good training exercise for using Python Mayur.

  • | Post Points: 10
Top 10 Contributor
288 Posts
Points 3,905
Bruker Employee

 

Mayur,

 

There is an option as part of the ASCII export to select the number of columns to export. Select only one data channel to keep it simple. Did you try this?

 

Steve

  • | Post Points: 12
Top 100 Contributor
9 Posts
Points 100
Bruker Employee

I did , when you have 1 channed and you increase the number of colums it adds empty columns and the 1st cloumn is the only one with data.

  • | Post Points: 12
Top 10 Contributor
280 Posts
Points 6,221
Bruker Employee

If you use Format Columns =1024 during ASCII export, NanoScope Analysis creates a text file of 1024 columns, each 30 characters wide. 

Excel has difficulty dealing with such a wide spreadsheet.  I tried using Data>Get External Data From Text to import a 1024x1024 and it gave a message that the data set was too large to fit in a single worksheet (and then it only imported 256 columns).  If you first import the data and then use the "text to columns" delimited by spaces it makes some rows that are very short (9 columns) and some that are very long (1024 columns). 

If you look at the same file with a good text editor (not notepad, I use SciTE), you can see that all of the data is there in the exported text file.  Maybe Python or MatLab or Igor is a better choice for analysis than Excel...

--Bede

  • | Post Points: 10
Page 1 of 1 (5 items) | RSS
Copyright (c) 2011 Bruker Instruments