07-05-2010
How to get a known word between two known words using awk
hi
I have posted it earlier but i was unable to put my exact problem.This time posting in parts.
I have a text file which i had transferred to UNIX.It has strings like:
alter table table_name add (column_name);
as well as modify options.
now i need to read the table name between alter table and add for all such strings.Then need to check itz availability in my database(this part i can do).
Please help me with code.I need to do it in SH if possible.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a Template file 'TL.body' which says as follows:
"There are no <FILENAME> files on the server. "
The missing file names are identified and stored in a variable.
For Eg: MISSFILE="abc.txt def.txt xyz.txt"
I want the values of MISSFILE variable to be replaced against... (2 Replies)
Discussion started by: brap45
2 Replies
2. UNIX for Dummies Questions & Answers
how do i get a word that exists between two words
eg: this is bryan
My input to command would be this and bryan
and output should be 'is'
Is there a command i can use? (4 Replies)
Discussion started by: bryan
4 Replies
3. UNIX for Advanced & Expert Users
Hi,
I am trying to filter the words from a file which contain 'abc'. But I am unable to. Could any one help me.
For eg: The file contents are
123ab 12hnj1 123abc456 123cgbcahjkf23 23134abchfhj43 gc32abc abc1 2abc3 sd uiguif fhwe 21242 uh123 jkcas124d123 u3hdbh23u ffsd8
Output... (3 Replies)
Discussion started by: venu_eie
3 Replies
4. Shell Programming and Scripting
Dear,
Can somebody help me with this?
I have a variable
TGT=T2DIRUPDAZ20070326VA
I want to get in variables some part of TGT. like this.
TGT1=UPDA
TGT2=20070326
TGT3= VA
These three variables have fixe position in variable TGT. (2 Replies)
Discussion started by: yeclota
2 Replies
5. Shell Programming and Scripting
Hi Guys, :p
I have a file like this:
2010-04-25 00:00:30,095 INFO - ]- start process U100M4
2010-04-25 00:00:30,096 DEBUG - ] -- call EJB
2010-04-25 00:00:30,709 INFO - - end processU100M4
2010-04-25 00:00:30,710 DEBUG - got message=Sorry
I want to out put format.
2010-04-25... (5 Replies)
Discussion started by: ooilinlove
5 Replies
6. Shell Programming and Scripting
Hi,
I want to print all words till the last word after the match of "ERROR" word. For e.g.
I'll get an sqlplus error with
e.g. 1
$ ./calltest_fn.ksh
var test_var:=test_fn1; calltest_fn.ksh file1 file2 file3 ERROR at line 4: ORA-06550: line 4, column 11: PLS-00201: identifier... (5 Replies)
Discussion started by: dips_ag
5 Replies
7. Shell Programming and Scripting
Hi all,
I have 7 words
Now I have 1 file which contain data in large number of rows and columns
and 6th column contain any of these words or may be more than one words among above 7 words:
I want
script should search for the above mentioned 7 words in the 6th column
... (9 Replies)
Discussion started by: manigrover
9 Replies
8. Shell Programming and Scripting
Hi below is the input file, i need to find repeated words and sum up the values of it which is second field from the repeated work.Im trying but getting no where close to it.Kindly give me a hint on how to go about it
Input
fruits,apple,20,fruits,mango,20,veg,carrot,12,veg,raddish,30... (11 Replies)
Discussion started by: 100bees
11 Replies
9. UNIX for Dummies Questions & Answers
I have an assignment and I am not sure what to do.
In Unix, I use PuTTY
change the semicolon (;) to a period, and capitalize the first letter of the word immediately after it.
I know change command is M-% and "." so only one semicolon is changed but I am not sure how to... (1 Reply)
Discussion started by: kathrut43
1 Replies
10. Shell Programming and Scripting
I have a sample text file with file name: sample.txt
The text file has the following text.
this is an example text where we have to extract certain words before and after certain word these words can be used later to get more information
I want to extract n (a constant) words before and... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies
sh(1) General Commands Manual sh(1)
NAME
sh - Shell, the standard command language interpreter
DESCRIPTION
[Tru64 UNIX] Tru64 UNIX provides two command interpreters with the name sh. The XCU5.0 and POSIX.2 compliant command interpreter sh is
available in the file /usr/bin/posix/sh and is described in the sh(1p) reference page. The Bourne shell, historically known as sh, is
available in the file /usr/bin/sh and is described in the sh(1b) reference page.
[Tru64 UNIX] Your initial, or login, shell is determined by your entry in the file /etc/passwd. This file can be changed only by your sys-
tem administrator. You must use whatever procedures are in place at your location to have this entry changed.
[Tru64 UNIX] If available on your system, you may use the passwd -s or the chsh commands to change your login shell.
Note
This option is not available if your site manages passwords through the Network Information Service (NIS) facility. Check with your system
administrator.
[Tru64 UNIX] Subsequent shells spawned from the initial shell depend on the value in the environment variable BIN_SH. If this variable is
set to xpg4, the POSIX shell is started. If this variable is set to svr4, an SVR4 compliant version of the shell is started. If this vari-
able is unset, the Bourne shell is started. If this variable is set to any other value, an error is reported and the results are unpre-
dictable. See the EXAMPLES section for information on setting this variable.
NOTES
[Tru64 UNIX] With Tru64 UNIX Version 4.0 the Korn shell, /usr/bin/ksh is the same as the POSIX shell /usr/bin/posix/sh.
RESTRICTIONS
[Tru64 UNIX] The file /etc/shells must include entries for both the POSIX shell /usr/bin/posix/sh and the Bourne shell, /usr/bin/sh. If
this file is incorrect, see your system administrator.
EXAMPLES
Using the Bourne, Korn, or POSIX shell, to set the variable BIN_SH to use the POSIX/ XCU5.0compliant shell, enter: BIN_SH=xpg4 export
BIN_SH Using the Bourne, Korn, or POSIX shell, to set the variable BIN_SH to use the SVR4 compliant shell, enter: BIN_SH=svr4 export BIN_SH
Using the Bourne, Korn, or POSIX shell, to unset the variable BIN_SH, enter: unset BIN_SH Using the C/ shell, to set the variable BIN_SH to
use the POSIX/XCU5.0 compliant shell, enter: setenv BIN_SH xpg4 Using the C/ shell, to set the variable BIN_SH to use the SVR4 compliant
shell, enter: setenv BIN_SH svr4 Using the C/ shell, to unset the variable BIN_SH, enter: unsetenv BIN_SH
FILES
User profile. Contains user information, including the login shell name. Contains the names of available and permitted shells.
SEE ALSO
Commands: csh(1), ksh(1), Bourne shell sh(1b), POSIX shell sh(1p), passwd(1)
Files: passwd(4), shells(4)
Standards: standards(5)
sh(1)