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 <[email protected]> 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 "[email protected]" 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/4D4C6BF0-D616-47C8-A59C-1CD46AD1D220%40cumuli.com.
