Hi All,
I have 5000 records like this
Request_id|Type|Status|Priority|Ticket Submitted Date and Time|Actual Resolved Date and Time|Current Ticket Owner Group|Case final Ticket Owner Group|Customer Severity|Reported Symptom/Request|Component|Hot Topic|Reason for Missed SLA|Current Ticket... (2 Replies)
Hi,
I have input file contains sql queries i need to eliminate newlines from it.
when i open it vi text editor and runs
:%s/'\n/'/g
it provides required result. but when i run sed command from shell prompt it doesn't impact outfile is still same as inputfile.
shell] sed -e... (6 Replies)
I have a file (test.dat) which contains data like this
459|199811047|a |b |shan
kar|ooty|
460|199811047|a |bv |gur
u|cbe|
but I need it like:
459|199811047|a |b |shankar|ooty|
460|199811047|a |b |guru|cbe|
While reading the data from this file, I don't want to remove newline from the end of... (4 Replies)
In my file, i have 4 Product names(For ex:Microsoft excel, Oracle,.Net,IBM websphere,..etc.,) I want this 4 Products in 4 individual .csv/excel file after running the script with those products related information. (12 Replies)
hi i am having delimited .dat file having content like below.
test.dat(5 line of records)
======
PT2~Stag~Pt2 Stag Test.
Updated~PT2 S T~Area~~UNCEF R20~~2012-05-24 ~2014-05-24~~
PT2~Stag y~Pt2 Stag Test.
Updated~PT2 S T~Area~METR~~~2012-05-24~2014-05-24~~test
PT2~Pt2 Stag Test~~PT2 S... (4 Replies)
my file input is with tab as delimiter, and in every line, there would be a skip of line with an unexcepted newline breaker. I'd like to remove this \n and put the information in the same line.
INPUT
a1 b1b2 c1
c2 d1
a2 b3 c3 d4
OUTPUT
a1 b1b2 c1c2 ... (9 Replies)
Hi all..
I have a text file which looks like below:
abcd
efgh
ijkl
(blank space)
I need to remove only the last (blank space) from the file. When I try wc -l the file name,the number of lines coming is 3 only, however blank space is there in the file.
I have tried options like... (14 Replies)
Hi All,
Need help in identifying a shellscript command to remove all files on a server directory, starting with a certain prefix and also older than 3 days.
That means files created with that prefix, today or yesterday, shouldn't be removed.
Thanks,
Dev (3 Replies)
Discussion started by: dev.devil.1983
3 Replies
LEARN ABOUT DEBIAN
alzabo::postgresql
Alzabo::PostgreSQL(3pm) User Contributed Perl Documentation Alzabo::PostgreSQL(3pm)NAME
Alzabo::PostgreSQL - Alzabo and PostgreSQL
DESCRIPTION
This documentation is about what special support Alzabo has for PostgreSQL, as well as what is lacking.
Postgres support is based on the 7.3.x version of Postgres. Alzabo should work with the 7.1 and 7.2 series, and may even work with the 7.0
series.
Mixed-case Table or Column Names
By default, Postgres treats table and column names case-insensitively. Because of this, Alzabo always quotes these names when generating
DDL SQL. If you are using tables or columns that contain upper-case characters, you should always call "$schema->set_quote_identifiers(1)"
as soon as you load your schema object. Otherwise, any method which generates DML SQL will fail.
Reverse Engineering
o Alzabo cannot determine from the existence of a sequence that the sequence is meant to be used for a particular column unless the
sequence was created as a result of making a column's type SERIAL.
This is because there is no link between the two in the Postgres' data dictionary tables and will probably never change.
Transactions
o Transactions are fully supported with Postgres.
Outer joins
o Left and right outer joins are supported.
o Full outer joins are not supported.
Constraints
Column constraints can be specified as column attributes. Table constraints can be specified as table attributes.
Foreign key constraints are generated automatically based on the relationships defined by your schema.
perl v5.8.8 2007-12-23 Alzabo::PostgreSQL(3pm)