I extract information from a database using an SQL statement. There is basically 3 colums with many rows of data. Anyway, I end up taking the first row and using push to got to a list.
I end up with somthing like this?
These are just an example and are not the same data but basically, I want to be able to make the list look like this:
@somelist=("A"," "," ","B"," ","C"," ")
Basically replacing the elements found more than once with a blank space. I am trying to write a report back as a table but don't want show this A or B or C or ? more than once.
The table would end up looking like this:
A x x
B x x
C x x
These two other colums are different arrays and can't be touched so I am only concerned with the first list. The criteria is that the element is not known but once it is identified as being there, the rest of the same elements must be replaced with a blank space......
I don't know any other way to put this so let me know if you need more information.