Create a new line when a value changes in data
Posted: Fri May 17, 2019 9:20 pm
I have a file that contains details and id - when then id changes I want a different output line. Is this possible?
Iput looks like below
id details
10 detail 1
10 detail 2
10 detail 3
10 detail 4
11 detail 1
11 detail 2
12 detail 99
12 detail 1
Desired output is
For Id 10 we have: Detail 1
detail 2
detail 3
detail 4
For Id 11 we have: Detail 1
detail 2
For Id 12 we have: Detail 1
detail 99
Iput looks like below
id details
10 detail 1
10 detail 2
10 detail 3
10 detail 4
11 detail 1
11 detail 2
12 detail 99
12 detail 1
Desired output is
For Id 10 we have: Detail 1
detail 2
detail 3
detail 4
For Id 11 we have: Detail 1
detail 2
For Id 12 we have: Detail 1
detail 99