Jump to content

Formatting output string from SR430 multichannel scalar


tpdk

Recommended Posts

Hi,

I've been trying to format output string from SR430 multichannel scalar into a single column data so that the data can be easily read using excel. The out put from SR 430 is of the form 1.000000e+001,2.000000e+000, 4.000000e+001, ....., and so on. I'm pretty new to LabVIEW and programming in general. Can anyone please help me out? Thanks. The size of the data is about 60KB.

Tpdk

Link to comment

QUOTE(Matheus @ Jul 11 2007, 07:24 AM)

...but to change more easy, use the TAB constant as delimiter, this is more used when we import a TEXT using EXCEL.

I don't agree - Excel handles a range of delimters including TAB and COMMA, and I don't think that either of them is better than the other - it really depends on what you're trying to do.

Link to comment

QUOTE(crelf @ Jul 11 2007, 11:12 AM)

I don't agree - Excel handles a range of delimters including TAB and COMMA, and I don't think that either of them is better than the other - it really depends on what you're trying to do.

I would say using a tab is much better, especially for numerical data. Throughout Europe (and other countries) where a comma is the decimal separator, a comma delimeted spreadsheet could turn into a nightmare!

I typically only use tabs for delimited files.

Link to comment

QUOTE(Jeff Plotzke @ Jul 12 2007, 02:30 AM)

I would say using a tab is much better, especially for numerical data.

Better? Possibly. Much Better? I don't think so. Sure, tabbed data is great for files that need to be easily human readable (everything lines up real purdy), but if the file only needs to be machine readable, then the delimiter is irrevant, as long as there is one and it doesn't appear anywhere in the data. As for the comma being used as a decimal deliniation in Europe - that's true, but I *think* that practise is slowly on the way out - anyone from over the ditch care to comment?

Link to comment

QUOTE(crelf @ Jul 6 2007, 08:33 AM)

Dear Crelf,

I'm sorry for a very late reply. Thank you very much for your help. It works! I used a portion of your code; I used string to array which gives data in a row in excel, not in column. What I did was I changed that array into matrix and chage matrix back to array. I get 2D array back. Then I used write to spreadsheet. Then I got the data in column format. Maybe it's not the best way to do, but it works. I appreciate your help. Thank you.

Tpdk

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.