Which is the best way to achieve this in a hash file
Code: Select all
Input:
COL1,COL2,COL3,COL4,COL5
A,B,C,D,1
A,B,C,D,2
A,B,C,D,3
E,F,G,H,10
E,F,G,H,20
E,F,G,H,30
OutPut:
Last column separated by any delimiter ex:char(250)
A,B,C,D,1|2|3
E,F,G,H,10|20|30
A,B,C,D,1|2|3|1|2 and some of them are good.
I am not sure whether my approch is correct or not but is there any better way of doing this?
thanks