Questions tagged [extract-value]
50 questions
0
votes
1 answer
exctractvalue from xmltype / soap oracle
i need to get "ineedthis" value from field
REQUEST_INFO:
...
pmipmi
- 109
- 1
- 1
- 4
0
votes
0 answers
ExtractValue for multiple elements
Need to get:
firstdatavalue
seconddatavalue
values from text
and dont know if using EXTRACTVALUE is best option
firstdata
firstdatavalue
…
Edgars Ceplis
- 11
- 2
0
votes
1 answer
Extract value from XML column and use it inside WHERE clause
I have a below xml type data in both oracle and MSSQL database.
10
1001
DEBIT
USD
USD1000110010001
60000.00
The column type is of…
Karthick88it
- 601
- 2
- 12
- 28
0
votes
1 answer
Parse specific string my matching pattern from a input text file in bash
I am passing a text file as a command line input to a script and need to parse through the file searching for a specific pattern:
00 TOOL | Running /variable/directory/path/to/the/tool/executable in batch (pid xxxxx)
Now I have to extract…
RandomCoder
- 79
- 1
- 7
0
votes
1 answer
How to parse XML data in pipe delimited format and insert into table
newbie
- 75
- 1
- 8
0
votes
1 answer
Use of extractValue function more than one time in oracle give duplicate data from first or last record for all rows
Suppose I have a customer table.
And there are three columns (id [type-Number], name [type-Varchar2], detail [type-XMLTYPE].
Detail column contain address of customer in xml format including his name which is same as second column name.
First sql…
anna
- 265
- 1
- 3
- 17
0
votes
1 answer
python3: Extract same type value from Json file
The following is my Json file which is decoded on base64.
response={"response": [{"objcontent": [{"title": "Pressure","rowkeys": [
"lat",
"lon",
"Pressure"
],
…
popo
- 11
- 2
0
votes
1 answer
ExtractValue Xml in Pl/Sql
I try to parse value in this xml in pl/sql.
I want to get 1 tag value so that its '1'
Can you help me please :( ?
H Bıyıkcı
- 25
- 1
- 8
0
votes
3 answers
ExtractValue with MySQL
I'm attempting to extract a username value from XML output that was loaded into a database column (file_output). My query is bringing back a null value and not performing as I expect it to. Your help is appreciated.
XML output:
Tone
- 765
- 10
- 24
- 51
0
votes
2 answers
How to Extract xmltype as xml in Oracle
I am trying to extract xml from the xmltype doc.
DECLARE
xmlData XMLType;
sDocumentId VARCHAR2(100);
sFormat VARCHAR2(100);
cData CLOB;
BEGIN
xmlData := XMLType( '
…
Prateik
- 241
- 2
- 6
- 14
0
votes
1 answer
Issue with ExtractValue function of mysql
set @xml = 'demo';
select extractvalue(@xml ,'/a');
I want to extract value for both the string with
< a > demo< /a > and < a > demo < /a > at the same time.
Is it possible using lower-case function or something. I want to extract…
user3612181
- 603
- 1
- 5
- 8
0
votes
4 answers
Extracting value from a flat file using shell script
I'm trying to extract the value present between brackets in the last row of a flat file e.g. " last_line (4) ". This is the last line and I want to extract 4 and store it in a variable. I have extracted the last row using tail command but now I am…
daniyal.bashir
- 88
- 4
- 14
0
votes
2 answers
Java get specific content from file
I want to read text from a file which looks like:
Look up for : Bergwald Elsa-Brändström-Str
http://www.overpass-api.de/
output:
The data included in this…
Nazar Medeiros
- 437
- 4
- 10
0
votes
1 answer
blob displays on extractvalue in mysql workbench 6.2
I am using MySQL Workbench (6.2.3) and I am using ExtractValue() to grab data from an XML string. Using code similar to:
Select
Table2.user_id,
ExtractValue(TableName, '//CustomerSource//LeadID') as LeadID.
ExtractValue(TableName,…
Matthew Rumsey
- 1
- 1
0
votes
1 answer
Count number of rows where Extract Value found a match
100,000 rows in a table which contains a column that stores a large XML block, I need to check if there is a certain XML tag is filled with data in this column, lets say the column is called test_request and the XML tag is named 'd'. Also I want to…
Matthew Underwood
- 1,459
- 3
- 19
- 33