Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

\r as delimiter in cut

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting \r as delimiter in cut
# 1  
Old 06-07-2007
\r as delimiter in cut
I need to use \r as a delimiter in the -d option of the cut comand .
Any help ?
Thanks in advance .
SD
# 2  
Old 06-07-2007
Code:
cut -d"\r" ....

jean-Pierre.
# 3  
Old 06-07-2007
I tried that . but it throws an eror as : the delimiter should be a single character .
Thanks
SD
# 4  
Old 06-07-2007
Quote:
Originally Posted by shweta_d
I tried that . but it throws an eror as : the delimiter should be a single character .
Thanks
SD
No error on my AIX box under ksh, but result is invalid :
Code:
$ od -c cutcm.txt
0000000    a   a   a  \r   b   b   b   b   b  \r   c   c   c   c   c  \n
0000020    x   x   x  \r   y   y   y   y   y  \r   z   z   z   z   z  \n
0000040
$ cut -d"\r" -f2 cutcm.txt
ccccc
zzzzz
$ cut -d"\r" -f1 cutcm.txt | od -c 
0000000    a   a   a  \r   b   b   b   b   b  \r   c   c   c   c   c  \n
0000020    x   x   x  \r   y   y   y   y   y  \r   z   z   z   z   z  \n
0000040
$

Replace your cut command by awk. For example :
Code:
$ awk -F"\r" '{print $2}' cutcm.txt
bbbbb
yyyyy
$ awk -F"\r" '{print $2}' cutcm.txt | od -c
0000000    b   b   b   b   b  \n   y   y   y   y   y  \n
0000014
$

Jean-Pierre.
# 5  
Old 06-07-2007
Shweta,
See if this works for you.
Try picking a character that you know it does not exist in the file.
Do an "egrep" of the character in the file, first.
Lets say the character is "|", then:
Code:
sed 's/\\r/|/' input_file | cut -d'|' ...

# 6  
Old 06-07-2007
sed doesn't like \r, uses ^M instead (^M = ctrl/V + ctrl/M) :
Code:
$ sed 's/\\r/|/g' cutcm.txt | od -c
0000000    a   a   a  \r   b   b   b   b   b  \r   c   c   c   c   c  \n
0000020    x   x   x  \r   y   y   y   y   y  \r   z   z   z   z   z  \n
0000040
$ sed 's/^M/|/g' cutcm.txt | od -c 
0000000    a   a   a   |   b   b   b   b   b   |   c   c   c   c   c  \n
0000020    x   x   x   |   y   y   y   y   y   |   z   z   z   z   z  \n
0000040
$

You can also use tr :
Code:
$  tr '\r' '|' <cutcm.txt | od -c   
0000000    a   a   a   |   b   b   b   b   b   |   c   c   c   c   c  \n
0000020    x   x   x   |   y   y   y   y   y   |   z   z   z   z   z  \n
0000040
$

Jean-Pierre.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Cut cmd with delimiter as |#|

Hi All- We have a file data as below with delimiter as |#| 10|#|20|#|ABC 13|#|23|#|PBC If I want to cut the 2nd field out of this, below command is not working as multiple pipe is causing an issue , it seems cut -f2 -d"|#|" <file_name> can you please help to provide the correct command... (7 Replies)
Discussion started by: sureshg_sampat
7 Replies

2. Shell Programming and Scripting

cut delimiter and save

i have list of names in a text file and I wanted to delete the commas en every line. for example: inside the text is a list of names in it with commas after each line. I wanted to delete these commas. which command must I execute for this? unix, dale, shawn, aaron, (4 Replies)
Discussion started by: garfish
4 Replies

3. Shell Programming and Scripting

cut with delimiter respect text

Hi, Can someone help me to get the shortest command Input file ========= I|know|"english|french" It|can|have|four|delimiters Desired output =========== "english|french" have If I use cut -d "|" -f3 , i am getting "english as 3rd field.But I would like to get the whole text in... (2 Replies)
Discussion started by: anandapani
2 Replies

4. Shell Programming and Scripting

How to cut by delimiter, and delimiter can be anything except numbers?

Hi all, I have a number of strings like below: //mnt/autocor/43°13'(33")W/ and i'm trying to get the numbers in this string, for example 431333 please help thanks ahead (14 Replies)
Discussion started by: sunnydanniel
14 Replies

5. Shell Programming and Scripting

how to cut all string after the last delimiter?

hi all, suppose a string: abc/def/ghi/jkl/mn.txt and i want to get the file name without the path. however, different files have different paths, therefore the number of delimiter is uncertain. thanks so much! (3 Replies)
Discussion started by: sunnydanniel
3 Replies

6. Shell Programming and Scripting

Cut columns with delimiter

HI, I have a file like below "103865","103835","Zming","","Zhu","103965","Sunnyvale","US", "116228","116227","Morlla","","Kowalski","113228","Paese "(Treviso)""IT" I want to validate the 7th column which is below. "Sunnyvale" "Paese In the above 7th column Paese is not ended with... (9 Replies)
Discussion started by: Krrishv
9 Replies

7. Shell Programming and Scripting

cut -d with more than 1 delimiter?

I need to cut or otherwise get the 4th and 5th position output of for i in `date +%H` ; do vnstat --dumpdb | grep "h;$i" ; done example output is: h;13;1310318701;443;93 I only need ";443;93" from any given run of "for i in `date +%H` ; do vnstat --dumpdb | grep "h;$i" ; done" Thanks... (3 Replies)
Discussion started by: Habitual
3 Replies

8. UNIX for Advanced & Expert Users

use a word as a delimiter with cut

Is there a way to use a word as a delimiter with cut? Or is there a way to use sed or awk with a word as a delimiter? I don't care which program I use for a delimiter I just want to use a word as a delimiter. (2 Replies)
Discussion started by: cokedude
2 Replies

9. Shell Programming and Scripting

Cut Number which appear before a delimiter

Hi All, How can i use the cut option to only output the number of rows, which is 2 is this case ? Pls note that the number of digit before the delimiter ":" is always varying. $ grep -n uuu xxx 2:** xxx yyy gg 44 tt uuu 2007 $ (2 Replies)
Discussion started by: Raynon
2 Replies

10. UNIX for Advanced & Expert Users

Cut date using y hat as delimiter

QUESTION: How can I cut out the date from just the first line and reformat it to 31-Jul-2007? I'll restate the question at the bottom again... DESCRIPTION: I need to cut a date out of a file - an example of the date's format in the file is 2007-07-31. It's in the 5th field and is separated... (1 Reply)
Discussion started by: tekster757
1 Replies
Login or Register to Ask a Question