cells
Hello everyone,
I have a column in my database where some cells have duplicate characters like below:
The goal would be to remove items that are duplicated in the same cell: row 2 -> "354" and row 6 -> "789" but the other cells in the column do not change
Can order change within the cell? And if there are no duplicates (such as row 4) is the " -" necessary?
Names Default To Here(1);
dt = New Table("Untitled",
Compress File When Saved(1),
New Column("Column 1",
Character,
"Nominal",
Set Values({"a -a", "a - b", "a - c", "b - b", "b - c", "b - b", "b -"})
)
);
dt << New Column("Column 2", Character, Nominal, << Set Each Value(
Concat Items(Associative Array(Words(:Column 1, "- ")) << get keys, " - "));
);Re: CellsThank you for your reply,
Yes the order can change even if it is rather rare, we can have "abac" for example.
The "-" is not necessary but it is not disturbing either, just at best that everything is standardized, that is to say each time to have the "-" or never to have it.
