Please pardon the obvious question but what do your bulk data
look like? :-)
Regards,
Patrick Woolsey
==
Bare Bones Software, Inc. <http://www.barebones.com/>
On 9/28/16 at 9:54 AM, [email protected] (Wibble) wrote:
Just updated to 11.6 and found it! Thanks for adding that:-)
But... using the following regex to extract the data:
(?:Surname=(?P<sn>[^\&]*)\&)|(?:Firstname=(?P<fn>[^\&]*)\&)|(?:PersonID=(?P<mid>
[^\&]*)\&)
(meaning extract surname, forename or personID into named
captures sn, fn, mid)
results in the text being split into three lines, e.g. one per
line and looking like this:
FirstName=Fred&
Surname=Skuttle&
PersonID=ABC123&
FirstName=Shahida&
Surname=Ahmed&
PersonID=XYZ345&
Which means that:
1) The non-capturing groupings are being interpreted as capturing
2) It needs more processing to re-assemble to single lines (one
line / record)
3) There's no replacements, so I can't just extract the fields
I need in one go (e.g. Fred Skuttle ABC123)
(OT: I do lots of extracting from XML, converting into CSV,
which is a painful task. Would be great to have the tools to
do this.)
--
This is the BBEdit Talk public discussion group. If you have a
feature request or would like to report a problem, please email
"[email protected]" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/bbedit.
