I have a group of multivalue fields that are listed with linebreaks . I'm looking to remove the line breaks from one field and have them separated by comma instead. Here is the structure and what I am looking for:
Original:
FieldA | FieldB |FieldC |FieldD |FieldE
Val1 | val1 | val1 | val1 | val1
| val2 | val2
| val3 | val3
| etc | etc
Val2 | val1 | val1 | val1 | val1
| val2 | val2
| val3 | val3
|etc |etc
Desired:
FieldA | FieldB |FieldC |FieldD |FieldE
Val1 | val1,val2,val3,etc | val1 | val1 | val1
| val2
| val3
| etc
Val2 | val1,val2,val3,etc | val1 | val1 | val1
| val2
| val3
| etc
Sorry if the formatting is a bit confusing. I tried using "makemv FieldB delim=","" and got the field values to appear on the same row but with a space instead of a comma. Any ideas?
I got it. Use mvjoin in an eval.
| eval FieldB=mvjoin(FieldB,",")