Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXTRACT MONTH FROM DATE | New Users to Excel | |||
Extract Date | Excel Worksheet Functions | |||
Extract Day of Week from Date in VBA | Excel Programming | |||
extract name when a date in another cell gets near | Excel Discussion (Misc queries) | |||
extract date from the most current date | Excel Discussion (Misc queries) |