David Gardiner Senior Decision Support Analyst

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!