Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Question on cut

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Question on cut
# 1  
Old 06-28-2012
Question on cut
Korn Shell

I have a file whose values are delimited using colon ( : )
Code:
$ cat test.txt
hello:myde:temp:stiker


$ cut -d: -f2,4 test.txt
myde:stiker

I want field 2 and field 4 to be returned but separated by a hyphen. The output should look like
Code:
myde-stiker

How can do this ? (without awk if possible)
# 2  
Old 06-28-2012
Edit :
Code:
 
$  echo "hello:myde:temp:stiker" | cut -d:   --output-delimiter='-' -f2,4
myde-stiker

Sorry for the first code.
Deleted it Smilie
# 3  
Old 06-28-2012
@max-hammer

could you describe more about what you mean by this

Code:
--output-delimiter='-' -f2,4

---------- Post updated at 07:01 AM ---------- Previous update was at 07:00 AM ----------
# 4  
Old 06-28-2012
It didn't work for me

Code:
# echo "hello:myde:temp:stiker" | cut -d:  --output-delimiter='-' -f2,4
cut: illegal option -- output-delimiter=-
usage: cut -b list [-n] [filename ...]
       cut -c list [filename ...]
       cut -f list [-d delim] [-s] [filename]

#
# echo "hello:myde:temp:stiker" | cut -d:  --output-delimiter="-" -f2,4
cut: illegal option -- output-delimiter=-
usage: cut -b list [-n] [filename ...]
       cut -c list [filename ...]
       cut -f list [-d delim] [-s] [filename]

# cut -d: -f2,4 test.txt --output-delimiter="-"
myde:stiker
cut: cannot open --output-delimiter=-


# cut -d: -f2,4 test.txt --output-delimiter='-'
myde:stiker
cut: cannot open --output-delimiter=-

My environment
Code:
# uname -a
SunOS tigris178 5.10 Generic_147441-01 i86pc i386 i86pc

# echo $0
ksh

# 5  
Old 06-28-2012
Quote:
--output-delimiter=STRING
use STRING as the output delimiter the default is to use the input delimiter
Its working for me

you can try this

Code:
 
$ echo "hello:myde:temp:stiker" | cut -d:  -f2,4 | tr ':' '-'
myde-stiker

This User Gave Thanks to max_hammer For This Post:
kraljic
# 6  
Old 06-28-2012
Or revert to awk:
Code:
awk -F: '{print $2,$4}' OFS=- infile

Last edited by Scrutinizer; 06-28-2012 at 10:01 AM..
# 7  
Old 06-28-2012
Thank You max_hammer. tr worked for me
Code:
# cut -d: -f2,4 test.txt | tr ':' '-'
myde-stiker

---------- Post updated at 07:32 AM ---------- Previous update was at 07:30 AM ----------

Thank you scrutinizer. awk worked as well
Code:
# cat test.txt | awk -F: '{print $2,$4}' OFS=-
myde-stiker

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

A question on cut

hi, I used cut to get the I have a file f1 with content: 101.2 ms RTT from 3WHS 95.2 ms RTT from 3WHS 97.3 ms RTT from 3WHS 97.4 ms RTT from 3WHS 122.2 ms RTT from 3WHS 103.5 ms RTT from... (2 Replies)
Discussion started by: esolve
2 Replies

2. Shell Programming and Scripting

Simple Cut Question

I've got a file that contains a large list of links in this type of style: 'home_dir\2009\09\01\file.html' I'd like to cut off all of the characters left of 'file.html'. I tried: cat file.txt | cut -d\ -f4 but it told me that I had an invalid delimiter. So I tried: cat... (5 Replies)
Discussion started by: Rally_Point
5 Replies

3. UNIX for Dummies Questions & Answers

Question on the cut command

Suppose one has a file consisting of more than 2 columns and one has to extract a few columns from this file and swap some columns at the same time. Example: extract column 1, 2 and 4 from a file foo.csv and place them in the order 2, 4 and 1 into file foo.txt. I would be inclined to do this: cut... (4 Replies)
Discussion started by: figaro
4 Replies

4. UNIX for Dummies Questions & Answers

cut awk dummy question :)

how to make cut and awk treat "a b" as a single column rather then two separate columns "a and b"? how to remove " symbol from "a b" so there is only a b? Please help Regards Karol (14 Replies)
Discussion started by: sopel39
14 Replies

5. UNIX for Dummies Questions & Answers

Cut Question

Hi, I have created a variable abc within my script which can have values as follows abc = Ram,Iam or it can be abc = Uam or it can be abc = Sam,Tam,Pam Basically it can have a max of 3 values , seperated by comma. I want to assign these 3 values to 3 different variables In case of... (2 Replies)
Discussion started by: samit_9999
2 Replies

6. Shell Programming and Scripting

The cut command. Really simple question!

hi, sorry for asking what I am sure is a really easy question, I am wanting to cut the users real name from the output of 'finger'. $ cut -f2-3 filename is in my script but it only seems to cut the first line. I need to cut the 2nd and 3rd word from each line and store them in variables... (1 Reply)
Discussion started by: rorey_breaker
1 Replies

7. Shell Programming and Scripting

sort / cut question

Hi All, I have a small problem, hope you can help me out here. I have a file that contains the same format of lines in 99% of the cases. 906516 XYZ.NNN V 0000 20070711164648 userID1 userID2 hostname 20070711164641 There are unfortunately several lines with these... (5 Replies)
Discussion started by: BearCheese
5 Replies

8. Shell Programming and Scripting

SED and Cut question

I am trying to cut and delete using sed and redirect back into the file. This is not working write. When testing the script, it hangs. Any idea what I am doing wrong here. ################ Reads the input file to cut volumes for returns and CUT_ERVTAPE_FILE() { echo "working on cut... (2 Replies)
Discussion started by: gzs553
2 Replies

9. Shell Programming and Scripting

Cut -d Question

I went through quite a few threads and didn't find anything on this. I also looked on other sites and couldn't turn up an answer. For completeness sake, I'm working off of solaris 10 in the korn shell environment. I wrote a script for a buddy to help him out with the following issue. He... (12 Replies)
Discussion started by: Janus
12 Replies

10. UNIX for Dummies Questions & Answers

cut question

#!/bin/bash echo "UserName PID Command" ps -ef > ps.temp grep '^\{2,3\}\{4\}' ps.temp > ps.temp2 cut -f1,2,8 ps.temp2 rm ps.temp* I am having some problems with the cut command. I only want to display the UID (field 1), PID(field 2), and Command(field 8). Right now the whole ps -ef... (5 Replies)
Discussion started by: knc9233
5 Replies
Login or Register to Ask a Question