I have an excel file where i have 2 limits stated under single column and I want to split them as per table B where the Type = C
| Limit | Type |
| $30,000 per claim / $50,000 aggregate | N |
| $50,000 per claim / $70,000 aggregate | C |
Table B
| Limit | Type | Per claim Limit | Aggregate Limit |
| $50,000 per claim / $70,000 aggregate | C | $50,000 | $70,000 |
Hi
You could try splitting the field on / and then using a regular expression to get the number. Something like.
Hope that helps.
From the example provided, is there a pattern in the Excel like alternate rows, which contains the limits to be written to another table?
That could provide another way to extract the rows of interest!
SRG