Skip to main content
Question

Parsing a Text string and extracting values

  • September 23, 2022
  • 0 replies
  • 209 views
I am trying to Parse a Text string from a connected database to extract Location and Amount data. The string looks like this:

'FREMONT', null, ('157', null, null, null), null, null, null, 5634.88, null, null, null, 18050.0, null, 0.0, 18050.0, 0.0, null, null, null, null, null, null, null, null), (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'HAGERSTOWN', null, ('109', null, null, null), null, null, null, 5011.86, null, null, null, 20934.0, null, 0.0, 20934.0, null, null, null, null, null, null, null, null, null), (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'OPELIKA', null, ('112', null, null, null), null, null, null, 16224.42, null, null, null, 54332.0, null, 0.0, 54332.0, 0.0, null, null, null, null, null, null, null, null), (null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 

Is there any way of doing this?



------------------------------
Thomas Ringkamp
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • September 23, 2022
what is the result that you want.
Mark

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement