Extracting a number out of a file name and creating a new file

[madhusd]

Is there a script that can do the following ?

Capture all files of a specific type in a specific folder and create a text file with the following info...

vfx -n 9724582499 -d faxmodem 1_9724582499.doc
vfx -n 9725101119 -d faxmodem 2_9725101119.doc
vfx -n 9722461109 -d faxmodem 3_9722461109.doc
vfx -n 8173451099 -d faxmodem 4_8173451099.doc
vfx -n 9726066666 -d faxmodem 5_9726066666.doc
vfx -n 9723357640 -d faxmodem 6_9723357640.doc
vfx -n 8172833175 -d faxmodem 7_8173451099.doc
vfx -n 9725424386 -d faxmodem 8_9725424386.doc
vfx -n 2142217688 -d faxmodem 9_2142217688.doc

Pay attention to the 3rd and the last columns. All files in a particular folder are in the format of 1_9724582499.doc..... etc.

I want to create a txt or csv file to extract the number from the name of the text file and put it in a seperate column and the corresponding file name in another column.

Is there a VB script or any kinda script that can do this ?

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/af4423b2-4ee8-41d6-a704-49926cd4d2e8.asp

http://msdn.microsoft.com/library/en-us/script56/html/6f28899c-d653-4555-8a59-49640b0e32ea.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886