Easy question about strings

[gpeirce]

Can someone tell me the code to use to find the 8th double-quoted value in the below string? (The string will always have the // { leader. Also, it looks like the string contains carriage returns and line feeds because it comes out like this in the debug print).

// [
{


"id": "22808"
,"t" : "MRK"
,"e" : "NYSE"
,"l" : "61.87"
,"l_fix" : "61.87"
,"l_cur" : "61.87"


The above is the result of running the URL: strURL = "http://finance.google.com/finance/info?client=ig&q=NSE:MRK". The stock price is always the 8th item, right after the l. I don't know if you use the string command, unstring command, a "find" command, or what.

Thank you so much.

[pbaldy]

I would probably create a function that accepted the string and a number as inputs. It would use the Split() function to put the various elements into an array, then pull out the desired value based on the number input. It would probably have to use the Mid() function to pull out whatever is after the colon. That would let you use it to pull out any of the elements.

[orange]

Is there more to the string than you have shown?? It looks like part of a JSON response.

[gpeirce]

Thank you for asking. The whole string is below. I took Paul's idea of Split and found that array (8) will contain:

"61.87"
,"l_fix"

Now all i have to do is figure out how to isolate the 61.87.

The full original string is:



// [
{
"id": "22808"
,"t" : "MRK"
,"e" : "NYSE"
,"l" : "61.87"
,"l_fix" : "61.87"
,"l_cur" : "61.87"
,"s": "0"
,"ltt":"4:00PM EST"
,"lt" : "Nov 18, 4:00PM EST"
,"lt_dts" : "2016-11-18T16:00:41Z"
,"c" : "-0.83"
,"c_fix" : "-0.83"
,"cp" : "-1.32"
,"cp_fix" : "-1.32"
,"ccol" : "chr"
,"pcls_fix" : "62.7"
}
]

[pbaldy]

You must have split on the colon? I would probably have used the carriage return to keep the values together. In any case, you can try the Replace() function to get rid of the quotes and the Val() function.

[gpeirce]

Paul, it worked great. My coding is sloppy but using the Split and the left command and the replace command it all worked. Thank you for your help!!!

[pbaldy]

Happy to help!