From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

append several tab-limited files

Say, right now I have 3 text files as below,

Temp & RH 10-m Interval Average Data For 11/18/2001
Date Time Temp Humd
11/18/01 00:13:43 20.02 58.04 *
11/18/01 00:23:43 19.99 58.17 *
11/18/01 00:33:43 19.97 58.11 *
11/18/01 00:43:43 19.94 58.13 *
11/18/01 00:53:43 19.95 58.04 *

Temp & RH 10-m Interval Average Data For 11/19/2001
Date Time Temp Humd
11/19/01 00:13:30 20.16 59.57 *
11/19/01 00:23:30 20.17 59.42 *
11/19/01 00:33:30 20.11 59.5 *
11/19/01 00:43:30 20.07 59.57 *
11/19/01 00:53:30 20.03 59.59 *

Temp & RH 10-m Interval Average Data For 11/20/2001
Date Time Temp Humd
11/20/01 00:13:17 23.1 59.39 *

11/20/01 00:23:17 23.18 58.96 *
11/20/01 00:33:17 23.55 58.43 *
11/20/01 00:43:17 23.61 58.43 *
11/20/01 00:53:17 22.75 59.62 *


can anyone advise me how can I append all the files become

Temp & RH 10-m Interval Average Data For 11/18/2001 to 11/20/2001
Date Time Temp Humd
11/18/01 00:13:43 20.02 58.04 *
11/18/01 00:23:43 19.99 58.17 *
11/18/01 00:33:43 19.97 58.11 *
11/18/01 00:43:43 19.94 58.13 *
11/18/01 00:53:43 19.95 58.04 *
11/19/01 00:13:30 20.16 59.57 *
11/19/01 00:23:30 20.17 59.42 *
11/19/01 00:33:30 20.11 59.5 *
11/19/01 00:43:30 20.07 59.57 *
11/19/01 00:53:30 20.03 59.59 *
11/20/01 00:13:17 23.1 59.39 *
11/20/01 00:23:17 23.18 58.96 *
11/20/01 00:33:17 23.55 58.43 *
11/20/01 00:43:17 23.61 58.43 *
11/20/01 00:53:17 22.75 59.62 *


thank you in advance
0 Kudos
Message 1 of 3
(2,267 Views)
You'll have to read the data from the three files and use the string functions to strip the strings apart and reassemble them how you want. See the attached vi for an example to get you started.

Good luck
Brian
0 Kudos
Message 2 of 3
(2,267 Views)
Raymond,
Read each file into array of 4 columns as you have in the example, then use
the Build Array function to concatenate them then save the concatenated
array into file.
Nam.
Raymond Fang wrote in message
news:d3203a1a.0112052340.b3d7fcd@posting.google.com...
> Say, right now I have 3 text files as below,
>
> Temp & RH 10-m Interval Average Data For 11/18/2001
> Date Time Temp Humd
> 11/18/01 00:13:43 20.02 58.04 *
> 11/18/01 00:23:43 19.99 58.17 *
> 11/18/01 00:33:43 19.97 58.11 *
> 11/18/01 00:43:43 19.94 58.13 *
> 11/18/01 00:53:43 19.95 58.04 *
>
> Temp & RH 10-m Interval Average Data For 11/19/2001
> Date Time Temp Humd
> 11/19/01 00:13:30 20.16 59.57 *
> 11/19/01 00:23:30 20.17 59.42 *
> 11/19/01 00:33:30
20.11 59.5 *
> 11/19/01 00:43:30 20.07 59.57 *
> 11/19/01 00:53:30 20.03 59.59 *
>
> Temp & RH 10-m Interval Average Data For 11/20/2001
> Date Time Temp Humd
> 11/20/01 00:13:17 23.1 59.39 *
> 11/20/01 00:23:17 23.18 58.96 *
> 11/20/01 00:33:17 23.55 58.43 *
> 11/20/01 00:43:17 23.61 58.43 *
> 11/20/01 00:53:17 22.75 59.62 *
>
>
> can anyone advise me how can I append all the files become
>
> Temp & RH 10-m Interval Average Data For 11/18/2001 to 11/20/2001
> Date Time Temp Humd
> 11/18/01 00:13:43 20.02 58.04 *
> 11/18/01 00:23:43 19.99 58.17 *
> 11/18/01 00:33:43 19.97 58.11 *
> 11/18/01 00:43:43 19.94 58.13 *
> 11/18/01 00:53:43 19.95 58.04 *
> 11/19/01 00:13:30 20.16 59.57 *
> 11/19/01 00:23:30 20.17 59.42 *
> 11/19/01 00:33:30 20.11 59.5 *
> 11/19/01 00:43:30 20.07 59.57 *
> 11/19/01 00:53:30 20.03 59.59 *
> 11/20/01 00:13:17 23.1 59.39 *
> 11/20/01 00:23:17 23.18 58.96 *
> 11/20/01 00:33:17 23.55 58.43 *
> 11/20/01 00:43:17
23.61 58.43 *
> 11/20/01 00:53:17 22.75 59.62 *
>
>
> thank you in advance
0 Kudos
Message 3 of 3
(2,267 Views)