Can you give us a real-world example? I’m not clear on whether
“key1” and “key2” literally appear in your document or if they
are placeholders.
In any case, you should probably use a tool that is designed to work
with XML. Such a tool would take care of the CDATA sections for you and
let you search for things in a hierarchical way.
You might be able to “get the job done” with text-oriented tools,
but it will eventually drive you insane.
-sam
On 24 Feb 2020, at 12:47, Miguel Perez wrote:
Thank you, ThePorgie.
Unfortunately it doesn't work for me.
I should've said that there are many values using this syntax, like
this:
<field>
<key1><![CDATA[NAME]]></key1>
<value><![CDATA[John Appleseed]]></value>
</field>
<field>
<key2><![CDATA[Company]]></key2>
<value><![CDATA[Google]]></value>
</field>
As you can see, there are two keys, but the very next line says
*value* for
both of them. That is my main concern.
I want *value1* for each item on the list, but its defining *key* is
in the
line above with that CDATA formatting.
Any ideas?
El lunes, 24 de febrero de 2020, 11:01:22 (UTC-6), ThePorgie
escribió:
Put "\1" (no quotes) in the replace field and then Extract with
<value><!\[CDATA\[(.+?)\]
Will that work for ya?
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/8c4b1b3f-c421-472f-967f-9e3d5d3dfff8%40googlegroups.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/ED2DF836-2037-430C-99D7-6D34730717A3%40munkynet.org.
