Forum Discussion
BlakeHarrison
5 years agoQrew Captain
If you use Pipelines, you can capture the response in a text field and then parse the raw XML with a Formula Text (or Formula Numeric, since your value looks to be a number). You'll need to use a combination of SearchAndReplace and then Part. Probably something like this:
------------------------------
Blake Harrison
[email protected]
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
var text a = SearchAndReplace([XML],"\">","*");
var text b = SearchAndReplace($a,"</","*");
Part($b,2,"*")
------------------------------
Blake Harrison
[email protected]
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------