Exporting / Importing File names from https to Excel / Word

[jaidev.anand]

No, you would paste the script into a text editor and save it as a filename.bat and be careful not to use a system command as the filename.

Then:

Step 1: Create a Text file with the serial numbers as a certain filename
Step 2: Log in to the https link
Step 3: save the web page as text with the list of all the files, and save it as a certain filename.
Step 4: put all the files together and run the batch file, which will create a filelist of the files containing the 8 digit serial numbers.

Good morning Sir,

Sorry to come back again! But I'm some how unable to execute Step 4. Could you please advise what is exactly meant by put all the files together and run the batch file...

Thanks in advance!

[foxidrive]

Tell me what you have done and what error messages occur or what happens.

[jaidev.anand]

Tell me what you have done and what error messages occur or what happens.

I'm sure I did something terribly incorrectly. Here's what I did...

Step 1: Paste the script into a text editor and saved it as a filename.bat (File name = Today)

@echo off
del "output file.txt" 2>nul
for /f "delims=" %%a in (listofserialnumbers.txt) do (
find "%%a" < "list of files.txt" >>"output file.txt"
)
Step 2: Created a Text file with the serial numbers. The file name used is "IDs"
Step 3: Then I logged into the https link
Step 4: Saved the web page as text with the list of all the files (Process: Ctrl + S -> Save Type as Text File). File Name is “Nov 14”
Step 5: Saved 3 Files generated from Step 1, 2 and 4 in C drive
Step 6: I clicked on the Script File – A CMD window opened for a fraction of second and then closed. Nothing happened…


Please advise...

Thanks

[foxidrive]

I'm sure I did something terribly incorrectly. Here's what I did...

Step 1: Paste the script into a text editor and saved it as a filename.bat (File name = Today)

@echo off
del "output file.txt" 2>nul
for /f "delims=" %%a in (listofserialnumbers.txt) do (
find "%%a" < "list of files.txt" >>"output file.txt"
)
Step 2: Created a Text file with the serial numbers. The file name used is "IDs"  Filename should be listofserialnumbers.txt
Step 3: Then I logged into the https link
Step 4: Saved the web page as text with the list of all the files (Process: Ctrl + S -> Save Type as Text File). File Name is “Nov 14” Filename should be  "list of files.txt"
Step 5: Saved 3 Files generated from Step 1, 2 and 4 in C drive
Step 6: I clicked on the Script File – A CMD window opened for a fraction of second and then closed. Nothing happened…


Please advise...

Thanks

Try it with the above changes.

[jaidev.anand]

Try it with the above changes.

Awesome! Thanks a ton:-)

This is working superbly. You are the best. Guess, I can't thank you enough. Cheers!!!

[jaidev.anand]

Awesome! Thanks a ton:-)

This is working superbly. You are the best. Guess, I can't thank you enough. Cheers!!!

Hi Sir,

Just one additional thing that I noticed...The file name currently being returned is: 20121114-0704-38877796-in.wav14-Nov-2012 07:05 551K

Is it possible to customize the script to only return this bit 20121114-0704-38877796-in.wav?

Please advise. Hope it is not too much of a problem!

Thanks,
Jai

[foxidrive]

In your file, is there a space between .wav and the date?

The reason why I asked three times for a sample of the text is so I could arrange for the filename only, and you wanted CSV format too didn't you?

[jaidev.anand]

In your file, is there a space between .wav and the date?

The reason why I asked three times for a sample of the text is so I could arrange for the filename only, and you wanted CSV format too didn't you?

Yes Sir. The exact format is 20121114-0704-38877796-in.wav 15-Nov-2012 01:04  479K. I only need 20121114-0704-38877796-in.wav

Thank you!

[foxidrive]

Try this:

Code: [Select]

@echo off
del "output file.csv" 2>nul
for /f "delims=" %%a in (listofserialnumbers.txt) do (
for /f %%b in ('find "-%%a-" ^< "list of files.txt"') do (
set /p =""%%b"," >>"output file.csv" <nul
)
)
echo done
pause


[jaidev.anand]

Try this:

Code: [Select]

@echo off
del "output file.csv" 2>nul
for /f "delims=" %%a in (listofserialnumbers.txt) do (
for /f %%b in ('find "-%%a-" ^< "list of files.txt"') do (
set /p =""%%b"," >>"output file.csv" <nul
)
)
echo done
pause

Sorry Sir, but this isn't getting the right output. I'm still getting 20121114-0704-38877796-in.wav14-Nov-2012 as the outcome. Apart from this it is coming in Row 1 instead of 1 name in 1 row.

Please advise.



[foxidrive]

I asked if there was a space between .wav and the date.  You said yes.  Are you now saying no?

[jaidev.anand]

I asked if there was a space between .wav and the date.  You said yes.  Are you now saying no?

Sir,

There is a space between .wav and the date.

Thanks!

[foxidrive]

Open the file "list of files.txt" and have a good look.

If you had shown me the first time I asked then we would not be frustrated and writing back and forth and back and forth about the format of the list.

If there was a space then it would not be in the format you say it is in in the output file.

[jaidev.anand]

Open the file "list of files.txt" and have a good look.

If you had shown me the first time I asked then we would not be frustrated and writing back and forth and back and forth about the format of the list.

If there was a space then it would not be in the format you say it is in in the output file.

Okay, sorry about the trouble. Will not bother. Thanks for the help though.

[foxidrive]

So you take you bat and ball and go home rather than work *with* the people that are solving your problem - for free.