Okay. I think I know how to solve my other question. But, I don't know how to execute it.
My entries are trapped in a single cell. There is a pattern at the start (red bold) of a \d{1,3} followed by 1-N words in ALL CAPS. Each entry ends in a number of {1,7} (after I remove the punctuation). But the length of each entry can vary and can include 1-N \d{1,7} numbers before the last one. This seems to prevent a quick tokenize solution.
*** I want to use REGEX to look for the pattern the delineates the start of each entry and add a | delimiter before it. ***. This way I can then use RegEx set to tokenize to breakout each entry.
Example text below. Note I use RegEx to remove the text the stricken text. This is a header that appears at the tope of each table/page that I am importing (from PDF).
144 EXPLANATION OF PROJECT LEVEL ADJUSTMENTS [ in thousands of dollars ] Budget Commitiee Change from Pp Request Recommended Request 11 UH-60 BLACKHAWK ( MYP ) 9,999 9,999 9,999 Program increase - six HH-60 M for the National Guard 1,000 Excess fielding costs 702 14 CH-47 HELICOPTER 9,999 9,999 9,999 Program increase - F Block If 8,000 MH-47 G SLEP unit cost increase -344563 15 CH-47 HELICOPTER ( AP - CY ) 9,999 9,999 9,999 Program increase - F Biock II 29,000 19 GRAY EAGLE MODS2 9,999 9,999 9,999 Program increase - link 16 communications upgrade for MQ-1C 14,000 21 AH-64 MODS 9,999 9,999 9,999 Sensors cost growth 9,740 27 UTILITY HELICOPTER MODS 9,999 9,999 9,999 Program increase - enhanced ballistic protection system 5,000 Program increase - tail rotor drive system 5,000 35 AIRCRAFT SURVIVABILITY EQUIPMENT 9,999 9,999 9,999 Costs previously funded 55,000 40 COMMON GROUND EQUIPMENT 9,999 9,999 9,999 SCAMP if fielding costs previously funded 91,176 41 AIRCREW INTEGRATED SYSTEMS 9,999 9,999 9,999 Airframe kit instal excess growth -32,000
