Urgent Help:read from text file and write to table

[kingehp]

Hi,

I'm a super beginner looking for a vi to read this data from a text file and insert it into a table:

   #19

Date: 05-01-2015

ID= 12345678

Sample_Rate= 01:00:00

Total_Records= 2

Unit: F

   1 03-23-2015 10:45:46   70.1   3.6

   2 03-23-2015 11:45:46   67.7   2.7

Output table

#     date                 time                 x          y        Sample rate    Total Records

1          03-23-2015     10:45:46        76.8     2.8      01:00:00           2

2          03-23-2015     10:45:46        48.7     2.1      01:00:00           2

Thanks for your help in advance.

[mikeporter]

What do you mean by table? There are several potential meanings of the term.

Mike...

[kingehp]

---

@mikeporter wrote:
What do you mean by table? There are several potential meanings of the term.

Mike...

---

Ok. Let me be more specific.

I need to have each column as an 1-D array. My end use would be inserting into a database.

[nyc_(is_out_of_here)]

You have to start somewhere. http://www.ni.com/academic/students/learn-labview/

[jcarmody]

Will there always be the same number of rows of noise header information?

Show us how you've read the data and what you've tried to do to parse it.  Once you've got the last rows, you can loop over them using Spreadsheet String to Array (after cleaning up a few messy spaces).

[kingehp]

LOL. I know the basics.

Any real solutions?

[kingehp]

---

@jcarmody wrote:

Will there always be the same number of rows of noise header information?

Show us how you've read the data and what you've tried to do to parse it.  Once you've got the last rows, you can loop over them using Spreadsheet String to Array (after cleaning up a few messy spaces).

---

Jim,

I didn't know you're that active on here.

Yes, There will always be the same number of noise header information.

I'll show you in person 🙂

Regards,

[nyc_(is_out_of_here)]

---

@kingehp wrote:

LOL. I know the basics.

Any real solutions?

---

Solutions come from knowing the and applying the basics.

[Bob_Schor]

What is your goal?  If it is to learn LabVIEW, then give it a try, write some LabVIEW code that you think might apply to your problem, show us what you've got, and ask for specific help.  If it is to purchase a canned program to solve a problem, there are more appropriate sites to use to hire a LabVIEW programmer ...

Bob Schor