How do I parse out multiple values from a single database item?

Hello,

I have a problem where some database items return multiple values in a column that can be seen onscreen by expanding the field.  I need to treat these values as individual items when utilizing the data later on.  I thought an array would work but I may not understand what an array is for, or maybe, just not how to set it up properly.

This is what I'm seeing in the database for "current value":

F20.0
F03.91
E11.65
E78.5
I10
Z79.4

So can I do anything to separate this out, or do I have to do something prior to obtaining the database information from my spreadsheet?

Thanks in advance, to anyone who can help!

Hello David,

 If you have your list in a variable, you can use our "loop list" action to process one item at a time.

Attached is a small sample code that shows how this would work. Make sure to change the delimiter to "new line":

If you have your list in a dataset, you would use the "loop dataset" action. The concept would remain the same.

Please let us know if this works for you.

Sample task