Hi All,
I need help with Perl Concatenation based on a condition.
In the example file below, the condition is as long as the ID is the same the values of fields need to be concatenated. The expected output will show what I mean.
My Input file is attached.
I want output in the below format
UC "TS_206" /DATA=(ACTION_ORDER=["1","2","3","4"],ACTION_DATE=["26/07/15","26/07/15","26/07/15","26/07/15"],ACTION_COMMENT=["Created","InProgress","Tested","Completed"])
UC "TS_450" /DATA=(ACTION_ORDER=["1","2","3"],ACTION_DATE=["02/08/15","03/08/15","03/08/15"],ACTION_COMMENT=["Created","InProgress","Rejected"])
Please help with the looping syntax.
Many thanks in advance.
I need help with Perl Concatenation based on a condition.
In the example file below, the condition is as long as the ID is the same the values of fields need to be concatenated. The expected output will show what I mean.
My Input file is attached.
I want output in the below format
UC "TS_206" /DATA=(ACTION_ORDER=["1","2","3","4"],ACTION_DATE=["26/07/15","26/07/15","26/07/15","26/07/15"],ACTION_COMMENT=["Created","InProgress","Tested","Completed"])
UC "TS_450" /DATA=(ACTION_ORDER=["1","2","3"],ACTION_DATE=["02/08/15","03/08/15","03/08/15"],ACTION_COMMENT=["Created","InProgress","Rejected"])
Please help with the looping syntax.
Many thanks in advance.