Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

matching text in quotes (newbie)

I'm getting totally lost in shell programming, mainly because every site I use offers different tool to do pattern matching. So my question is what tool to use to do simple pattern matching in piped stream.

context: I have named.conf file, and i need all zones names in a simple file for further processing. So I do ~$ cat named.local | grep zone and get totally lost here. My output is ~hundred or so newlines in form 'zone "domain.tld" {' and I need text in double quotes.

Thanks for showing a way to do this.

J

like image 395
jpou Avatar asked Apr 27 '09 07:04

jpou


People also ask

How do you match double quotes in regex?

Firstly, double quote character is nothing special in regex - it's just another character, so it doesn't need escaping from the perspective of regex. However, because Java uses double quotes to delimit String constants, if you want to create a string in Java with a double quote in it, you must escape them.

What does this regex do?

Short for regular expression, a regex is a string of text that lets you create patterns that help match, locate, and manage text. Perl is a great example of a programming language that utilizes regular expressions. However, its only one of the many places you can find regular expressions.

How do you match a space in regex?

\s stands for “whitespace character”. Again, which characters this actually includes, depends on the regex flavor. In all flavors discussed in this tutorial, it includes [ \t\r\n\f]. That is: \s matches a space, a tab, a carriage return, a line feed, or a form feed.

Can you use or in regex?

Alternation is the term in regular expression that is actually a simple “OR”. In a regular expression it is denoted with a vertical line character | . For instance, we need to find programming languages: HTML, PHP, Java or JavaScript.


3 Answers

I think what you're looking for is sed... it's a stream editor which will let you do replacements on a line-by-line basis.

As you're explaining it, the command `cat named.local | grep zone' gives you an output a little like this:

zone "domain1.tld" {
zone "domain2.tld" {
zone "domain3.tld" {
zone "domain4.tld" {

I'm guessing you want the output to be something like this, since you said you need the text in double quotes:

"domain1.tld"
"domain2.tld"
"domain3.tld"
"domain4.tld"

So, in reality, from each line we just want the text between the double-quotes (including the double-quotes themselves.)

I'm not sure you're familiar with Regular Expressions, but they are an invaluable tool for any person writing shell scripts. For example, the regular expression /.o.e/ would match any line where there's a word with the 2nd letter was a lower-case o, and the 4th was e. This would match string containing words like "zone", "tone", or even "I am tone-deaf."

The trick there was to use the . (dot) character to mean "any letter". There's a couple of other special characters, such as * which means "repeat the previous character 0 or more times". Thus a regular expression like a* would match "a", "aaaaaaa", or an empty string: ""

So you can match the string inside the quotes using: /".*"/

There's another thing you would know about sed (and by the comments, you already do!) - it allows backtracking. Once you've told it how to recognize a word, you can have it use that word as part of the replacement. For example, let's say that you wanted to turn this list:

Billy "The Kid" Smith
Jimmy "The Fish" Stuart
Chuck "The Man" Norris

Into this list:

The Kid
The Fish
The Man

First, you'd look for the string inside the quotes. We already saw that, it was /".*"/.

Next, we want to use what's inside the quotes. We can group it using parens: /"(.*)"/

If we wanted to replace the text with the quotes with an underscore, we'd do a replace: s/"(.*)"/_/, and that would leave us with:

Billy _ Smith
Jimmy _ Stuart
Chuck _ Norris

But we have backtracking! That'll let us recall what was inside the parens, using the symbol \1. So if we do now: s/"(.*)"/\1/ we'll get:

Billy The Kid Smith
Jimmy The Fish Stuart
Chuck The Man Norris

Because the quotes weren't in the parens, they weren't part of the contents of \1!

To only leave the stuff inside the double-quotes, we need to match the entire line. To do that we have ^ (which means "beginning of line"), and $ (which means "end of line".)

So now if we use s/^.*"(.*)".*$/\1/, we'll get:

The Kid
The Fish
The Man

Why? Let's read the regular expression s/^.*"(.*)".*$/\1/ from left-to-right:

  • s/ - Start a substitution regular expression
  • ^ - Look for the beginning of the line. Start from there.
  • .* - Keep going, reading every character, until...
  • " - ... until you reach a double-quote.
  • ( - start a group a characters we might want to recall later when backtracking.
  • .* - Keep going, reading every character, until...
  • ) - (pssst! close the group!)
  • " - ... until you reach a double-quote.
  • .* - Keep going, reading every character, until...
  • $ - The end of the line!

  • / - use what's after this to replace what you matched

  • \1 - paste the contents of the first group (what was in the parens) matched.
  • / - end of regular expression

In plain English: "Read the entire line, copying aside the text between the double-quotes. Then replace the entire line with the content between the double qoutes."

You can even add double-quote around the replacing text s/^.*"(.*)".*$/"\1"/, so we'll get:

"The Kid"
"The Fish"
"The Man"

And that can be used by sed to replace the line with the content from within the quotes:

sed -e "s/^.*\"\(.*\)\".*$/\"\1\"/"

(This is just shell-escaped to deal with the double-quotes and slashes and stuff.)

So the whole command would be something like:

cat named.local | grep zone | sed -e "s/^.*\"\(.*\)\".*$/\"\1\"/"
like image 68
Shalom Craimer Avatar answered Oct 26 '22 17:10

Shalom Craimer


Well, nobody mentioned cut yet, so, to prove that there are many ways to do something with the shell:

% grep '^zone' /etc/bind/named.conf  | cut -d' ' -f2
"gennic.net"
"generic-nic.net"
"dyn.generic-nic.net"
"langtag.net"
like image 43
bortzmeyer Avatar answered Oct 26 '22 17:10

bortzmeyer


1.

zoul@naima:etc$ cat named.conf | grep zone
zone "." IN {
zone "localhost" IN {
    file "localhost.zone";
zone "0.0.127.in-addr.arpa" IN {

2.

zoul@naima:etc$ cat named.conf | grep ^zone
zone "." IN {
zone "localhost" IN {
zone "0.0.127.in-addr.arpa" IN {

3.

zoul@naima:etc$ cat named.conf | grep ^zone | sed 's/.*"\([^"]*\)".*/\1/'
.
localhost
0.0.127.in-addr.arpa

The regexp is .*"\([^"]*\)".*, which matches:

  1. any number of any characters: .*
    • a quote: "
    • starts to remember for later: \(
    • any characters except quote: [^"]*
    • ends group to remember: \)
    • closing quote: "
    • and any number of characters: .*

When calling sed, the syntax is 's/what_to_match/what_to_replace_it_with/'. The single quotes are there to keep your regexp from being expanded by bash. When you “remember” something in the regexp using parens, you can recall it as \1, \2 etc. Fiddle with it for a while.

like image 1
zoul Avatar answered Oct 26 '22 18:10

zoul