XML Problem.
Posted: Sun May 01, 2016 9:47 pm
I'm trying to go from:
<$imports='
recdelim >><GSP
field SN varchar(10) />>\RSN\P\=\x22=[^\x22]+ ""
field EN varchar(10) />>\REN\P\=\x22=[^\x22]+ ""
field Counted varchar(20) />><M>\P=!</M>+ ""
field Pell varchar(20) />>\Rq\P\=\x22=[^\x22]+ ""
field Pell2 varchar(20) />>\Rq\P\=\x27=[^\x27]+ ""
'>
<$imports2='
recdelim >><R\x20N
field ShowURL varchar(40) />><U>\P=!</U>+ ""
field Title varchar(80) />><T>\P=!</T>+ ""
field Abstract varchar(100) />><S>\P=!</S>+ ""
'></a>
to:
<$imports='
xml
field SN varchar(10) GSP/RES/@SN
field EN varchar(10) GSP/RES/@EN
field Counted varchar(20) GSP/RES/M
field Pell varchar(20) GSP/Spelling/Suggestion/@q
field Pell2 varchar(20) GSP/Spelling/Suggestion/@q
'>
<$imports2='
multiple
xml
field ShowURL varchar(40) GSP/RES/R/U
field Title varchar(80) GSP/RES/R/T
field Abstract varchar(100) GSP/RES/R/S
'>
but I keep getting:
<!-- 000 /open/search67:181: XML parsing error reported at byte offset 88 -->
<!-- 000 /open/search67:184: XML parsing error reported at byte offset 88 -->
This is the XML
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE GSP SYSTEM "google.dtd">
-<GSP VER="3.2">
<TM>0.354747</TM>
<Q>gerald odea</Q>
-<Spelling>
<Suggestion q="gerard o'dea"><b><i>gerard</i></b> <b><i>o'dea</i></b></Suggestion>
</Spelling>
-<RES SN="1" EN="10">
<M>11200</M>
<FI/>
-<NB>
<NU>/search?q=gerald+odea&lr=lang_en&safe=active&client=searchalot&hl=en&gl=us&output=xml&ie=UTF-8&oe=UTF-8&prmd=ivns&ei=SKkmV9LMBKW8jgS_95DIDg&start=10&sa=N</NU>
</NB>
-<R N="1">
<U>https://au.linkedin.com/pub/dir/Gerald/O'dea</U>
<UE>https://au.linkedin.com/pub/dir/Gerald/O%27dea</UE>
<T>Top 7 <b>Gerald O'dea</b> profiles | LinkedIn</T>
<RK>0</RK>
<S>View the profiles of professionals named <b>Gerald O'dea</b> on LinkedIn. There are 7 <br> professionals named <b>Gerald O'dea</b>, who use LinkedIn to exchange information, ...</S>
<LANG>en</LANG>
-<HAS>
<L/>
<RT/>
</HAS>
</R>
-<R N="2" L="2">
<U>https://www.linkedin.com/in/jerry-o-dea-1a254814</U>
<UE>https://www.linkedin.com/in/jerry-o-dea-1a254814</UE>
<T><b>Jerry O'Dea</b> | LinkedIn</T>
<RK>0</RK>
<S>View <b>Jerry O'Dea's</b> professional profile on LinkedIn. LinkedIn is the world's <br> largest business network, helping professionals like <b>Jerry O'Dea</b> discover inside<br> ...</S>
<LANG>en</LANG>
-<HAS>
<L/>
<RT/>
</HAS>
</R>
-<R N="3" L="2">
<U>https://uk.linkedin.com/in/gerardatdynamis</U>
<UE>https://uk.linkedin.com/in/gerardatdynamis</UE>
<T><b>Gerard O'Dea</b> | LinkedIn</T>
<RK>0</RK>
<S>View <b>Gerard O'Dea's</b> professional profile on LinkedIn. LinkedIn is the world's <br> largest business network, helping professionals like <b>Gerard O'Dea</b> discover <br> inside ...</S>
<LANG>en</LANG>
-<HAS>
<L/>
<RT/>
</HAS>
</R>
-<R N="4">
<U>http://www.legacy.com/obituaries/southo ... 7946303</U>
<UE>http://www.legacy.com/obituaries/southo ... 946303</UE>
<T>Janet <b>ODea</b> Obituary - Brockton, MA | The Enterprise - Legacy.com</T>
<RK>0</RK>
<BYLINEDATE>1457164800</BYLINEDATE>
<S>Mar 5, 2016 <b>...</b> Janet was the wife of <b>Gerald</b> F. <b>ODea</b>. She was born in Brockton to the late <br> Amadell J. and Joan F. (Baynes) Sebelia. Janet was a 1960 ...</S>
<LANG>en</LANG>
-<HAS>
<L/>
<C SZ="135k" CID="aVeReY_pl_sJ"/>
<RT/>
</HAS>
</R>
</R>
</RES>
</GSP>
Any suggestions as to what I am doing wrong?
Gerry
<$imports='
recdelim >><GSP
field SN varchar(10) />>\RSN\P\=\x22=[^\x22]+ ""
field EN varchar(10) />>\REN\P\=\x22=[^\x22]+ ""
field Counted varchar(20) />><M>\P=!</M>+ ""
field Pell varchar(20) />>\Rq\P\=\x22=[^\x22]+ ""
field Pell2 varchar(20) />>\Rq\P\=\x27=[^\x27]+ ""
'>
<$imports2='
recdelim >><R\x20N
field ShowURL varchar(40) />><U>\P=!</U>+ ""
field Title varchar(80) />><T>\P=!</T>+ ""
field Abstract varchar(100) />><S>\P=!</S>+ ""
'></a>
to:
<$imports='
xml
field SN varchar(10) GSP/RES/@SN
field EN varchar(10) GSP/RES/@EN
field Counted varchar(20) GSP/RES/M
field Pell varchar(20) GSP/Spelling/Suggestion/@q
field Pell2 varchar(20) GSP/Spelling/Suggestion/@q
'>
<$imports2='
multiple
xml
field ShowURL varchar(40) GSP/RES/R/U
field Title varchar(80) GSP/RES/R/T
field Abstract varchar(100) GSP/RES/R/S
'>
but I keep getting:
<!-- 000 /open/search67:181: XML parsing error reported at byte offset 88 -->
<!-- 000 /open/search67:184: XML parsing error reported at byte offset 88 -->
This is the XML
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE GSP SYSTEM "google.dtd">
-<GSP VER="3.2">
<TM>0.354747</TM>
<Q>gerald odea</Q>
-<Spelling>
<Suggestion q="gerard o'dea"><b><i>gerard</i></b> <b><i>o'dea</i></b></Suggestion>
</Spelling>
-<RES SN="1" EN="10">
<M>11200</M>
<FI/>
-<NB>
<NU>/search?q=gerald+odea&lr=lang_en&safe=active&client=searchalot&hl=en&gl=us&output=xml&ie=UTF-8&oe=UTF-8&prmd=ivns&ei=SKkmV9LMBKW8jgS_95DIDg&start=10&sa=N</NU>
</NB>
-<R N="1">
<U>https://au.linkedin.com/pub/dir/Gerald/O'dea</U>
<UE>https://au.linkedin.com/pub/dir/Gerald/O%27dea</UE>
<T>Top 7 <b>Gerald O'dea</b> profiles | LinkedIn</T>
<RK>0</RK>
<S>View the profiles of professionals named <b>Gerald O'dea</b> on LinkedIn. There are 7 <br> professionals named <b>Gerald O'dea</b>, who use LinkedIn to exchange information, ...</S>
<LANG>en</LANG>
-<HAS>
<L/>
<RT/>
</HAS>
</R>
-<R N="2" L="2">
<U>https://www.linkedin.com/in/jerry-o-dea-1a254814</U>
<UE>https://www.linkedin.com/in/jerry-o-dea-1a254814</UE>
<T><b>Jerry O'Dea</b> | LinkedIn</T>
<RK>0</RK>
<S>View <b>Jerry O'Dea's</b> professional profile on LinkedIn. LinkedIn is the world's <br> largest business network, helping professionals like <b>Jerry O'Dea</b> discover inside<br> ...</S>
<LANG>en</LANG>
-<HAS>
<L/>
<RT/>
</HAS>
</R>
-<R N="3" L="2">
<U>https://uk.linkedin.com/in/gerardatdynamis</U>
<UE>https://uk.linkedin.com/in/gerardatdynamis</UE>
<T><b>Gerard O'Dea</b> | LinkedIn</T>
<RK>0</RK>
<S>View <b>Gerard O'Dea's</b> professional profile on LinkedIn. LinkedIn is the world's <br> largest business network, helping professionals like <b>Gerard O'Dea</b> discover <br> inside ...</S>
<LANG>en</LANG>
-<HAS>
<L/>
<RT/>
</HAS>
</R>
-<R N="4">
<U>http://www.legacy.com/obituaries/southo ... 7946303</U>
<UE>http://www.legacy.com/obituaries/southo ... 946303</UE>
<T>Janet <b>ODea</b> Obituary - Brockton, MA | The Enterprise - Legacy.com</T>
<RK>0</RK>
<BYLINEDATE>1457164800</BYLINEDATE>
<S>Mar 5, 2016 <b>...</b> Janet was the wife of <b>Gerald</b> F. <b>ODea</b>. She was born in Brockton to the late <br> Amadell J. and Joan F. (Baynes) Sebelia. Janet was a 1960 ...</S>
<LANG>en</LANG>
-<HAS>
<L/>
<C SZ="135k" CID="aVeReY_pl_sJ"/>
<RT/>
</HAS>
</R>
</R>
</RES>
</GSP>
Any suggestions as to what I am doing wrong?
Gerry