Spreadsheet: 732969d1621341765-need-help-parsing-data-problem1-tms
Sheet: Sheet1

Category ID | Object.subs | Text to Columns (split on Char(10)) |  |  |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE] | [PHONE]
[PHONE] | 6270.924 - Benefit Recovery | 6270.924 - Benefit Recovery
[PHONE] | 6210.005 - Bonuses | 6210.005 - Bonuses
[PHONE] | 6210.008 - Contract  Service/Labor | 6210.008 - Contract  Service/Labor |  |  |  |  |  |  | 6250.951 - Accruals - Pumping | 6270.751 - Compression Fees | 6230.231 - Compressors |  |  | 6230.930 - Compressor/cooler/VRU-B | 6230.934 - Compression Op Lse Accru |  | 6260.950 - Accruals - Electricity |  |  | 6270.702 - Chemicals |  |  |  |  | 6215.954 - Accruals - Repairs |  |  |  |  |  |  |  |  | 6265.951 - Accruals - Overhead |  |  | 6255.544 - Communications-Telepho
[PHONE] | 6210.950 - Accruals - Salaries & Bene 6250.951 - Accruals - Pumping | 6210.950 - Accruals - Salaries & Bene | 6250.951 - Accruals - Pumping |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6215.950 - Accruals - Repairs & Maint |  |  |  |  |  |  |  |  |  |  |  | 6255.935 - Comm/Network/Teleph
[PHONE] | 6270.850 - Compression 6270.751 - Compression Fees | 6270.850 - Compression | 6270.751 - Compression Fees
[PHONE] | 6215.120 - Compressor Parts 6230.231 - Compressors | 6215.120 - Compressor Parts | 6230.231 - Compressors
[PHONE] | 6230.932 - Compressor/Cooler/VRU-S | 6230.932 - Compressor/Cooler/VRU-S
[PHONE] | 6230.931 - Compressor/Cooler/VRU-V | 6230.931 - Compressor/Cooler/VRU-V
[PHONE] | 6270.946 - Compressor Rental - BOPL 6230.930 - Compressor/cooler/VRU-B | 6270.946 - Compressor Rental - BOPL | 6230.930 - Compressor/cooler/VRU-B
[PHONE] | 6270.951 - Accrual - Power 6230.934 - Compression Op Lse Accru | 6270.951 - Accrual - Power | 6230.934 - Compression Op Lse Accru
[PHONE] | 6270.772 - AB & BC - Carbon Tax | 6270.772 - AB & BC - Carbon Tax
[PHONE] | 6270.952 - Accrual - Fuel  6260.950 - Accruals - Electricity | 6270.952 - Accrual - Fuel | 6260.950 - Accruals - Electricity
[PHONE] | 6230.256 - Chemical Injection System | 6230.256 - Chemical Injection System
[PHONE] | 6270.864 - Chemical Methanol | 6270.864 - Chemical Methanol
[PHONE] | 6270.860 - Chemical Natural Gas Dehy 6270.702 - Chemicals | 6270.860 - Chemical Natural Gas Dehy | 6270.702 - Chemicals
[PHONE] | 8270.862 - Chemical Natural Gas Swee | 8270.862 - Chemical Natural Gas Swee
[PHONE] | 6270.954 - Accrual - Chemicals | 6270.954 - Accrual - Chemicals
[PHONE] | 6220.173 - Contract Service | 6220.173 - Contract Service
[PHONE] | 6270.742  - Cathodic Protection | 6270.742  - Cathodic Protection
[PHONE] | 6215.952 - Accruals - Maintenance 6215.954 - Accruals - Repairs 6215.950 - Accruals - Repairs & Maint | 6215.952 - Accruals - Maintenance | 6215.954 - Accruals - Repairs | 6215.950 - Accruals - Repairs & Maint
[PHONE] | 6245.953 - Accruals - trucking | 6245.953 - Accruals - trucking
[PHONE] | 6271.744 - Contract Labor | 6271.744 - Contract Labor
[PHONE] | 6271.741 - Bottomhole Pumps | 6271.741 - Bottomhole Pumps
[PHONE] | 6271.692 - Coiled Tubing | 6271.692 - Coiled Tubing
[PHONE] | 6271.950 - Accruals - Workovers | 6271.950 - Accruals - Workovers
[PHONE] | 6250.490 - Administration Fee | 6250.490 - Administration Fee
[PHONE] | 6250.952 - Accruals - Lease & Admin | 6250.952 - Accruals - Lease & Admin
[PHONE] | 6270.817 - Admin Fees | 6270.817 - Admin Fees
[PHONE] | 6265.950 - Accrual Account 6265.951 - Accruals - Overhead | 6265.950 - Accrual Account | 6265.951 - Accruals - Overhead
[PHONE] | 6235.950 - Accruals - EH&S | 6235.950 - Accruals - EH&S
[PHONE] | 6270.955 - Accruals - Non-Operated | 6270.955 - Accruals - Non-Operated
[PHONE] | 6255.550 - Communications/Network 6255.544 - Communications-Telepho 6255.935 - Comm/Network/Teleph | 6255.550 - Communications/Network | 6255.544 - Communications-Telepho | 6255.935 - Comm/Network/Teleph
[PHONE] | 6270.950 - Accrual | 6270.950 - Accrual