sql - Postgresql substring to extract between angle brackets and quotes -


I have an area in which xml is I am trying to extract the data from an attribute which is Gt; which remains at the end of the beginning tag of an element.

Example

I need 250 values. 

  & lt; Request id = "1111" "order =" "123456" scale = "" 250 "" & gt; & Lt; Project file = "test.txt" / / gt; & Lt; / Request & gt;

I want to remove it using this substring. So I did: 

  select substring from mytable (<% scale = "#"% # "" & gt; / Code>   
 But the problem is that the next element for the other record is  & lt; Pro  does not start 
 
 So I tried it 
 
  from mytable substring ('% scale' 'from # "% #" to' '' For '' 'for'% ') / Code>  
 It gives:  
  250 "& gt; Project file = "test.txt" /> & Lt; / Request & gt;  
 
 Where am I going? Is there a better way? thanks a lot.

If you are always sure that you type in scale attribute in If the requests are made after the element, then it can work for you (I have tried this only on PG 9.3.5): 

  SELECT (regexp_matches (myxml, ' & Lt; request [^ & gt;] *? \\ + scale = "" (\ d +) "" ')) [1] AS scale from my scale;

Some inappropriate fake data (I have variation in both sca values ​​and internal element names) as a display: 

 < Code> postgres = # SELECT * mytable; Myxml ------------------------------------------------- ------------------------------------------ & lt; Request id = "1111" command = "" 123456 "" scale = "" 250 "" & gt; Project file = "test.txt" "/ /> gt; Request & gt; & Lt; Request id = "1111" "order =" "123456" "scale =" "250" "& gt; & lt; not proof file =" "test.txt" "/ /> gt; request & gt; & lt; request Id = "1111" "order =" "123456" "scale =" "253" "& gt; & Lt; Not proof file = "" test.txt "" / /> gt; Request & gt; (3 lines) Postgres = # SELECT (regexp_matches (myxml, '& lt; request [^ & gt;] *? \ S + scale = "" (\ d +) ""')) [1] Scale; Scale ------- 250 250 253 (3 lines)

For special points of the value of the regular expression I used to be the scale Hope to join If your data can be different from that, then the capture part should be like (\ d +) instead of ([^ "] +) .


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more