I'd check for "Gremlins" if you haven't already. In any case that step could be cleaned up a little. The version below doesn't rely on the return at the start of the file and doesn't really care about how the name/number part of the line is formatted.
Find: (\r|^)(.+?)\r\t(.+?)\r\t\t Replace: \1\2\t\3\t\4 A similar cleanup on the final step to pull the headers down into the rows would look like this. Find: (\r|^)(.+?)\t(.+?)\t(.+?)\r\t\t Replace: \1\2\t\3\t\4\r\2\t\3\t There's a tradeoff between making these strict or flexible depending on how structured the data coming in is. [fletcher] > On Mar 22, 2023, at 12:57 PM, Doug Pinkerton <dplistacco...@gmail.com> wrote: > > Thank you, Fletcher. > The first few steps worked perfectly. The data now look like this: > > ART 200 > Alternate > Dove, David 11 > Fox, Fred 11 > Gill, Gertrude 10 > > But when I run this step: > \r(.+?)\r\t(.+?)\r\t\t(.+?)\r > it acts on most of the student names, but not all of them. I'm not able to > detect a pattern in the sequence of the skips, or any difference in the > textual structure of the skipped records. The records are now structured > enough that I can drop them into a spreadsheet and do some manual fill down, > but I would like to figure this out, since this is a recurring project. > > dp > -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "supp...@barebones.com" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to bbedit+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/4D4C6BF0-D616-47C8-A59C-1CD46AD1D220%40cumuli.com.
