Login or Register to Ask a Question and Join Our Community


awk and regular expression


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk and regular expression
# 1  
Old 05-22-2007
awk and regular expression

Ive got a file with words and also numbers.
Bla BLA
10 10
11 29
12 89
13 35

And i need to change "10,29,89,25" and also remove anything that contains actually words A-Z.
Got it this far:
awk '$2 > 0 {$2=20;}{print}' file

works good to change the second line to 20, however the answe is going into a DB so i need to remove "Bla and BLA from the outout, the answer.

I am guessing the answer should be something like:
awk '$2 > 0 && -ne [A-Z] {$2=20;}{print}' file
# 2  
Old 05-22-2007
Code:
awk ' $2 ~ "^[0-9]+$" && $2 > 0 {$2=20;print} ' filename

# 3  
Old 05-22-2007
work

This seems to work so far:

awk ' /[0-9]/ {print} ' file | awk '$2 > 0 {$2=20;}{print}'

However the file also contains words in the end of the file.
Bla BLA
10 11
11 25
12 30
13 25
Bla,bla,bla,bla,bla

Ouput now looks like this now:
10 20
11 20
12 20
13 20
Bla,bla,bla,bla,bla

But still got the last line to remove.
# 4  
Old 05-22-2007
Thank you for the answer.
It seems to work but to the actually file....

I get no output at all to the actually file but if i do a file like the example it works..
The actually file looks like this:
"OL_ID OL_LINK_COST

----------- ------------

51 10

52 10

53 10

54 10

55 10

56 10

57 10

58 10

59 10

60 10

61 10

62 20

63 10

64 10

65 10

66 10

67 10

68 10

69 10

70 10

71 10

72 10

73 10

74 10

75 10

76 20

77 10

78 10

93 20

94 20

95 20

96 20

97 20

98 20

99 20

100 20

101 10

102 20

103 20

104 20

105 20

106 20

107 20

108 20

109 20

110 20

111 20

112 10

113 20

114 20

126 10

127 20

128 10

129 20



54 record(s) selected."
# 5  
Old 05-22-2007
thank you

Thank you Anbu23
It helped me, alot!

awk ' $2 ~ "^[0-9]" && $2 > 0 {$2=20;print} ' file

This worked when i removed +$
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk regular expression search

Hi All, I would like to search a regular expression by passing as an i/p variableto AWK. For Example :: 162.111.101.209.9516 162.111.101.209.41891 162.111.101.209.9516 162.111.101.209.9517 162.111.101.209.41918 162.111.101.209.9517 162.111.101.209.41937 162.111.101.209.41951... (7 Replies)
Discussion started by: Girish19
7 Replies

2. Shell Programming and Scripting

Problem with Regular expression in awk

Hi, I have a file with two fields in it as shown below 14,30 28,30 16,30 22,30 21,30 3,30 Fields are separated by comma ",". I've been trying to validate the file based on the condition "each field must be a numeric value" I am using HP-UX OS. I have tried the following awk... (4 Replies)
Discussion started by: meetsriharsha
4 Replies

3. Shell Programming and Scripting

awk regular expression

Hello, I have big files which I wanna filter them based on first column. first column should be one of these strings: chr2L || chr2R || chr3L || chr3R || chr4 || chrX and something like chr2Lh or chrY or chrM3L is not accepted. I used the following command: awk '{ if ($1=="chr2L" ||... (5 Replies)
Discussion started by: @man
5 Replies

4. Programming

Perl: How to read from a file, do regular expression and then replace the found regular expression

Hi all, How am I read a file, find the match regular expression and overwrite to the same files. open DESTINATION_FILE, "<tmptravl.dat" or die "tmptravl.dat"; open NEW_DESTINATION_FILE, ">new_tmptravl.dat" or die "new_tmptravl.dat"; while (<DESTINATION_FILE>) { # print... (1 Reply)
Discussion started by: jessy83
1 Replies

5. Shell Programming and Scripting

Regular expression in AWK

Hello world, I was wondering if there is a nicer way to write the following code (in AWK): awk ' FNR==NR&&$1~/^m$/{tok1=1} FNR==NR&&$1~/^m10$/{tok1=1} ' my_file In fact, it looks for m2, m4, m6, m8 and m10 and then return a positive flag. The problem is how to define 10 thanks... (3 Replies)
Discussion started by: jolecanard
3 Replies

6. UNIX for Advanced & Expert Users

Regular Expression Error in AWK

I have a file "fwcsales_filenames.txt" which has a list of file names that are supposed to be copied to another directory. In addition to that, I am trying to extract the date part and write to the log. I am getting the regular expression error when trying to strip the date part using the "ll"... (1 Reply)
Discussion started by: madhunk
1 Replies

7. Shell Programming and Scripting

Regular expression query in AWK

Hi, I have a string like this-->"After Executing service For 10 Request" in this string i need to extract "10". the contents of the string is variable and "10" appears before "For" and after "Request" i.e, in this format "For x Request" I need to extract the value of x. How to do this in AWK?... (10 Replies)
Discussion started by: omprasad
10 Replies

8. Shell Programming and Scripting

need help guys for Regular expression in awk

Hello Experts, Please help me to cope with the following problem I ve patterens like Input Noptx(5) // remain the same -*Nop(3); Nop(9); --Nop(8); // remain the same d3 **---Nop(7); //remain the same d3 **---Nop(7); *--Nop(6); --**Nop(5); -Nop(4); Nop(3); - represents a space... (2 Replies)
Discussion started by: user_prady
2 Replies

9. UNIX for Dummies Questions & Answers

regular expression and awk

I can print a line with an expression using this: awk '/regex/' I can print the line immediately before an expression using this: awk '/regex/{print x};{x=$0}' How do I print the line immediately before and then the line with the expression? (2 Replies)
Discussion started by: nickg
2 Replies

10. Shell Programming and Scripting

Regular expression query in AWK

I have a varable(var1) in a AWK script that contain data in the following format - I need to extract timestamp,priority and log message.I can extract these by using split function but i don't want to use it, since i want to extract it in one go. I have some difficulties in doing it using... (3 Replies)
Discussion started by: omprasad
3 Replies
Login or Register to Ask a Question

Featured Tech Videos