Solved

bash: convert huge 2 col csv file to 1 col txt

Posted on 2013-12-02
3
327 Views
Last Modified: 2013-12-03
Hi

Can you help me with the command to convert a huge csv file to a txt file.

CSV:

"a.bc","12.3"
"er.4","j.43"
"4rt.234,"as.df"

TXT should bee like this (1st col from csv without double quotes)

a.bc
er.4
4rt.234

Thanks!
0
Comment
Question by:netslt
3 Comments
 
LVL 14

Accepted Solution

by:
jb1dev earned 500 total points
ID: 39690820
I assume that last line should be:
"4rt.234","as.df"

You can use
cat input.csv | sed 's/",".*//' | sed 's/"//'
0
 
LVL 19

Expert Comment

by:xterm
ID: 39691447
If you're just wanting to discard the quotes from the first value, and the second value entirely which is the way I understand it, then do this:

cat input.csv| cut -d, -f1 | tr -d '"' > input.txt

Open in new window


This way it will not matter if that missing quote pointed out by jb1dev is in some of the real input csv, or just a typo in the question - it will still do what you want.
0
 

Author Closing Comment

by:netslt
ID: 39691907
jb1dev has what I was looking for - works perfectly!

(xterm might also be right, have not tried....)

Thanks!
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question