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.
