Have you looked into xslt? That's really the tool you should be using for xml transformations. The learning curve is steep-ish but this is the exact use case it was designed for.
Have a look. The Mac confess with a command line tool called xsltproc preinstalled that is normally more than sufficient for the types of transformations. I usually pipe the output to bbedit for verification of my work when the transformation is complete. Ted On Mon, Feb 24, 2020, 6:50 PM Miguel Perez <[email protected]> wrote: > This could be an option too. Thank you. > Excel ended up not working in this case because while it reads the file, > it has a weird formatting too and I cannot work with it much better. > The formula posted above works much better for me and is what I was > looking for. > > El lunes, 24 de febrero de 2020, 12:12:16 (UTC-6), ThePorgie escribió: >> >> One other thing about a xml tool. The latest version of Mac Excel will >> now open xml. Just an fyi if that would work to get the names you're >> looking for. >> >> >> >> On Monday, February 24, 2020 at 11:44:36 AM UTC-5, Miguel Perez wrote: >>> >>> Hi, >>> >>> I'm fairly new to RegEx and I need your help. >>> >>> I process many XML files in my job. Most of them are formatted >>> correctly, that is: >>> <key1>Value</key1> >>> <key2>Value</key2> >>> >>> For those I search for values using: >>> >>> <key1>.*?</key1> >>> And it works like a charm. >>> >>> But then I have this one source that formats its XML files with CDATA >>> fields like this: >>> <field> >>> <key><![CDATA[NAME]]></key> >>> <value><![CDATA[John Appleseed]]></value> >>> </field> >>> In this example they are trying to say that the value *NAME* is *John >>> Appleseed*. Rather than putting it as a key/value pair, they do that >>> weird syntax. >>> >>> What GREP pattern can I use to extract all the names for this formatting? >>> >>> I am open to other solutions, like BASH scripts and Applescript. I'm >>> desperate. >>> >>> Thank you for your help, friends. >>> >>> 🙂 >>> >> -- > 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/4bab3829-303a-4b88-ab22-fca5baa527f9%40googlegroups.com > <https://groups.google.com/d/msgid/bbedit/4bab3829-303a-4b88-ab22-fca5baa527f9%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAKAQjiegKT8R_iHB16Scv_E-4R%3DbpN8riZYc_-zFuGNLgTN48Q%40mail.gmail.com.
