Unix cut: Print same Field twice

shell unix sed cut
ghosh'. picture ghosh'. · Sep 13, 2012 · Viewed 7.1k times · Source

Say I have file - a.csv

ram,33,professional,doc
shaym,23,salaried,eng

Now I need this output (pls dont ask me why)

ram,doc,doc,
shayam,eng,eng,

I am using cut command

cut -d',' -f1,4,4 a.csv

But the output remains

ram,doc
shyam,eng

That means cut can only print a Field just one time. I need to print the same field twice or n times. Why do I need this ? (Optional to read) Ah. It's a long story. I have a file like this

#,#,-,-
#,#,#,#,#,#,#,-
#,#,#,-

I have to covert this to

#,#,-,-,-,-,-
#,#,#,#,#,#,#,-
#,#,#,-,-,-,-

Here each '#' and '-' refers to different numerical data. Thanks.

Answer

Gilles 'SO- stop being evil' picture Gilles 'SO- stop being evil' · Sep 13, 2012

You can't print the same field twice. cut prints a selection of fields (or characters or bytes) in order. See Combining 2 different cut outputs in a single command? and Reorder fields/characters with cut command for some very similar requests.

The right tool to use here is awk, if your CSV doesn't have quotes around fields.

awk -F , -v OFS=, '{print $1, $4, $4}'

If you don't want to use awk (why? what strange system has cut and sed but no awk?), you can use sed (still assuming that your CSV doesn't have quotes around fields). Match the first four comma-separated fields and select the ones you want in the order you want.

sed -e 's/^\([^,]*\),\([^,]*\),\([^,]*\),\([^,]*\)/\1,\4,\4/'

Related questions

Find and replace in file and overwrite file doesn't work, it empties the file

I would like to run a find and replace on an HTML file through the command line. My command looks something like this: sed -e s/STRING_TO_REPLACE/STRING_TO_REPLACE_IT/g index.html > index.html When …

Read More
Bash tool to get nth line from a file

Is there a "canonical" way of doing that? I've been using head -n | tail -1 which does the trick, but I've been wondering if there's a Bash tool that specifically extracts a line (or a range of lines) from a …

Read More
Replace a string in shell script using a variable

I am using the below code for replacing a string inside a shell script. echo $LINE | sed -e 's/12345678/"$replace"/g' but it's getting replaced with $replace instead of the value of that variable. Could anybody tell what went wrong?

Read More