I use vim. I have a lot of SQL queries to write, and am hoping there is some wild command I can use in vim to make this simpler.
From a file that is a list of fields, like the excerpt, for example:
I want to go to this:
I'm not sure if such a thing can be done with one line of command. Fortunately, all lines will be in the same format.. tablename.fieldname. so I know that I need to do something like:
If this is possible what would the proper syntax be?
pattern match and substitution, can you help?
file named test.txt
I want to replace all the words Event with the word Fatal in all lines containing the word ERR - but I also want to keep the output of the other lines not matching ERR
Test.txt:
Event 13 INF egegegege
Event 14 INF... (4 Replies)
hi,
I have to execute this line below from within a shell script; simply backquoting it is not doing the trick; it is mangling up all the options; but when i type it out on a command line, it executes cleanly. Please help me in getting this right;
$ vlc -I dummy --sout='#transcode{vcodec=mp4v,... (5 Replies)
Hi friends,
I want to substitute "a ='....'," with ":" in everywhere in a string using Perl.
Details:
----------
my $str= " c1='fgfasfgasggfgff.,akhkhahha', c2='bbbn', c3='hg5 sh' ";
Required o/p: $str= " c1:c2:c3 "
I tried as below:
$str=~ s/=\'.*\',/:/g ;
print "str=... (14 Replies)
I downloaded vim.7.2 and compiled the vim source .
Added the vim binary path to PATH (Because iam not the root of the box)
when i load the file using vim it throws me an error
Error detected while processing /home2/e3003091/.vimrc:
line 2:
E185: Cannot find color scheme darkblue
line... (0 Replies)
I have a file with words that begin with character #. Whenver that character is found that word should be deleted throughout the file. How do I do that in VIM.
e.g:
afkajfa ladfa ljafa #222222 kjafad ljl
afajkj kjlj uouu #44444 jlkj lkjl
Output should be
afkajfa ladfa ljafa kjafad... (1 Reply)
Hello everyone ...
I'm going crazy, I hope some of you can help me ...
I have to replace a line in a crontab like this:
5 2 * * 2 root backupdat
with this:
5 5 * * 3 root backupdat
the command I use is the following:
sed -i.bak -e 's/5 2 * * 2 root backupdat/5 5 * * 3 root... (4 Replies)
Hi there,
I have a file that goes like this:
b_cdbc_db_cd_bcd_aaa-bcd_cd
That type of format, for many lines.
What I want to do is enter a new line character for after the _
I write an expression to find "_...-" fine, but I don't know how to substitute this to be:
"_\naaa-" - where... (1 Reply)
The intended result should be :
PDF converters
'empty line'
gpdftext and pdftotext?xml version="1.0"?>
xml:space="preserve"><note-content version="0.1" xmlns:/tomboy/link" xmlns:size="http://beatniksoftware.com/tomboy/size">PDF converters
gpdftext and pdftotext</note-content>... (9 Replies)
Greetings Experts,
I am on AIX and in process of creating a re-startable script that connects to Oracle and executes the statements. The sample contents of the file1 is
CREATE OR REPLACE VIEW DB_V.TAB1 AS SELECT * FROM DB_T.TAB1;
....
CREATE OR REPLACE VIEW DB_V.TAB10 AS SELECT * FROM... (9 Replies)
Discussion started by: chill3chee
9 Replies
LEARN ABOUT PHP
pg_field_size
PG_FIELD_SIZE(3)PG_FIELD_SIZE(3)pg_field_size - Returns the internal storage size of the named fieldSYNOPSIS
int pg_field_size (resource $result, int $field_number)
DESCRIPTION pg_field_size(3) returns the internal storage size (in bytes) of the field number in the given PostgreSQL $result.
Note
This function used to be called pg_fieldsize(3).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $field_number
- Field number, starting from 0.
RETURN VALUES
The internal field storage size (in bytes). -1 indicates a variable length field. FALSE is returned on error.
EXAMPLES
Example #1
Getting information about fields
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
$i = pg_num_fields($res);
for ($j = 0; $j < $i; $j++) {
echo "column $j
";
$fieldname = pg_field_name($res, $j);
echo "fieldname: $fieldname
";
echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters
";
echo "storage length: " . pg_field_size($res, $j) . " bytes
";
echo "field type: " . pg_field_type($res, $j) . "
";
}
?>
The above example will output:
column 0
fieldname: author
printed length: 6 characters
storage length: -1 bytes
field type: varchar
column 1
fieldname: year
printed length: 4 characters
storage length: 2 bytes
field type: int2
column 2
fieldname: title
printed length: 24 characters
storage length: -1 bytes
field type: varchar
SEE ALSO pg_field_prtlen(3), pg_field_type(3).
PHP Documentation Group PG_FIELD_SIZE(3)