Re: Regex brain failure...

https://regex101.com/ is exactly the site I ended up using. The step through debugger is perfect for fining where a particular pattern fails. It's what let me see there was a tab space tab where I expected a single tab in the data and correct teh regex for the data as it actually is. On

Re: Regex brain failure...

For testing regex you might find it useful to use regex101. It's excellent and you can save the page. I put your text here just for testing. pls note your tabs are corrupted in the email and I put an "a" to make it work just for test. On Sat, 3 Feb 2024 at 21:13,

Re: Regex brain failure...

Never mind. The correct pattern is: ^\d+?\t.\tnontraditional field\tText\t2,319\tInterview 1\.txt$ There is a column with a space in it between the number column (1st column) and the 3rd column (which I thought was the 2nd column) that has the code name in it (ie. nontradtional field). Now

Regex brain failure...

I have a (reduced) example set of data in a variable "tCaseCodes" that is tab delimited set of lines below: 1         I am making a high salary    Text    2,319    Interview 1.txt 2         nontraditional field    Text    2,319    Interview 1.txt 3         gets married and stays married    Text