Regex issue

Carlyn

Hi

Can anyone help me with this Regex formula I am trying to build? I think the & sign in group 4 is throwing out the formula as it is working for strings that don't have any special characters.

/[^0]*(\d{1,2}\/\d{1,2}\/\d{4})\s*(\D*)(\d{2}\s\D*)\s+([A-Z]{2,4}\D*)\s+([A-Z0-9]{2,4}\D*)(\d+\.?\d{0,2}?)\D+(\d+\.?\d{0,2})\D+(\d+\.?\d{0,2})\D+(\d+\.?\d{0,2})
/gm

07/22/2025 TEST TEST LLC 45 Loss Expenses D&O Directors & Officers Z0 Unknown or Unclassified 0.00 0.00 0 10.02

The output I am looking for is:

GROUP 1	07/22/2025
GROUP 2	TEST TEST LLC
GROUP 3	45 Loss Expenses
GROUP 4	D&O Directors & Officers
GROUP 5	Z0 Unknown or Unclassified
GROUP 6	0.00
GROUP 7	0.00
GROUP 8	0
GROUP 9	10.02

Can anyone suggest how to amend it

Ladarthure

Hi @Carlyn,

I built a regex that may suit your need, but with only one row of data it makes a bit hard to make it generic enough, here are some elements though :
^(\d{2}\/\d{2}\/\d{4})\s+(.*?)\s+(\d+\s+.+)\s+(D&O Directors & Officers)\s+(Z\d+.+)\s+(\d+\.?\d{0,2})\s+(\d+\.?\d{0,2})\s+(\d+\.?\d{0,2})\s+(\d+\.?\d{0,2})$

a few notes : I use /s for a space as a delimiter between groups

group	text part	regex	notes regarding the regex
GROUP 1	07/22/2025	(\d{2}\/\d{2}\/\d{4})
GROUP 2	TEST TEST LLC	(.*?)
GROUP 3	45 Loss Expenses	(\d+\s+.+)
GROUP 4	D&O Directors & Officers	(D&O Directors & Officers)	this I could not generalize
GROUP 5	Z0 Unknown or Unclassified	(Z\d+.+)	I used Z but if it is an upper letter followed by a sumber could be \u\d+
GROUP 6	0.00	(\d+\.?\d{0,2})
GROUP 7	0.00	(\d+\.?\d{0,2})
GROUP 8	0	(\d+\.?\d{0,2})
GROUP 9	10.02	(\d+\.?\d{0,2})

also, I always recommend trying to use websites like regex101 to test your regex, it helps you identify which part is causing troubles !

I hope it helps !