Folks,
I've been struggling with this problem all day and can't seem to find a
solution to it. I'm missing some key idea for which I hope one of you can
inform me.
Thanks very much in advance for any help!
Peter
My input is below and the BBEdit Find is:
FIND: ^Last Name:\t(.*)\n^First Name:\t(.*)\n^Middle Name:\t(.*)\n^Card
Number:\t(.*)\n^Active Date:\t(.*)\tInactive Date:\t(.*)\tInactive
Time:.*\nNormal Rights\n\tAccess Codes\n(\t\t(.*)\n)+\n
REPLACE: \1\t\2\t\3\t\4\t\5\t\6\t\8
In order to get one line per group of fields within a record ending with
\n\n.
Sample Input (the Access Codes could be from 1 to 4 lines spaced the same
way):
Last Name: Smith
First Name: Ken
Middle Name:
Card Number: 8522
Active Date: 08/31/2020 Inactive Date:
Inactive Time:
Normal Rights
Access Codes
JFF Office
Master 24/7
Last Name: Smith
First Name: Ken
Middle Name:
Card Number: 8681
Active Date: 08/31/2020 Inactive Date:
Inactive Time:
Normal Rights
Access Codes
Master 24/7
JFF Office
Special Office
Last Name: Smith
First Name: Deb
Middle Name:
Card Number: 12293
Active Date: 08/31/2020 Inactive Date:
Inactive Time:
Normal Rights
Access Codes
Master 24/7
Special Door
Last Name: Smith
First Name: Diane
Middle Name:
Card Number: 12221
Active Date: 08/31/2020 Inactive Date: 09/01/2020
Inactive Time: 23:59
Normal Rights
Access Codes
Master 24/7
--
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/94352c01-b1b8-4f2d-b3ec-071b829cf225n%40googlegroups.com.
