B
BMC
I've got some data which originated from an external source (a Notes
database via NotesSQL) which has returned an array of some sort in one
of the columns.
So I've got data in cells like value1**value2**value3. Each * is
actually an empty square character, similar to what you get if you
haven't a font to display a particular character. When clicking on the
cell, the edit box a the top shows:
value1*
value2*
value3
i.e. the second of the empty boxes is replaced by a carriage return.
I wonder if this is a Unixy carriage return I've got here?
Now what I need is for each value to go into its own row, duplicating
the simple values in the other columns in the row. There is not a
constant number of values in this array.
Help!
database via NotesSQL) which has returned an array of some sort in one
of the columns.
So I've got data in cells like value1**value2**value3. Each * is
actually an empty square character, similar to what you get if you
haven't a font to display a particular character. When clicking on the
cell, the edit box a the top shows:
value1*
value2*
value3
i.e. the second of the empty boxes is replaced by a carriage return.
I wonder if this is a Unixy carriage return I've got here?
Now what I need is for each value to go into its own row, duplicating
the simple values in the other columns in the row. There is not a
constant number of values in this array.
Help!