Hello I am looking for help and resources on parsing with regex or other tools. Basically I have two different types of string fields with important information I would like to extract.
Current:
| Description |
| 1/8 - 1/24/2022 charge for room TAYA-0521-A1 for 1/8/2022-1/24/2022 (16 night(s)) @ $4,911.00/p/120 Night Session |
| 1/8 - 5/8/2022 charge for room VBGA-0641-B1 for 120 night(s) @ $2,511.00/p/120 Night Session |
Expected:
| Date Range | Room | Used | Price | Empty |
| 1/8 - 1/24/2022 | TAYA-0521-A1 | 16 | $4,911.00 | 104 |
| 1/8 - 5/8/2022 | VBGA-0641-B1 | 120 | $5,211.00 | 0 |
