Styjun

Am I testing diodes properly?

Why do players in the past play much longer tournaments than today's top players?

Why did the Japanese attack the Aleutians at the same time as Midway?

What would the EU do if an EU member declared war on another EU member?

The monorail explodes before I can get on it

I have a ruthless DM and I'm considering leaving the party. What are my options to minimize the negative impact to the rest of the group?

Extract an attribute value from XML

Creating custom objects with custom properties using generics

Where is the USB2 OTG port on the RPi 4 Model B located?

Are randomly-generated passwords starting with "a" less secure?

Can I intentionally omit previous work experience or pretend it doesn't exist when applying for jobs?

Cops: The Hidden OEIS Substring

Was adding milk to tea started to reduce employee tea break time?

Why did my rum cake turn black?

Did any of the founding fathers anticipate Lysander Spooner's criticism of the constitution?

Is killing off one of my queer characters homophobic?

"A killed B" translation

Are there any intersection of Theory A and Theory B?

Does Google Maps take into account hills/inclines for route times?

Bronze Age Underwater Civilization

Is Arc Length always irrational between two rational points?

How can I deal with a player trying to insert real-world mythology into my homebrew setting?

Keep milk (or milk alternative) for a day without a fridge

diff shows a file that does not exist

Xpath Extract data from Parent element and not its child elements where parent name is same as child

XPath - extract value from parent with highest node valueXPATH for first element whose name is among the names of some other elementsFragment input xhtml to seperate xhtml files with ancestor nodes deailsHow to traverse to preceding parent node and get value of elements in XPath?xpath of elemnts including same childEffectively searching through entire 1 level nested JSONB in PostgresXSLT 2: How to wrap all content between first and last occurrence of a XML-tag?xpath: nested nodes with same nameConvert LocalDate into Timestamp in Postgres' json columnPostgreSQL occasional slow insertion speed because of FK trigger

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

Parent and child tags have same name. I am trying to extract everything from parent except for the child elements.

We have several rows in parent that we want to extract. There are several Parent and child which are nested as below.

Have tried //Record/preceding-sibling::* which does not give me parent element start and end tag.
[not(descendant::Record)] and many other alternatives but no luck.

<Record contentId="1"> 
 <Metrics_Library_Name>Text1</Metrics_Library_Name> 
 <Metrics_Library_ID>1</Metrics_Library_ID> 
 <Record contentId="1a"> 
 <Questionnaire_ID>1a</Questionnaire_ID> 
 <Year>2018</Year> 
 <Quarter/> 
 <Month>02-Feb</Month> 
 </Record> 
 <Record contentId="1b"> 
 <Questionnaire_ID>1a</Questionnaire_ID> 
 <Year>2018</Year> 
 <Quarter/> 
 <Month>02-Feb</Month> 
 </Record> 
</Record>

Expected output:

<Record contentId="1"> 
 <Metrics_Library_Name>Text1</Metrics_Library_Name> 
 <Metrics_Library_ID>1</Metrics_Library_ID> 
</Record>

postgresql-9.5 xpath-2.0

share|improve this question

edited Mar 26 at 4:26

BPM

asked Mar 26 at 4:16

BPMBPM

622 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  <Parent1 Record> <Text1> <Text2>...<Child1 Record><Text1></Child1> <Text2><Child2 Record>... </Child2> </Parent1 Record> <Parent2 Record> <Text1> <Text2>...<Child1 Record><Text1> <Text2></Child1><Child2 Record>...</Child2> </Parent2 Record>
  
  – BPM
  Mar 26 at 4:26
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  XPath selects nodes but XPath is read-only -- it cannot delete children of a selected node. Use XSLT to get the stated wanted result
  
  – Dimitre Novatchev
  Jun 11 at 23:38
  

  
  
  
  

add a comment | 

1

Parent and child tags have same name. I am trying to extract everything from parent except for the child elements.

We have several rows in parent that we want to extract. There are several Parent and child which are nested as below.

Have tried //Record/preceding-sibling::* which does not give me parent element start and end tag.
[not(descendant::Record)] and many other alternatives but no luck.

<Record contentId="1"> 
 <Metrics_Library_Name>Text1</Metrics_Library_Name> 
 <Metrics_Library_ID>1</Metrics_Library_ID> 
 <Record contentId="1a"> 
 <Questionnaire_ID>1a</Questionnaire_ID> 
 <Year>2018</Year> 
 <Quarter/> 
 <Month>02-Feb</Month> 
 </Record> 
 <Record contentId="1b"> 
 <Questionnaire_ID>1a</Questionnaire_ID> 
 <Year>2018</Year> 
 <Quarter/> 
 <Month>02-Feb</Month> 
 </Record> 
</Record>

Expected output:

<Record contentId="1"> 
 <Metrics_Library_Name>Text1</Metrics_Library_Name> 
 <Metrics_Library_ID>1</Metrics_Library_ID> 
</Record>

postgresql-9.5 xpath-2.0

share|improve this question

edited Mar 26 at 4:26

BPM

asked Mar 26 at 4:16

BPMBPM

622 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  <Parent1 Record> <Text1> <Text2>...<Child1 Record><Text1></Child1> <Text2><Child2 Record>... </Child2> </Parent1 Record> <Parent2 Record> <Text1> <Text2>...<Child1 Record><Text1> <Text2></Child1><Child2 Record>...</Child2> </Parent2 Record>
  
  – BPM
  Mar 26 at 4:26
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  XPath selects nodes but XPath is read-only -- it cannot delete children of a selected node. Use XSLT to get the stated wanted result
  
  – Dimitre Novatchev
  Jun 11 at 23:38
  

  
  
  
  

add a comment | 

Parent and child tags have same name. I am trying to extract everything from parent except for the child elements.

We have several rows in parent that we want to extract. There are several Parent and child which are nested as below.

Have tried //Record/preceding-sibling::* which does not give me parent element start and end tag.
[not(descendant::Record)] and many other alternatives but no luck.

<Record contentId="1"> 
 <Metrics_Library_Name>Text1</Metrics_Library_Name> 
 <Metrics_Library_ID>1</Metrics_Library_ID> 
 <Record contentId="1a"> 
 <Questionnaire_ID>1a</Questionnaire_ID> 
 <Year>2018</Year> 
 <Quarter/> 
 <Month>02-Feb</Month> 
 </Record> 
 <Record contentId="1b"> 
 <Questionnaire_ID>1a</Questionnaire_ID> 
 <Year>2018</Year> 
 <Quarter/> 
 <Month>02-Feb</Month> 
 </Record> 
</Record>

Expected output:

<Record contentId="1"> 
 <Metrics_Library_Name>Text1</Metrics_Library_Name> 
 <Metrics_Library_ID>1</Metrics_Library_ID> 
</Record>

postgresql-9.5 xpath-2.0

share|improve this question

edited Mar 26 at 4:26

BPM

asked Mar 26 at 4:16

BPMBPM

622 bronze badges

<Record contentId="1"> 
 <Metrics_Library_Name>Text1</Metrics_Library_Name> 
 <Metrics_Library_ID>1</Metrics_Library_ID> 
 <Record contentId="1a"> 
 <Questionnaire_ID>1a</Questionnaire_ID> 
 <Year>2018</Year> 
 <Quarter/> 
 <Month>02-Feb</Month> 
 </Record> 
 <Record contentId="1b"> 
 <Questionnaire_ID>1a</Questionnaire_ID> 
 <Year>2018</Year> 
 <Quarter/> 
 <Month>02-Feb</Month> 
 </Record> 
</Record>

<Record contentId="1"> 
 <Metrics_Library_Name>Text1</Metrics_Library_Name> 
 <Metrics_Library_ID>1</Metrics_Library_ID> 
</Record>

share|improve this question

edited Mar 26 at 4:26

BPM

asked Mar 26 at 4:16

BPMBPM

622 bronze badges

share|improve this question

edited Mar 26 at 4:26

BPM

asked Mar 26 at 4:16

BPMBPM

622 bronze badges

asked Mar 26 at 4:16

BPMBPM

622 bronze badges

asked Mar 26 at 4:16

BPMBPM

622 bronze badges