Whoops, missed that last line break! ^Last Name:\t(.*)\n^First Name:\t(.*)\n^Middle Name:\t(.*)\n^Card Number:\t(.*)\n^Active Date:\t(.*)Inactive Date:\t(.*)Inactive Time:\t(.*)\nNormal Rights\n\tAccess Codes\n((?s)(.*?))\n\n
--Kerri On Sat, Sep 26, 2020 at 10:37 PM Kerri Hicks <[email protected]> wrote: > It's hard to be sure, not knowing exactly what your whitespace is supposed > to be, but try this: > > ^Last Name:\t(.*)\n^First Name:\t(.*)\n^Middle Name:\t(.*)\n^Card > Number:\t(.*)\n^Active Date:\t(.*)\tInactive Date:\t(.*)\tInactive > Time:\t(.*)\t\nNormal Rights\n\tAccess Codes\n((?s)(.*?)\n)* > > --Kerri > > On Sat, Sep 26, 2020 at 9:44 PM Peter Kaufman <[email protected]> wrote: > >> Bruce, >> >> Thanks for looking into it. I actually converted the tabs to spaces to >> make it look right visually in the email. Sorry for any confusion. There >> are indeed tabs where the FIND string is expecting them. Perhaps should >> have included an attached text file. >> >> I’m finding that only the LAST of the Access Codes is saved though. None >> of those before the last one. >> >> Peter >> >> Sent from my iPad >> >> > On Sep 26, 2020, at 8:00 PM, Bruce Van Allen <[email protected]> wrote: >> > >> > On 9/26/20 at 5:16 PM, [email protected] (Peter Kaufman) wrote: >> > >> >> My input is below and the BBEdit Find is: >> >> FIND: ^Last Name:\t(.*)\n^First Name:\t(.*)\n^Middle Name:\t(.*)\n^Card >> > >> > Preliminarily, are you sure that single tabs separate Labels from >> values? >> > >> > Your sample didn't come through that way in my email client... >> > >> > Use BBEdit's Show Invisibles, including spaces, to be sure what white >> space you're records have. >> > >> > Converting your first two sample records to single tabs between labels >> and values, single starting tab for the Access Codes line and double >> starting tabs for the lines under Access Codes, the following pattern >> matches both records: >> > >> > ^Last Name:\t(.*)\n^First Name:\t(.*)\n^Middle Name:\t(.*)\n^Card >> Number:\t(.*)\n^Active Date:\t(.*)\tInactive Date:\t(.*)\tInactive >> Time:\t(.*)\nNormal Rights\n\tAccess Codes\n(\t\t(.*)\n)+\n >> > >> > Email might be adding some spurious line endings to wrap that. >> > >> > There are some things that make this pattern fragile, so I wouldn't >> recommend it for much use. But all fine if it's a one-timer, or just >> getting the darn thing to match is only your first step in refining it. >> > >> > HTH >> > >> > -- >> > >> > - Bruce >> > >> > _bruce__van_allen__santa_cruz__ca_ >> > >> > -- >> > 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/r480Ps-10146i-FB1DA36581374F17940E507B6BADB724%40Forest.local >> . >> >> -- >> 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/412E6CE2-AED8-4C2A-AE45-C8547B3380B0%40gmail.com >> . >> > -- 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/CAEmA4ubKD4BGW9xhy2hDs1CmPUzNadX927MucPfKvu-%3DH1UQkQ%40mail.gmail.com.
