hi there i have this problem , i need cut the 4 first character and the 6 last characters of the word
this is my file
'dg_bancdist_logs'
'dg_tibco_logs'
'dg_rmp_logs'
'dg_mig_logs'
'dg_titan_logs'
'dg_swift_logs'
'dg_isis_logs'
'dg_isisges_logs'
and i need this
... (4 Replies)
hi to all
i wrote a script to cut a word from the file....that works only if the word is fixed field.
example..
sed -n '1p'|awk '{ print $2 }'|cut -d '(' -f2|sed 's/(//'|sed 's/)//'|sed 's/"//g' filename
i know that word is starting with "app" then "(" ----> ex: app("xxxx").
it... (2 Replies)
Hi,
sorry for newbie question :confused:
can't find how to cut ?
from
1000 2000 word some text1....
100 200 300 word some text2....
10 20 30 abc word some text3....
to
some text1....
some text2....
some text3.... (7 Replies)
Hi All,
I would like help with a script which can get rid of the first work of all lines in text file.
File 1
The name is Scott.
Output : name is Scott
---------- Post updated at 02:38 PM ---------- Previous update was at 02:37 PM ----------
Hi ALL
There is typo error in... (3 Replies)
Hi,
In my shell script, I am connecting to database and querying multiple columns in a table.
MESSAGE_TEXT=`sqlplus -s /nolog <<end_log_stmt
set heading off
set feedback off
set verify off
set termout off
set pages 0
CONNECT APPS/$USER_PWD
Select order_number, id, error_message... (6 Replies)
Is there a way to use a word as a delimiter with cut? Or is there a way to use sed or awk with a word as a delimiter? I don't care which program I use for a delimiter I just want to use a word as a delimiter. (2 Replies)
I would like to cut words based on the word count of a line. This over here inspired me with some ideas but I wasn't able to get what I needed.
https://www.unix.com/shell-programming-scripting/105841-count-words-each-line-file-using-xargs.html
If the line has 6 words I would like to use this.... (8 Replies)
I have a file with some SQL query, I want to fetch only Table Name from that file line by line.
INPUT FILE
SELECT * FROM $SCHM.TABLENAME1;
ALTER TABLE $SCHM.TABLENAME1 ADD DateOfBirth date;
INSERT INTO $SCHM.TABLENAME1 (CustomerName, Country) SELECT SupplierName, Country FROM $SCHM.TABLENAME2... (2 Replies)
in the below data i need to search for the word typeMismatch and then traverse back to find the filename of that particular mismatch. Like this we have to get all the file names which has error in them. How can i acheive this.
I tried use sed or awk but not able to achevie the same.
Sample... (2 Replies)
Discussion started by: ATWC
2 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::sybase
SQL::ReservedWords::Sybase(3pm) User Contributed Perl Documentation SQL::ReservedWords::Sybase(3pm)NAME
SQL::ReservedWords::Sybase - Reserved SQL words by Sybase
SYNOPSIS
if ( SQL::ReservedWords::Sybase->is_reserved( $word ) ) {
print "$word is a reserved Sybase word!";
}
DESCRIPTION
Determine if words are reserved by Sybase.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either Sybase ASE 12 or 15.
is_reserved_by_ase12( $word )
Returns a boolean indicating if $word is reserved by Sybase ASE 12.
is_reserved_by_ase15( $word )
Returns a boolean indicating if $word is reserved by Sybase ASE 15.
reserved_by( $word )
Returns a list with Sybase versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_ase12
is_reserved_by_ase15
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://infocenter.sybase.com/help/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::Sybase(3pm)