itsrich
New Member
- Joined
- Apr 13, 2009
- Messages
- 49
- Office Version
- 2019
- Platform
- Windows
Column AA starting in Cell 2 has data in it in the format: P:\VCarve\PreNesting\BATX165\7-27-21 BATX165 (1) v\BATX165 050-30-60-1-1.crv (these cells can be anywhere in the Workbook, they are just data to be worked with)
I have 1205 cells with the same sequence of info, but the text varies in length such as (I used Paste File Path to get this data into the column of cells):
I wish to harvest the data out of the file name so I can crunch numbers.
P:\VCarve\PreNesting\BATX165\7-27-21 BATX165 (1) v\BATX165 050-30-60-1-1.crv
I want to harvest into columns (hope the color is not to confusing)
Thank you for your help!
I have 1205 cells with the same sequence of info, but the text varies in length such as (I used Paste File Path to get this data into the column of cells):
P:\VCarve\PreNesting\SMMV1654 COMBINED\5-3-21 (1 CC, 1 T)\SMMV1654 (1 CC, 1 T) 100-72-166-1-1 SIDE PANELS ~ OTHER 2 ARE IN SUPERMARKET.crv
P:\VCarve\PreNesting\OLV2010 ALL\9-28-21 (4 CC-25, 2 WT-25) v\OLV2010 (4 CC-25, 2 WT-25) 050-60-130-7-1.crv
P:\VCarve\PreNesting\OLV186 ALL\10-5-21 (1CC,1SC,1T,1CC-25,1T-25) v\OLV186 050-60-78-1-1.crv
P:\VCarve\PreNesting\OLV2010 ALL\9-28-21 (4 CC-25, 2 WT-25) v\OLV2010 (4 CC-25, 2 WT-25) 090-60-195-14-1 DRILL.crv
I wish to harvest the data out of the file name so I can crunch numbers.
P:\VCarve\PreNesting\BATX165\7-27-21 BATX165 (1) v\BATX165 050-30-60-1-1.crv
I want to harvest into columns (hope the color is not to confusing)
- Counts: info between ( & ) Example: 1
- Guage: 050 could = 050, 063, 070, 080, 090, 098 100, 125, or 190
- Length: 30 could = 1 to 260
- Width: 60 could = 1 to 260
- Count of Sheets: 1 could = 1 to 20
- Drill/No Drill: the word DRILL (this may or may not be in the file name.)
Thank you for your help!