LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 111
Default Date search and date extract

To all,

I have a folder containing text files with a date as the title
proceded by RD. For example RD071129, RD 071228 ( Format YYMMDD). In
each text file I have data in the same format as below:

Date,Time,Pierce_Position,Pierce_Pressure,Clamp_Po sition,Clamp_Pressure,Current_Job,Toolslide_Positi on,Press
Mode,Rotary 1 Furnace Temperature,Rotary 2 Furnace Temperature
2007/29/11,00:04:42,1298.,42.,10,1182.,36075,1,Manual,0,0
2007/29/11,00:04:42,1298.,42.,10,1193.,36075,1,Manual,0,0
2007/29/11,00:04:43,1298.,42.,10,1199.,36075,1,Manual,0,0
2007/29/11,00:04:43,1298.,42.,11,1205.,36075,1,Manual,0,0
2007/29/11,00:04:44,1298.,42.,11,1210.,36075,1,Manual,0,0
2007/29/11,00:04:44,1298.,42.,10,1215.,36075,1,Manual,0,0
2007/29/11,00:04:45,1298.,42.,10,1220.,36075,1,Manual,0,0
2007/29/11,00:04:45,1298.,42.,10,1226.,36075,1,Manual,0,0
2007/29/11,00:04:46,1298.,42.,10,1231.,36075,1,Manual,0,0
2007/29/11,00:04:46,1298.,42.,10,1237.,36075,1,Manual,0,0
2007/29/11,00:04:47,1298.,42.,11,1242.,36075,1,Manual,0,0
2007/29/11,00:04:47,1298.,42.,11,1248.,36075,1,Manual,0,0
2007/29/11,00:04:48,1298.,42.,11,1254.,36075,1,Manual,0,0
2007/29/11,00:04:48,1298.,42.,10,1260.,36075,1,Manual,0,0


The important part of this data is the job number. In the above data
example the job number is 36075. Is there any way that I can search
these text files for a user specified job number, and then display a
list of all the file names ( Dates ) that this job number occured on.
For example if I searched 36075 it would return 20072911 etc?

Thanks in advance for your help,

Regards

Joseph Crabtree
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXTRACT MONTH FROM DATE SSJ New Users to Excel 5 March 7th 08 05:55 PM
Extract Date christmaslog Excel Worksheet Functions 1 February 19th 06 10:28 AM
Extract Day of Week from Date in VBA GLT Excel Programming 7 December 13th 05 05:55 PM
extract name when a date in another cell gets near cityfc Excel Discussion (Misc queries) 1 November 9th 05 07:40 PM
extract date from the most current date Cali00 Excel Discussion (Misc queries) 1 April 13th 05 02:05 PM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"