I have a file which contains :
Col1 Col2 Col3 abc 23 good bad xyz 34 this that mno 45 great
My output should be :
col1 col2 col3 abc 23 good,bad xyz 34 this,that mno 45 great
Please help !!
Thanks Abhay
The difference is that your col3 values are multivalued fields, and you want them to be a single field where each value is separated by commas.
Try this on the end of your search:
eval col3=mvjoin(col3,",")