13

Converting txt file to Excel file

view full story
linux-howto

http://www.unix.com – Hi All, I have a text file with below content. Code: TradeDate Name    SecurityMnc  ReasonDesc        ======================================= 20120501  Robin    ABC      FO System Defect  20120502  Robin    ABC      FO System Defect I would want this in an excel file in 4 columns, am trying some thing with AWK but problem is am getting like below. This is causing excel file to display it in 6 columns.. last field is considering as 3 columns :( Code: TradeDate,Name,Securi (HowTos)