R
Ryan Keeling
Hi
I have the following text file which I want to use to populate text
files containing data only relevant to a particular project. Is it
possible for me to group similar lines together and put them in their
own text file? Such as a file containing all entries for
MS102_PCP.Implementation and another file for MS102_PCP.Support.
Any help would be greatly appreciated!
2004:01:07:3:02:MS102_PCP:Belfast:ChargeCP:Implementation:+:5.5
2004:01:07:3:02:MS102_PCP:Belfast:ChargeCP:Support:+:2.0
2004:01:05:1:02:MS102_PCP:Belfast:ChargeCP:Implementation:+:7.5
2004:01:09:5:02:MS102_PCP:Belfast:ChargeCP:Meetings:+:1.0
2004:01:20:2:04:MS102_PCP:Belfast:ChargeCP:Standards:6.5
2004:01:19:1:04:MS102_PCP:Belfast:ChargeCP:Standard:7.5
2004:02:03:2:06:MS102_PCP:Belfast:ChargeCP:Support:+:2.0
2004:03:02:2:10:MS102_PCP:Belfast:ChargeCP:Implementation:+:5.5
2004:03:03:3:10:MS102_PCP:Belfast:ChargeCP:Implementation:+:7.5
2004:03:02:2:10:MS102_PCP:Belfast:ChargeCP:Support:+:2.5
2004:03:26:5:13:MS102_PCP:Belfast:ChargeCP:Support:+:7.5
2004:03:29:1:14:MS102_PCP:Belfast:ChargeCP:Support:+:8.0
2004:03:30:2:14:MS102_PCP:Belfast:ChargeCP:Implementation:+:8.0
2004:01:05:1:02:MS102_PCP:Belfast:ChargeCProject-Control:+:7.5
2004:01:06:2:02:MS102_PCP:Belfast:ChargeCP:Meetings:+:2.0
2004:01:06:2:02:MS102_PCP:Belfast:ChargeCP:Meetings:+:0.7
Ryan
I have the following text file which I want to use to populate text
files containing data only relevant to a particular project. Is it
possible for me to group similar lines together and put them in their
own text file? Such as a file containing all entries for
MS102_PCP.Implementation and another file for MS102_PCP.Support.
Any help would be greatly appreciated!
2004:01:07:3:02:MS102_PCP:Belfast:ChargeCP:Implementation:+:5.5
2004:01:07:3:02:MS102_PCP:Belfast:ChargeCP:Support:+:2.0
2004:01:05:1:02:MS102_PCP:Belfast:ChargeCP:Implementation:+:7.5
2004:01:09:5:02:MS102_PCP:Belfast:ChargeCP:Meetings:+:1.0
2004:01:20:2:04:MS102_PCP:Belfast:ChargeCP:Standards:6.5
2004:01:19:1:04:MS102_PCP:Belfast:ChargeCP:Standard:7.5
2004:02:03:2:06:MS102_PCP:Belfast:ChargeCP:Support:+:2.0
2004:03:02:2:10:MS102_PCP:Belfast:ChargeCP:Implementation:+:5.5
2004:03:03:3:10:MS102_PCP:Belfast:ChargeCP:Implementation:+:7.5
2004:03:02:2:10:MS102_PCP:Belfast:ChargeCP:Support:+:2.5
2004:03:26:5:13:MS102_PCP:Belfast:ChargeCP:Support:+:7.5
2004:03:29:1:14:MS102_PCP:Belfast:ChargeCP:Support:+:8.0
2004:03:30:2:14:MS102_PCP:Belfast:ChargeCP:Implementation:+:8.0
2004:01:05:1:02:MS102_PCP:Belfast:ChargeCProject-Control:+:7.5
2004:01:06:2:02:MS102_PCP:Belfast:ChargeCP:Meetings:+:2.0
2004:01:06:2:02:MS102_PCP:Belfast:ChargeCP:Meetings:+:0.7
Ryan