5

HELP WITH SEARCH AND SUBSTITUTE IN "|" DELIMITED FILE

view full story
linux-howto

http://www.unix.com – Hi I have a "|" delimited file as shown below. Code: 55987|2011-04-07|09:30: 8.0|09:30:27.4|9194 55988|2011-04 07|09:30:21.0|09:30:27.4|9199 55989|2011-04-07|09:30:25.0|09:30:27.5|9176 55990|2011-04-07|09:29:33.0|09:30:27.5|9196 55991|2011-04-07|09:30:21.0|09:30:27.5|9199 55992|2011-04-07|09:30:27.0|09:30:27.5|9195 I want " .0 " and " .4 " , " .5 " be removed from column 3rd and 4th respectively.So that my records should be like ... Code: 55987|2011-04-07|09:30: 8|09:30:27|9194 55988|2011-04 07|09:30:21|09:30:27|9199 55989|2011-04-07|09:30: (HowTos)