Pulling text out of filenames into a spreadsheet

  • Thread starter Thread starter Lavern Gingerich
  • Start date Start date
L

Lavern Gingerich

I have a folder with a lot of CorelDraw files. Each file
contains a cassette tape label for the tapes we are
offering. Each filename contains an id number and the
title of the cassette tape.

Here is the problem: I need to extract that information
into a tab-delimited file or even a plain text file would
be fine. It would save me time if I could just go through
some simple procedure to capture that information. I know
how to copy and paste each file name at a time into a
text file, but I want to do the whole thing at one time.
Is this possible?

Thanks for your help,
Lavern Gingerich
www.lighthousepublishing.org
 
I forgot to mention that if the cmd window opens to a path other than the
root, type the following and hit enter:

cd\

--
Regards,
Matt Y.
(e-mail address removed)
sfl=schwagfl / nospam8675309=yahoo

"You know what they say, 90% is mental and the other 10% is all in your
head."
 
-----Original Message-----

For this example lets start in the root of the c drive (c:\) and we want to
navigate to a folder named vacation that's buried under
c:\documents\pictures\.

There are a few ways to do this in the cmd window but I'm going to go one
step at a time.

At the C:\> prompt in the cmd window type (w/o the quotes):

"cd documents" then hit enter
"cd pictures" then hit enter
"cd vacation" then hit enter

Your cmd prompt should end up looking like this:

c:\documents\pictures\vacation>

From there type the command "dir /b > <filename>.txt"

For more commands you can issue from the cmd prompt type "help"

--
Regards,
Matt Y.
(e-mail address removed)
sfl=schwagfl / nospam8675309=yahoo

"You know what they say, 90% is mental and the other 10% is all in your
head."


.
Thank you so much. I really appreciate your help!
Click to expand...

JESUS is the ONLY way, the ONLY truth, the ONLY life.
 
Back
Top