Re: Regex brain failure...

2024-02-03 Thread Paul Dupuis via use-livecode
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 2/3/20

Re: Regex brain failure...

2024-02-03 Thread Kaveh Bazargan via use-livecode
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...

2024-02-03 Thread Paul Dupuis via use-livecode
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 t