UNIX for Advanced & Expert Users

I have a .csv file with columns. In column I like to find which rows contain a certain pattern. That is, my column is:
CNR
CP
CSN
CTC
EF.DB.U
CTC.A
D.DB

Here, I like to do one thing with EF.DB.U and another with all other. So my question is; how should my if statement look like to detect rows with ".DB" ?

if (name=="./.DB.") {
do something
} else {
{ do another thing
}

This is what I tried but it did not work.

There is a tool missing, that is scanning the lines for your patterns like grep, or awk, or sed, ...
Depends on what you want to do with it, there are several ways.

@zaxxon: Thread subject suggests "awk"

In idiomatic awk, the condition is put before the action, like this:

Code:

awk '/\.DB\./ { do things with .DB. ; next }
{ this is the else part }

The next forces the script to bypass the default branch, and so that is only taken when \.DB\. is not matched.

Of course, if you are inside the default action already for other reasons, you can use something like

Code:

if ($1 ~ /\.DB\/) { yada yada } else { no yada }

$1 is the first field, $0 is the entire input line. If your example is representative, you could use either of those in the condition.

@era
That's a point, indeed.