Regex matching in Atom but not KM

[Jordan_Bodwell]

Converter Macro (v10.0.2)

Hi all! Another similar Regex problem to my last question. Building a quick converter for names from a system at my work to put into a spreadsheet for further processing. The Regex matches the last name but not the first name.

Strings (intended captured text in bold):

Jones, James D. (DOB: 1/1/1111)

Regex I've been using:

(?<=,\s).*(?=.()

Converter Macro (v10.0.2)

Converter.kmmacros (4.1 KB)

[bobby]

Assertions are hard. I'd suggest just matching the entire string in one go: ^([^,]*),\s*(\S+)\s*(\S+)\s*\(DOB:\s*(.*)\). The four capture groups are: first name, last name, middle initial, dob.