replace time format
Hello All,
I have a problem with the following text file. For the field number 5 which is the time format (hh:mm:ss). But I would like to delete "ss" and showing hh:mm only.
00001,CLIENT,Company,1218,N,1:04,35,0.211,0,0.211,1.155531,0:00,0,0,0,0,0,1:04,35,0.211,0,0.211,1.15 5531,foold store,USD
00001,CLIENT,Company,1219,N,23:36,42,21.127,0,21.127,115.700959,0:00,0,0,0,0,0,23:36,42,21.127,0,21. 127,115.700959,food store,USD
00001,CLIENT,Company,1220,N,26:17:00,43,38.091,0,38.091,208.603457,0:00,0,0,0,0,0,26:17:00,43,38.091 ,0,38.091,208.603457,food store,USD
00001,CLIENT,Company,1221,N,27:35:00,111,33.775,0,33.775,184.967099,0:00,0,0,0,0,0,27:35:00,111,33.7 75,0,33.775,184.967099, food store, US$
Output will be:
00001,CLIENT,Company,1218,N,1:04,35,0.211,0,0.211,1.155531,0:00,0,0,0,0,0,1:04,35,0.211,0,0.211,1.155531,foold store,USD
00001,CLIENT,Company,1219,N,23:36,42,21.127,0,21.127,115.700959,0:00,0,0,0,0,0,23:36,42,21.127,0,21.127,115.700959,food store,USD
00001,CLIENT,Company,1220,N,26:17,43,38.091,0,38.091,208.603457,0:00,0,0,0,0,0,26:17:00,43,38.091,0,38.091,208.603457,food store,USD
00001,CLIENT,Company,1221,N,27:35,111,33.775,0,33.775,184.967099,0:00,0,0,0,0,0,27:35:00,111,33.775,0,33.775,184.967099, food store, US$
Last edited by happyv; 04-25-2007 at 01:06 AM..