on 06-25-2007 8:50 AM
Hi,
I've been trying to parse this string out to XML but not successful due to the quotes.
Sample string:
A Test,N/A,N/A,-,N/A,N/A,-,N/A,N/A,-,"1,454","1,604",10%,100.0%,69.0%,(31%),375,302,(19%),375,208,(44%), 25.34 , 40.79 ,(61%),10,-
I've leaving the properties as they are and also tried to set the StripQuotes to 0. And it is still returning the value "1,454" as 2 row items, 1 and 454.
Is this a bug? If it is, is there any other way to tokenize the string?
Cheers,
Yin San
Hi Yin San,
what service release of xMII are you running? I believe the StringListToXml action in 11.5.2 (SR2) ignored the "StripQuotes" property and never removed quotes from the input string. In version 11.5.3 (SR3), this has been fixed. Maybe upgrading might help?
Sascha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can probably use the "WebScraper" and a regex expression to achieve the a better result. The WebScraper is basically just a generic regex processor.
- Rick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.