Bash, remove numbers after colon


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Bash, remove numbers after colon
# 1  
Old 05-12-2013
Bash, remove numbers after colon

Hello All,
I was wondering if someone might know how to do this. I have a word list that is format like the example below. I need to take away the :number after that... is there some kind of command I could use to remove them?

Code:
123456:5562
password:1507
123456789:989
qwerty:877
12345678:621
111111:570
abc123:450
123123:446
dragon:389
sayang:374


Last edited by Scrutinizer; 05-12-2013 at 10:01 AM.. Reason: code tags
# 2  
Old 05-12-2013
The fastest way is by "parameter expansion". See the "#", "%", "##" and "%%" operators in the man page for bash, like in:

Code:
var="12345:12345"
echo ${var%%:*}
echo ${var##*:}

I hope this helps.

bakunin
# 3  
Old 05-12-2013
What do you meam by "word list"?
An array? A string variable? A here document? A file?
# 4  
Old 05-12-2013
With awk
Code:
awk -F: '{print $1}' file

With sed
Code:
sed 's/ *:.*//' file

# 5  
Old 05-12-2013
Yeah I just meant a text file such as the one in my first post.
Cheers for the help guys.
# 6  
Old 05-12-2013
Quote:
Originally Posted by 3therk1ll
Yeah I just meant a text file
In this case you should read the file line by line and then do what i showed you in a loop, like this:

Code:
while read var ; do
     echo ${var%%:*}
done < /path/to/text.file

Instead of the "echo" insert whatever you want to do with the value. Using "awk" or "sed" (or "perl" or whatever) for the same purpose will be slower because these programs have to be invoked while parameter expansion is done within the shell itself.

If your goal is not solely to produce a modified file (in this case "sed" is the best solution) but to do something inside the shell with the values thus generated you should do it like i told you.

I hope this helps.

bakunin
# 7  
Old 05-12-2013
A shell script is slower than sed and awk and even perl if the input file is big enough.
(BTW in my measurements bash was much slower than ksh.)
Another shell variant is
Code:
while IFS=: read var junk
do
  echo "$var"
done < /path/to/text.file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Bash to remove find and remove specific extension

The bash below executes and does find all the .bam files in each R_2019 folder. However set -x shows that the .bam extension only gets removed from one .bam file in each folder (appears to be the last in each). Why is it not removing the extension from each (this is $SAMPLE)? Thank you :). set... (4 Replies)
Discussion started by: cmccabe
4 Replies

2. Shell Programming and Scripting

Remove numbers

how to remove all numbers from this.Using sed command 1. abcd123 2. 312jjs33 (17 Replies)
Discussion started by: rafa_fed2
17 Replies

3. Shell Programming and Scripting

Sort numbers which has colon (:) in between

Although i tried multiple option i couldn't find a way to get the rigt ouput. Say i have the following data cat file.txt C request C response C request C response The output should look like (9 Replies)
Discussion started by: varu0612
9 Replies

4. Shell Programming and Scripting

Remove Numbers from file

I have a file that has some text that looks like this Some Text 1. More text 2. Different text Final Text I would like the remove the lines of text that start with the numbers. Some Text Final Text I have tried to use cat file.txt | grep -Ev 1. >... (9 Replies)
Discussion started by: icculus99
9 Replies

5. Shell Programming and Scripting

Remove char after Colon

Hi guys, This is my input 2735:<7001> 34 789 701 2 2774:<7001> 34 789 701 2 How to delete characters after colon : Including colon : too ? My output should... (3 Replies)
Discussion started by: gowrishankar05
3 Replies

6. Shell Programming and Scripting

bash aliases and command chaining with ; (semi-colon)

What am I doing wrong here? Or is this not possible? A bug? alias f='find . >found 2>/dev/null &' f ; sleep 20 ; ls -l -bash: syntax error near unexpected token `;' (2 Replies)
Discussion started by: star_man
2 Replies

7. Shell Programming and Scripting

remove the numbers

How can I remove the numeric (1,2,3,4,5,etc.) in front of each line? The file look like this.. 1CREATE OR REPLACE pROD (p_sc_id number, 2 p_snap_id number , p_sid number, p_halt varchar2 default 'N', p_a_nm varchar2 ) 3 as 4 v_rtn number; 5 6 v_rtn... (3 Replies)
Discussion started by: Beginer0705
3 Replies

8. Shell Programming and Scripting

How to remove numbers from filename

Hi all, Can I edit this script: find . -type f | while read i;do && mv "$i" "${i//abc/}" ;done so that it will not only take out abc from the filename but also take out any numbers that might be in the filename as well. An example would be, Input: filename abc 2009.mov Output:... (7 Replies)
Discussion started by: Monkey Dean
7 Replies

9. Shell Programming and Scripting

remove a colon and number and leaving the rest

just have a file 1:2333 2:-09393 ]3:45453 4:-09999 5:-09933 6:93939 question is to get output by removing colons as well as number before each colon (in bold) 2333 -09393 45453 -09999 09933 93939 (5 Replies)
Discussion started by: cdfd123
5 Replies

10. Shell Programming and Scripting

How to remove all lines with something other than numbers

Hi, How would I get rid of lines having something else than numbers (such as tabs,white space, special characters, empty line, letters). So I have big file with numers as follows: 12345678901 23456789012 32343678901 42345638901 52345678901 and I sometimes the file might contain some... (2 Replies)
Discussion started by: Juha
2 Replies
Login or Register to Ask a Question