Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Cut cmd with delimiter as |#|

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cut cmd with delimiter as |#|
# 1  
Old 06-26-2013
Cut cmd with delimiter as |#|
Hi All-

We have a file data as below with delimiter as |#|
Code:
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
Code:
cut -f2 -d"|#|" <file_name>

can you please help to provide the correct command

Regards,
Suresh
Last edited by Franklin52; 06-26-2013 at 07:10 AM.. Reason: Please use code tags
# 2  
Old 06-26-2013
Hello,

Please use the following code to resolve this issue. I have just saved your data in tete12 file for example.


Code:
 
$ cat tete12
10|#|20|#|ABC
13|#|23|#|PBC

$ cat tete12 | awk -F"|#|" '{print$2}'
20
23


Please let me know if this helps.


Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
rbatte1
# 3  
Old 06-26-2013
awk
Try using awk

Code:
>awk -F"|#|" '{print $2}' filename

This User Gave Thanks to krishmaths For This Post:
rbatte1
# 4  
Old 06-26-2013
Thanks guys ..let me check these

---------- Post updated at 06:00 AM ---------- Previous update was at 05:10 AM ----------

Thanks all for help, it is working fine
This User Gave Thanks to sureshg_sampat For This Post:
rbatte1
# 5  
Old 06-26-2013
Thanks for the question, and the answers. I've learnt something too.


Robin
# 6  
Old 06-26-2013
I am curious what awks you are using on what OS and version? It should be:
Code:
awk -F'[|]#[|]' '{print $2} file

Last edited by Scrutinizer; 06-26-2013 at 03:49 PM..
# 7  
Old 06-27-2013
Quote:
Originally Posted by Scrutinizer
I am curious what awks you are using on what OS and version? It should be:
Code:
awk -F'[|]#[|]' '{print $2} file

I'm on AIX 5.3. Both the following commands work fine.

Code:
awk -F"|#|" '{print $2}' file
awk -F"[|]#[|]" '{print $2}' file
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. Shell Programming and Scripting

CUT command delimiter in reverse

Hi, I've a situation where, a=xxx.yyy.zzz.txt EXTN=`echo $a | cut -d . -f2` Using the above code it delimites and will return "yyy.zzz.txt" to EXTN. But i need to get only the extension "txt". so as per the above code it delimits in the first "." itself. Can anyone help how to do... (6 Replies)
Discussion started by: skcvasanth
6 Replies

8. 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

9. 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

10. Shell Programming and Scripting

\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 (5 Replies)
Discussion started by: shweta_d
5 Replies
Login or Register to Ask a Question