10-19-2010
Scrutinizer - If it was that easy with grep, why would I waste your time.
the problem really is just not the $ETL_VW_SCHEMA, the way its generated with in the quotes and text coming after that(table name).
i.e as I mentioned, this is how it looks :
FROM '"${ETL_VW_SCHEMA}"'.PROJ
FROM '"${ETL_VW_SCHEMA}"'.PROJ_ABC
FROM '"${ETL_VW_SCHEMA}"'.PROJ_XXX
FROM '"${ETL_VW_SCHEMA}"'.PROJ_YYY
FROM '"${ETL_VW_SCHEMA}"'.PROJ_ZZZ
----
----
----
I just need to extract PROJ(the first line) and I am sure there is a way of doing this if not grep.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Being new to shell scripting I hope this question isn't too elementary but here goes.
I run a grep statement - grep 'sqr' sqrmodule.par and the grep statement returns correctly the information that I'm looking for. Now I want to take the output from the grep statement and load it into a... (2 Replies)
Discussion started by: gettingstarted
2 Replies
2. Shell Programming and Scripting
i have such awk working fine but how to use variable instead of strings
awk '/asdasd.*asda.*asdasd/' file2.txt
This is not working:
awk '/${a}.*${b}.*${c}/' file2.txt
Thanks & regards
Peter (7 Replies)
Discussion started by: pp56825
7 Replies
3. Shell Programming and Scripting
Hi,
I have a reqmt as i have some values in array and I want to search each value in a file by grep command.
Here goes my scripting:
#!/bin/ksh
set -A ArrayA CENTER LEFT RIGHT
echo "ArrayA contains: ${ArrayAİ*¨}"
grep -e "${ArrayAİ*¨}" filename.txt
The above grep is working for... (4 Replies)
Discussion started by: prashant43
4 Replies
4. Programming
Hi all,
I have a problem, I need a grep -v but, the patterns of the grep should be C variables.
Example:
char var1="h";
char var2="o";
char var3="d";
system("grep -v \"var1 var2 var3\" file.txt");
----
----
----
I try it but... Can u help me?
Thanks beforehand
P.S. Sorry for... (4 Replies)
Discussion started by: AbelBs
4 Replies
5. Shell Programming and Scripting
Help,
I have a ksh script that has some variables within the grep command, I am then setting another variable that greps the variables that have greps within them.
cat $WORKINGDIR/meter_list.txt | while read meter
do
serialnum=$(cat masterlogfile.txt | grep "$meter" | awk '{ print $19 }'... (7 Replies)
Discussion started by: srichard9
7 Replies
6. Shell Programming and Scripting
Hello,
I want to only print lines where variables occur more than once using grep.
For eg:
Input:
$this is a comment
int a,b,c,b;
int b,c;
int d,e;
int f,g,f;
x=y+5;
For the above input, the output would be
int a,b,c,b;
int f,g,f;
I have done grep... (3 Replies)
Discussion started by: prasanna1157
3 Replies
7. Shell Programming and Scripting
Good day Geeks,
Am having an issue with using variables in a rather simple script, the script is as follows:
#!/bin/bash
### Script written by Adigun Gbenga
### Date: April 28, 2012
array=( 1 2 3 4 5 29 7 8 9... (6 Replies)
Discussion started by: infinitydon
6 Replies
8. Shell Programming and Scripting
Hello, this will be my first post. I've been browsing around for a bit and have found a lot of useful information on here, hopefully a solution can be provided to me.
Issue:
Alright, I am looking to search for strings within a file using variables.
I have a script that will accept 3 or 4... (2 Replies)
Discussion started by: JonLaberge
2 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
The issue I am having is part of a validation problem. My script will validate 3 or 4 parameters entered by the... (4 Replies)
Discussion started by: JonLaberge
4 Replies
10. Shell Programming and Scripting
Hi, I'm currently trying to use variables in grep on my script. Printing the variable via echo works fine. Also, if I hard coded the date of the appointment it works just fine. But, if I try to use the $DATE as an argument in grep it doesn't do anything.
#!/bin/bash
DATE=${2}/${3}/${1} ... (6 Replies)
Discussion started by: nuclearpenguin
6 Replies
LEARN ABOUT NETBSD
zfgrep
ZGREP(1) BSD General Commands Manual ZGREP(1)
NAME
zgrep, zegrep, zfgrep -- print lines matching a pattern in gzip-compressed files
SYNOPSIS
zgrep [grep-flags] [--] pattern [files ...]
zegrep [grep-flags] [--] pattern [file ...]
zfgrep [grep-flags] [--] pattern [file ...]
DESCRIPTION
zgrep runs grep(1) on files or stdin, if no files argument is given, after decompressing them with zcat(1).
The grep-flags and pattern arguments are passed on to grep(1). If an -e flag is found in the grep-flags, zgrep will not look for a pattern
argument.
zegrep calls egrep(1), while zfgrep calls fgrep(1).
EXIT STATUS
In case of missing arguments or missing pattern, 1 will be returned, otherwise 0.
SEE ALSO
egrep(1), fgrep(1), grep(1), gzip(1), zcat(1)
AUTHORS
Thomas Klausner <wiz@NetBSD.org>
BSD
December 28, 2003 BSD