Skip to main content

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 ​@aashnaparikh 

You could try splitting the field on / and then using a regular expression to get the number. Something like.
 

Hope that helps.


@aashnaparikh 

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


Reply