Re: Using Xpath, Output value is not displaying in Single Line

One possible option is to remove \n and \r characters in XML output.
Somtehing like this should do the trick:
SELECT regexp_replace
((xpath('//Grading_Manual',xmlgrading))[1]::text, '[\n\r]',
'', 'g') As xpath from km_course_mast WHERE ID=100006

On Wed, Nov 13, 2013 at 4:30 AM, Nasruddin NA <nasruddin(dot)java(at)gmail(dot)com>wrote:

> Hi All,
>
>
> I am using following query for xpath,
>
> SELECT ((xpath('//Grading_Manual',xmlgrading))[1]::text) As xpath from
> km_course_mast WHERE ID=100006
>
> *Output for this is in multiple lines after copying into editor*
>
> "<Grading_Manual>
> <PassorFail>PassFailM</PassorFail>
> <Point>Pointtext</Point>
> <Percentage>Percentagetext</Percentage>
> <LetterBased>
> <Sequence value="0">
> <Letter>Lettertext</Letter>
> <From>1</From>
> <To>2</To>
> </Sequence>
> <Sequence value="1">
> <Letter>Lettertext</Letter>
> <From>3</From>
> <To>4</To>
> </Sequence>
> <Sequence value="2">
> <Letter>Lettertext</Letter>
> <From>5</From>
> <To>6</To>
> </Sequence>
> <Sequence value="3">
> <Letter>Lettertext</Letter>
> <From>7</From>
> <To>8</To>
> </Sequence>
> <Sequence value="4">
> <Letter>Lettertext</Letter>
> <From>9</From>
> <To>10</To>
> </Sequence>
> </LetterBased>
> <Rubic>
> <Upload>Uploadtext</Upload>
> <url>urltext</url>
> <Enter>Entertext</Enter>
> </Rubic>
> </Grading_Manual>"
>
> I want output in single line like below
>
> <Grading_Automated><PassOrFail>Pass</PassOrFail><ActivityScorebased><AutomatedSequence
> Value="0"><Percentage>123</Percentage><Value>321</Value></AutomatedSequence><AutomatedSequence
> Value="1"><Percentage>234</Percentage><Value>4321</Value></AutomatedSequence><AutomatedSequence
> Value="2"><Percentage>431</Percentage><Value>2321</Value></AutomatedSequence><AutomatedSequence
> Value="3"><Percentage>432</Percentage><Value>3231</Value></AutomatedSequence><AutomatedSequence
> Value="4"><Percentage>333</Percentage><Value>4321</Value></AutomatedSequence><AutomatedSequence
> Value="5"><Percentage>451</Percentage><Value>34321</Value></AutomatedSequence></ActivityScorebased></Grading_Automated>','<Grading_Automated><PassOrFail>Fail</PassOrFail><ActivityScorebased><AutomatedSequence
> Value="0"><Percentage>123</Percentage><Value>321</Value></AutomatedSequence><AutomatedSequence
> Value="1"><Percentage>234</Percentage><Value>4321</Value></AutomatedSequence><AutomatedSequence
> Value="2"><Percentage>431</Percentage><Value>2321</Value></AutomatedSequence><AutomatedSequence
> Value="3"><Percentage>432</Percentage><Value>3231</Value></AutomatedSequence><AutomatedSequence
> Value="4"><Percentage>333</Percentage><Value>4321</Value></AutomatedSequence><AutomatedSequence
> Value="5"><Percentage>451</Percentage><Value>34321</Value></AutomatedSequence></ActivityScorebased></Grading_Automated>
>
> Please any one suggest me why it is in multiple line and how to convert to
> single line in query level.
>
> Thanks,
> Nasruddin
>

--

*Radovan Jablonovsky* | SaaS DBA | Phone 1-403-262-6519 (ext. 256) | Fax
1-403-233-8046

* Replicon | Hassle-Free Time & Expense Management Software - 7,300
Customers - 70 Countrieswww.replicon.com
<http://www.replicon.com/> | facebook
<http://www.facebook.com/Replicon.inc> | twitter
<http://twitter.com/Replicon> | blog
<http://www.replicon.com/blog/> | contact us
<http://www.replicon.com/about_replicon/contact_us.aspx> We are
hiring! | search jobs
<http://tbe.taleo.net/NA2/ats/careers/searchResults.jsp?org=REPLICON&cws=1&act=sort&sortColumn=1&__utma=1.651918544.1299001662.1299170819.1299174966.10&__utmb=1.8.10.1299174966&__utmc=1&__utmx=-&__utmz=1.1299174985.10.3.utmcsr=google%7Cutmccn=(organic)%7Cutmcmd=organic%7Cutmctr=replicon%20careers&__utmv=1.%7C3=Visitor%20Type=Prospects=1,&__utmk=40578466>
*