Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

csv processing using shell script

Comment:

Hi There, I have a strange problem: The csv which i need to process has 3 columns as shown below Test.csv Column1,Coulmn2,Column3 "Floor 1, Suite 2, Rack3",122333,222222 The command cut -d, -f 2,3 Test.csv > Test2.csv gives Test2.csv Coulmn2,Column3 Suite 2, Rack3 But i need Coulmn2,Column3 122333,222222 Is this possible. Please help

Reply:

Get rid of everything in quotes and keep everything after the the first comma. cat test.csv | cut -d'"' -f3 | cut -d, -f2-

1

Awk - split lines into ar...

Shell Script to copy part...

Summary: Hi, Here we are in a problem that our application is not working due to the lack of file locking by one user when multiple users execute the command simultaneously. We need to code that using ( standa...

Summary: Hi all, Do anybody knows how to get of parameter in shell script. Like : In my program i have some parameters i was to redirect the output based on parameters. Thanks Raja ...

Summary: I'm completely new to shell programming. As this is quite urgent, please offer your help. Thanks a lot! If there is a text file which contains: 1. Amt = 1000 Date = 01012003 =========================...