parsing tab delimited text files using windows scripting

[Jog On]

Been looking for a basic tutorial on how to do this,

I'm using winautomation to script a bunch of tasks and one of them is to read plain text in tab delimited csv files and then copy and paste it here and there.

is there a good, easy-to-follow tutorial anyone can point me in the direction of?

[Spacecadet]

Been looking for a basic tutorial on how to do this,

I'm using winautomation to script a bunch of tasks and one of them is to read plain text in tab delimited csv files and then copy and paste it here and there.

is there a good, easy-to-follow tutorial anyone can point me in the direction of?

use log parser
http://www.microsoft.com/downloads/d...displaylang=en

[NickFitz]

Been looking for a basic tutorial on how to do this,

I'm using winautomation to script a bunch of tasks and one of them is to read plain text in tab delimited csv files and then copy and paste it here and there.

is there a good, easy-to-follow tutorial anyone can point me in the direction of?

If LogParser doesn't do what you need, answer the following questions and I'll write a good, easy-to-follow tutorial for you, with working code

1. When you say "tab delimited csv files", am I right in assuming that you mean "tab separated values", and that commas (as in "comma separated values") don't come into it?

2. What do you mean by "copy and paste it here and there"? Do you mean opening other text files and inserting or appending values, putting stuff in a database, inserting stuff into spreadsheets, or any and possibly all of these?

3. It probably doesn't matter, but what text encoding are these files in - ISO Latin 1, UTF-8, Windows 1252?

4. Does the first line of the file contain the names of the fields? Is it possible that some of them will and some may not, or is it safe to always treat the first non-blank line as having that information?

[Bob Dalek]

If LogParser doesn't do what you need, answer the following questions and I'll write a good, easy-to-follow tutorial for you, with working code

1. When you say "tab delimited csv files", am I right in assuming that you mean "tab separated values", and that commas (as in "comma separated values") don't come into it?

2. What do you mean by "copy and paste it here and there"? Do you mean opening other text files and inserting or appending values, putting stuff in a database, inserting stuff into spreadsheets, or any and possibly all of these?

3. It probably doesn't matter, but what text encoding are these files in - ISO Latin 1, UTF-8, Windows 1252?

4. Does the first line of the file contain the names of the fields? Is it possible that some of them will and some may not, or is it safe to always treat the first non-blank line as having that information?

I think he's been sacked for trashing Domain Controller registries and wiping hard drives.

[Jog On]

If LogParser doesn't do what you need, answer the following questions and I'll write a good, easy-to-follow tutorial for you, with working code

1. When you say "tab delimited csv files", am I right in assuming that you mean "tab separated values", and that commas (as in "comma separated values") don't come into it?

2. What do you mean by "copy and paste it here and there"? Do you mean opening other text files and inserting or appending values, putting stuff in a database, inserting stuff into spreadsheets, or any and possibly all of these?

3. It probably doesn't matter, but what text encoding are these files in - ISO Latin 1, UTF-8, Windows 1252?

4. Does the first line of the file contain the names of the fields? Is it possible that some of them will and some may not, or is it safe to always treat the first non-blank line as having that information?

PM sent!