+2I 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 |
+33Hi
You could try splitting the field on / and then using a regular expression to get the number. Something like.
Hope that helps.
+14From 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
