Hi all,
I am trying to concatenate the content of the row with the parsed characters of its previous rows:
Word( 1, :Col1[Row() - 1] || "-" || Words( :Col1, "-" )[2] )
Col1 has the following two rows:
ABCD123-1
ABCD123-2
It results the following:
"ABCD123-1-2"
How can I remove the quotation marks sow it shows the following
ABCD123-1-2
Journeyman...