Batch file extraction

Microsoft Visual basic professional ed 6...
January 15, 2010 at 00:41:44
Specs: Windows XP
Hi,

I have a pool of .csv files coming from a measurement system, and as there are hundreds of those, I'd like to automate the extraction of certain values in certain columns of those files.

INPUT .csv files with columns of several values

INTERFACE: sth like a classical windows explorer where you choose the files that must be processed

OUTPUT table with one column "file name" and one column "value"

Is it technically possible with VB? Is any language better?

THx a lot for ur answer
J.S.


See More: Batch file extraction

Report •

#1
January 15, 2010 at 05:30:24
Is it technically possible with VB?
Yes.

Is any language better?
The hardest part of what you're asking is the interface, and VB makes that part fairly easy. The actual work sounds like simple text parsing. It's really a question of what language you're more comfortable with.


Report •

#2
January 15, 2010 at 05:56:21
Right thank you. I'm just beginning with programming actually, and I started with VB, I heard it's good as a start, so that's why...

Maybe that's text parsing, yes? On several files at the same time.

And I was just wondering if it was possible with VB to get a table (like an Excel table) as an output?

If yes, then I'll try and find all infos to help me program it in VB!


Report •

#3
January 15, 2010 at 06:14:07
Well, if you don't care about the interface, you can use just about any scripting language. Hell, give us enough detail (and usable testing data), and someone'll probably write you a script.

I started with VB, I heard it's good as a start
Honestly? C# is probably a better idea; there's more out there for that language.

And I was just wondering if it was possible with VB to get a table (like an Excel table) as an output?
.NET has classes like DataGridView, which may or may not be what you're looking for.


Report •

Related Solutions

#4
January 15, 2010 at 06:24:20
Thx a lot for your offer! But I want to learn how to do it, I don't think it is that complicated, and such "mircroprojects" are good exercices for beginners, are they?

I also heard a lot about C#, maybe that would be a better choice, I have to see... there's maybe also a free version like VB Express Edition, which I found very good.

What is exactly .NET?

As far as I understood, .NET are new useful functionalities that MS gave to several languages (C#.NET, VB.NET etc.). I've been told that .NET is not about the language itself and its result, but about the way you like to program. Did I understand it good?


Report •

#5
January 15, 2010 at 07:25:36
such "mircroprojects" are good exercices for beginners, are they?
I find a good book on the subject a better start, but I don't have any recommendations right off hand.

there's maybe also a free version like VB Express Edition
Yes, there are Express Editions for each VS offering.

What is exactly .NET?
You can read MS' official spiel on MSDN, but basically it's how Microsoft currently wants you to write Win32 and Web applications.


Report •

Ask Question