Need to Parse one value from two lines of data

[Purple Haze]

Hi,

I'm doing a cfhttp request to a shipping rate provider and the response I get
back looks like this:

GND, NAS, SDS, EXP
$6.50, $12.25, $7.85, $14.00

The problem is that I only need to display to my end user the first bit of
data on the second line.
I thought I would be ok by parsing out the response and setting my delimiter
to a comma, but unfortunately the end of the first line doesn't end with a
comma so my code considers "EXP
$6.50" to be the value at position 4.

Anyone have any ideas on how I can just pull out the $6.50?




<cfhttp method="post" url="http://www.weburl.com">

<CFOUTPUT>
<cfhttpparam name="fromZip" type="formfield" value="#Zip_VendorInfo#">
<cfhttpparam name="toZip" type="formfield"
value="#GetShippingInformation.OrderShippingZip#">
<cfhttpparam name="weight" type="formfield"
value="#NumberFormat("#ShippingWeight#")#">
<cfhttpparam name="acctNum" type="formfield" value="#AccountNumber#">
</cfoutput>
</cfhttp>

<!--- here's the value being sent back from the server --->
<cfset api_response=cfhttp.fileContent>

<cfif isdefined("api_response")>
<!--- This is where we parse out all the necessary responses --->
<CFLOOP INDEX="ListElement" LIST="#api_response#" DELIMITERS=","></CFLOOP>

<cfset numberDelims = ListLen(api_response, ",")>

<cfset MyList = api_response>
<cfset MyArray = ListToArray(MyList, ",")>

<cfloop index="Element" from="4" to="5">
<cfoutput>
<cfswitch expression="#Element#">
<cfcase value="4"><cfset GNDRate = #MyArray[Element]#></cfcase>
</cfswitch>
</cfoutput>
</cfloop>

Resp: <cfoutput>#GNDRate#</cfoutput>

</CFIF>

[jdeline]

Consider treating the reply as a $-delimited list. Your second list element would be 6.50,

<CFSET temp = ListGetAt(api_response, 2, "$")>
<CFSET price = Mid(temp, 1, Len(temp) - 1)>

[Purple Haze]

thanks that did the trick

[_jt]

If the result are returned as rows of comma-delimited lists, you should
parse them as such, using CR & LF as a row delimiter and a comma as the
column delimiter. This method is not dependant on the specific format of
the individual column values.

<cfset rowDelim = chr(10)&chr(13)>
<cfset row = ListGetAt(api_response, 2, rDelim)>
<cfset columns = ListToArray(row)>
<cfset GNDRate = columns[1]>