How to parse data containing date info and floating number into an excel sheet

[Wan81]

Hi guys,

I am trying to parse/split data as shown below so that i can transfer it to excel. At the end of the day, I need to get a graphical representation of VALUE vs DATE which I would want to display on LabVIEW. I have tried various things. Closest I got was by using Scan using Token but I still do not know how to split the data below into 2 separate columns so that It can be graphed.

Thank you very much in advance..

DATE         VALUE
1981-01-01  2.0812
1981-02-01  2.0869
1981-03-01  2.0988
1981-04-01  2.1105
1981-05-01  2.1491
1981-06-01  2.1439
1981-07-01  2.1579
1981-08-01  2.1699
1981-09-01  2.1442
1981-10-01  2.0977
1981-11-01  2.0610
1981-12-01  2.0530
1982-01-01  2.0607
1982-02-01  2.1095
1982-03-01  2.1213
1982-04-01  2.1329
1982-05-01  2.0886
1982-06-01  2.1379
1982-07-01  2.1464
1982-08-01  2.1594
1982-09-01  2.1671
1982-10-01  2.1984
1982-11-01  2.2123

[Jorge_Amaral]

Hi,

Is this two column in array 2D?

post your part of the code and I complet it for you. Tell me your labview version

[Vikas_K]

You could use the "Spreadsheet string to Array" function and use space (in your data I guess there are 2 spaces) as delimiter.  You can then write the array to a spreadsheet or re-format the two colums appropriately to desplay in LabVIEW.  See the example code.

Hope it helps.
Vikas

[Wan81]

Hi guys,

I'm currently using LabVIEW 8.2. So, I can't open the VI. Anyway, the values are obtained from website. I used data socket to obtain the data after which I took out the data part through string manipulation.

I got the data from this website: http://www.forecasts.org/data/data/EXSIUS.htm

[Jorge_Amaral]

Hello,
I just save Vikas post to labview 8.2.

I think that's enough for you.

[Wan81]

Hey!!

Thanks a lot guys for the help. The attached VI has been useful. 🙂

Ridwan