Sponsored Content
Top Forums Programming [XQuery] How to Convert from JSON Message to XML Message with XQuery Post 302579855 by tien86 on Tuesday 6th of December 2011 10:19:24 PM
Old 12-06-2011
well i will do it in easier way for my hurry job...

Now, in above example, i can make a loop to get the value column.

John
null
Smith
false
21 2nd Street
....
//in here $string is the restful input message

for $c in fn:tokenize($string, ",") where fn:string-length($c) != 0
let $cut := fn:tokenize($c, ":")[last()]
let $value := fn:replace($cut,"\{|\}","")
let $seq1 := fn:insert-before($seq1,1,$value)
return <param value="{ $value }" />

====================================

So what i want to do now is : create a $seq with value is ("John", "null", "Smith" .... ) . This code is not work. Would you please take a look at my code?

Tien86
 

8 More Discussions You Might Find Interesting

1. Programming

How to limit max no of message in a posix message queue

Hii can anyone pls tell how to limit the max no of message in a posix message queue. I have made changes in proc/sys/fs/mqueue/msg_max But still whenever i try to read the value of max. message in the queue using attr.mq_curmsgs (where struct mq_attr attr) its giving the default value as 10.... (0 Replies)
Discussion started by: mohit3884
0 Replies

2. Shell Programming and Scripting

Need to extract XML message from log

I need help to extract a following SOAP-ENV:Header XML message from the log. XML message need to be extracted: *************************** <SOAP-ENV:Header> <ServiceGatewayHeader> <SourceApplicationId>OXL</SourceApplicationId> <Version>1.0</Version> <UserId>TEST</UserId>... (4 Replies)
Discussion started by: tjshankar
4 Replies

3. Shell Programming and Scripting

Move xml files from unix to message queue.

Hi, I need to move the XML files from the UNIX to the message queue. Please help me out to write the code.. Thanks, Mohana Krishnan (0 Replies)
Discussion started by: krishnan_6015@y
0 Replies

4. UNIX for Dummies Questions & Answers

Unable to extract a tag from a very long XML message

Hi I have a log file which contain XML message. I want to extract the value between the tag : <businessEventId>13201330</businessEventId> i.e., 13201330. I tried the following commands but as the message is very long, unable to do it. Attached is the log file. Please provide inputs. --... (3 Replies)
Discussion started by: Sapna_Sai
3 Replies

5. Programming

Validate queries XQUERY

Hi! I am working in an application jsp-java-xml , and i need to validate queries in xquery. For example If I put (in a text field) "for $x in XXX/yyy return data($x/tittle)" I need a bean(class) that show if the text is correct or not. And, if were posible, show the syntax error too. ... (2 Replies)
Discussion started by: avatarrr
2 Replies

6. Shell Programming and Scripting

Extract XML message from a log file using awk

Dear all I have a log file and the content like this file name: temp.log <?xml version="1.0" encoding="cp850"?> <!DOCTYPE aaabbb SYSTEM '/dtdpath'> <aaabbb> <tranDtl> <msgId>000001</msgId> </tranDtl> ..... </aaabbb> ... ... (1 Reply)
Discussion started by: on9west
1 Replies

7. Programming

[Xquery] How to do a increment in a For loop

Hello men. How can i build a simple increment for $a by Xquery such as ? let $a := 0 for $i in (1 to 10) let $a := $a + 1 return $a why a in this loop always is '1' Thank you for reading, its will really helpful for my job if i can solve this problem :D:D (3 Replies)
Discussion started by: tien86
3 Replies

8. Shell Programming and Scripting

Convert json to xml

Hello everyone, I have created a workflow that will pull down data via a RESTful API in JSON, then my code parses and modifies said data. The problem I have is that these APIs I am working with only accept XML to PUT/POST data, and I am looking for an easy way to convert my JSON file to XML. ... (2 Replies)
Discussion started by: Zaphod_B
2 Replies
STRTOK(3)								 1								 STRTOK(3)

strtok - Tokenize string

SYNOPSIS
string strtok (string $str, string $token) DESCRIPTION
string strtok (string $token) strtok(3) splits a string ($str) into smaller strings (tokens), with each token being delimited by any character from $token. That is, if you have a string like "This is an example string" you could tokenize this string into its individual words by using the space character as the token. Note that only the first call to strtok uses the string argument. Every subsequent call to strtok only needs the token to use, as it keeps track of where it is in the current string. To start over, or to tokenize a new string you simply call strtok with the string argument again to initialize it. Note that you may put multiple tokens in the token parameter. The string will be tokenized when any one of the characters in the argument are found. PARAMETERS
o $str - The string being split up into smaller strings (tokens). o $token - The delimiter used when splitting up $str. RETURN VALUES
A string token. EXAMPLES
Example #1 strtok(3) example <?php $string = "This is an example string"; /* Use tab and newline as tokenizing characters as well */ $tok = strtok($string, " "); while ($tok !== false) { echo "Word=$tok<br />"; $tok = strtok(" "); } ?> The behavior when an empty part was found changed with PHP 4.1.0. The old behavior returned an empty string, while the new, correct, behavior simply skips the part of the string: Example #2 Old strtok(3) behavior <?php $first_token = strtok('/something', '/'); $second_token = strtok('/'); var_dump($first_token, $second_token); ?> The above example will output: string(0) "" string(9) "something" Example #3 New strtok(3) behavior <?php $first_token = strtok('/something', '/'); $second_token = strtok('/'); var_dump($first_token, $second_token); ?> The above example will output: string(9) "something" bool(false) NOTES
Warning This function may return Boolean FALSE, but may also return a non-Boolean value which evaluates to FALSE. Please read the section on Booleans for more information. Use the === operator for testing the return value of this function. SEE ALSO
split(3), explode(3). PHP Documentation Group STRTOK(3)
All times are GMT -4. The time now is 03:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy