From: Alistair McKeown (Alistair.Mckeown@jacobsrimell.com)
Date: Wed Mar 23 2005 - 09:50:25 EST
Hi Gurus,
I need a simple script or command to strip down a csv file I have.
Its in the format
5510739,S L B,Schipper,,,AD00MGB02,0,,,,,UPC Telefonie
(Jaarcontract),mta1657,VOIP47320
6830061,J.,Veng,,,AD00MGB02,0,,,,,UPC Telefonie
(Jaarcontract),mta1675,VOIP47338
6737440,N,Lamrini,,,AD00MGA02,0,False,INT00737257,Abonnement chello
Light,,,mta1694,VOIP47357
5061341,BI,Rifaela,,,AD00MGA02,0,,,,,UPC Telefonie
(Jaarcontract),mta1777,VOIP47440
What I need to do is to take the first number then only the first character
of the second value and all of the characters from the third value so would
end up only with
5510739,S,Schipper
6830061,J,Veng
6737440,N,Lamrini
5061341,B,Rifaela
I sure it must be easy!
Regards,
Alistair.
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:30:25 EDT