https://community.qlik.com/t5/Talend-Studio/Invalid-character-constant-in-XPath-query-Talend/m-p/2434487#M140410 <P>Hi, I want to retrieve columns from the following xml</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_0-1711420097811.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162694iDBC5F091AC8E728A/image-size/medium?v=v2&amp;px=400" role="button" title="asafrian1700127126_0-1711420097811.png" alt="asafrian1700127126_0-1711420097811.png" /></span></P> <P>The following is the column structure and xml</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_3-1711420591221.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162697i7C89B350D9C3AE22/image-size/medium?v=v2&amp;px=400" role="button" title="asafrian1700127126_3-1711420591221.png" alt="asafrian1700127126_3-1711420591221.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="xml structure.jpg" style="width: 397px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162698i11C009676F1297C0/image-size/large?v=v2&amp;px=999" role="button" title="xml structure.jpg" alt="xml structure.jpg" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_4-1711421052586.png" style="width: 693px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162700i5CF3DC8FF19E6214/image-dimensions/693x70?v=v2" width="693" height="70" role="button" title="asafrian1700127126_4-1711421052586.png" alt="asafrian1700127126_4-1711421052586.png" /></span></P> <P>&nbsp;</P> <P>I get an error like below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_1-1711420270116.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162695i503492271CF81CFF/image-size/medium?v=v2&amp;px=400" role="button" title="asafrian1700127126_1-1711420270116.png" alt="asafrian1700127126_1-1711420270116.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_2-1711420333590.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162696i82489BB57BF196C9/image-size/medium?v=v2&amp;px=400" role="button" title="asafrian1700127126_2-1711420333590.png" alt="asafrian1700127126_2-1711420333590.png" /></span></P> <P>Am I wrong in the xpath?<BR />or is there a difference in the xpath if the column is a string or an integer?</P> Tue, 26 Mar 2024 02:47:26 GMT asafrian1700127126 2024-03-26T02:47:26Z https://community.qlik.com/t5/Talend-Studio/Invalid-character-constant-in-XPath-query-Talend/m-p/2434487#M140410 <P>Hi, I want to retrieve columns from the following xml</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_0-1711420097811.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162694iDBC5F091AC8E728A/image-size/medium?v=v2&amp;px=400" role="button" title="asafrian1700127126_0-1711420097811.png" alt="asafrian1700127126_0-1711420097811.png" /></span></P> <P>The following is the column structure and xml</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_3-1711420591221.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162697i7C89B350D9C3AE22/image-size/medium?v=v2&amp;px=400" role="button" title="asafrian1700127126_3-1711420591221.png" alt="asafrian1700127126_3-1711420591221.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="xml structure.jpg" style="width: 397px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162698i11C009676F1297C0/image-size/large?v=v2&amp;px=999" role="button" title="xml structure.jpg" alt="xml structure.jpg" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_4-1711421052586.png" style="width: 693px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162700i5CF3DC8FF19E6214/image-dimensions/693x70?v=v2" width="693" height="70" role="button" title="asafrian1700127126_4-1711421052586.png" alt="asafrian1700127126_4-1711421052586.png" /></span></P> <P>&nbsp;</P> <P>I get an error like below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_1-1711420270116.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162695i503492271CF81CFF/image-size/medium?v=v2&amp;px=400" role="button" title="asafrian1700127126_1-1711420270116.png" alt="asafrian1700127126_1-1711420270116.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="asafrian1700127126_2-1711420333590.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162696i82489BB57BF196C9/image-size/medium?v=v2&amp;px=400" role="button" title="asafrian1700127126_2-1711420333590.png" alt="asafrian1700127126_2-1711420333590.png" /></span></P> <P>Am I wrong in the xpath?<BR />or is there a difference in the xpath if the column is a string or an integer?</P> Tue, 26 Mar 2024 02:47:26 GMT https://community.qlik.com/t5/Talend-Studio/Invalid-character-constant-in-XPath-query-Talend/m-p/2434487#M140410 asafrian1700127126 2024-03-26T02:47:26Z https://community.qlik.com/t5/Talend-Studio/Invalid-character-constant-in-XPath-query-Talend/m-p/2434809#M140414 <P>Hello&nbsp;</P> <P>The xpath looks good, it seems like the file contains invalid characters. Can you upload an example file for testing? Please remove the sensitive data from the file before you share it.&nbsp;</P> <P>Regards</P> <P>Shicong</P> Tue, 26 Mar 2024 15:21:39 GMT https://community.qlik.com/t5/Talend-Studio/Invalid-character-constant-in-XPath-query-Talend/m-p/2434809#M140414 Shicong_Hong 2024-03-26T15:21:39Z https://community.qlik.com/t5/Talend-Studio/Invalid-character-constant-in-XPath-query-Talend/m-p/2442434#M140521 <P>Hello<BR />Typically a special character that needs to be escaped in java</P> Thu, 18 Apr 2024 07:33:52 GMT https://community.qlik.com/t5/Talend-Studio/Invalid-character-constant-in-XPath-query-Talend/m-p/2442434#M140521 jeoste 2024-04-18T07:33:52Z