Visit Our UNIX and Linux User Community


Summarize the sed script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Summarize the sed script
# 1  
Old 08-10-2009
Summarize the sed script

Hi folks,
I have a situation where i have a raw file like

cat file_raw

776 713 111
0776713113
317-713-114
235776713115
776713116
336713117
77 6 713 118
0776713119
235776713120

and would like to replace all leading zeros with 235, remove all spaces and dashes, and make all lines start with 235.

I have used the script below and works fine but would like to summarise it.

Code:
 
sed 's/^0//' file_raw > file_space
sed 's/ //g' file_space > file_lead7
sed 's/^7/2567/' file_lead7 > file_lead3
sed 's/^3/2563/' file_lead3 > file_dash
sed 's/-//g' file_dash > file_last

Expected output is
cat file_last

235776713111
235776713113
235317713114
235776713115
235776713116
235336713117
235776713118
235776713119
235776713120
# 2  
Old 08-10-2009
One way with awk:

Code:
awk '!/^235/{
  gsub("[ |-]","")
  sub("^0", "")
  $0="235"$0
}
{print}' file

# 3  
Old 08-11-2009
Code:
perl -ne  '{s/^0*(?!235)/235/;s/[- ]//g;print;}'

# 4  
Old 08-11-2009
Thanx guys,
Preferred the perl one.

Previous Thread | Next Thread
Test Your Knowledge in Computers #292
Difficulty: Easy
In 2011, Google introduced the Chromebook, a web thin client running Android..
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using awk to Summarize Log File in 5min Intervals

I have huge log file that taken every minute and I need the total at 5min intervals. Sample log: #timestamp(yyyymmddhhmm);result;transaction 201703280000;120;6 201703280001;120;3 201703280002;105;3 201703280003;105;5 201703280004;105;5 201703280005;105;4 201703280006;120;2... (2 Replies)
Discussion started by: wwolfking
2 Replies

2. Shell Programming and Scripting

Bash cript to calculate summarize address

Hi, I need to write a bash script that when i enter two ip address, it will calculate summerize address for them. Examlpe: 192.168.1.27/25 192.168.1.129/25 Result will be: 192.168.1.0/24 can you help me with this script? I even dont know how to start with it (3 Replies)
Discussion started by: Miron
3 Replies

3. Programming

Can someone summarize what exactly this perticular code is doing

#include<stdio.h> #include<string.h> int main() { char a={0,1,2,3,4,5,6,7,8,9}; printf("\n--%s-- unable to access values",a); printf("\n--%d %d-- able to access through direct acess",a,a); printf("\n--%d-- but the failing to read the size\n",strlen(a)); return 0; } (2 Replies)
Discussion started by: hk108
2 Replies

4. Shell Programming and Scripting

Summarize the values from files

One of my process will create a file Market.txt with data like below. Count Markt file 334936 /pdm/data001/P3_Quest_5HT_AMERGE.csv 2770787 /pdm/data001/P3_Quest_ARB_ATACAND.csv 1198143 /pdm/data001/P3_Quest_Bisp_ACTONEL.csv 3821864 /pdm/data001/P3_Quest_CONTRA_ALL_OTHER_CONTRA.csv... (7 Replies)
Discussion started by: katakamvivek
7 Replies

5. Shell Programming and Scripting

Summarize file with column matching

Guys, Please help me with this code. I have 2GB file to process and shell seems to be the best option. I am a biologist and though I can think of the logic, the commands are beyond me. Any help is greatly appreciated. Please look at the attched file and the requirement will be very clear. I... (6 Replies)
Discussion started by: newbie83
6 Replies

6. Shell Programming and Scripting

Using SED/AWK to Summarize Log File in 10min Intervals

I have this huge log file on my linux box that gets generated every day. I'm able to extract the information I need; however I really would like it to be broken down every 10mins. Log File Snippet 01:23:45 MARYHADA Maryhadalittle.lamb(): fleece as white as snow 1394 for and everywhere that... (8 Replies)
Discussion started by: ravzter
8 Replies

7. Shell Programming and Scripting

1. search 2nd pattern after a pattern and summarize stats

I have two questions. I am sure one of the Guru will be able to help either one or both. 1. Find 2nd occurance of pattern= "Bind variable after pattern="ABN USER Admin" ...... ABN USER Admin <--- I know this string ..... Bind variable ... .. Bind variable <-- Want to print this... (4 Replies)
Discussion started by: ran123
4 Replies

8. Shell Programming and Scripting

sed script

I am beginner for Unix. I practicing unix shell script. I worked out some sed script example from internet. Everything fine. But in real unix environment, where sed script is mainly used.? Can anyone give some examples for the usage of sed script in real unix environment. It will be useful for... (1 Reply)
Discussion started by: gwgreen1
1 Replies

9. Shell Programming and Scripting

sort and summarize

Hi Guys, I have a file in UNIX with duplicates, I have use sort command as below to delete duplicates based on the KEY positions/columns but now I do not want to "delete" duplicates but summarize by KEY numeric columns. REALLY NEED HELP... URGENT!!! Thanks in advance. sort -k 1.1,1.92... (6 Replies)
Discussion started by: shotronix
6 Replies

10. Shell Programming and Scripting

Help with Script may be using SED

Hello Everybody, I have a directory in Unix(AIX) called DATA where every month I get some data copied like the following:i.e in /DATA i have the following ENCTR01.TXT DISCH01.TXT DIAG01.TXT and many more rows like this..... I want to remove the '01' from these lines and make them... (4 Replies)
Discussion started by: thumsup9
4 Replies

Featured Tech Videos