05-12-2009
simple awk/sed/tr question
I have a file
CREATE TABLE DDD_EXT --- 1000
(
val u1
val u1
);
CREATE TABLE dsdasd_EXT --- 1323
(
val u1
val u1
);
CREATE TABLE AAAAAA_EXT --- 1222
(
val u1
val u1
);
CREATE TABLE E_EXT --- 11
(
val u1
val u1
);
CREATE TABLE TRTERTRE_EXT --- 0
(
val u1
val u1
);
CREATE TABLE GRGY_EXT --- 0
(
val u1
val u1
);
CREATE TABLE RRRR_EXT --- 123
(
val u1
val u1
);
How can obtain the below output
insert into test_table values ( 'DDD' , NULL, 1000 );
insert into test_table values ( 'dsdasd, NULL, 1323);
insert into test_table values ( 'AAAAAA, NULL,1222 );
insert into test_table values ( 'E', NULL, 11);
insert into test_table values ( 'TRTERTRE, NULL, 0);
insert into test_table values ( 'GRGY, NULL, 0);
insert into test_table values ( 'RRRR, NULL, 123);
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Is there an easier way to do the following:
echo "|||||||" | sed 's/||/|0|/g; s/||/|0|/g'
which would give the following
|0|0|0|0|0|0|
If it is not run twice it will not pick up the second occurance of the || and leave it empty as in
echo "|||||||" | sed 's/||/|0|/g'
which would give... (3 Replies)
Discussion started by: maverick
3 Replies
2. Shell Programming and Scripting
Hello
My file looks like that =>
12.56 have then 7888778.2566 what 44454.54545
878787.66565 if else 4445.54545455
I want to change all '.' on ',' .
I'm trying to do it with sed but I don't know chow to build regular expression to
change 454.4466 on 454,4466 ? (13 Replies)
Discussion started by: scotty_123
13 Replies
3. Shell Programming and Scripting
hi
is it possible to cut this two semicolon separated sed commands
echo "string2 string3 string1" | sed s'/string1//g;s/string2//g'
output: " string3 "
to just one sed command without semicolon?
thanks in advance
funksen (10 Replies)
Discussion started by: funksen
10 Replies
4. UNIX for Dummies Questions & Answers
Hi ,
I have a simple question in awk, i have long string which i am getting for a grep command. the output contains 50 fields.
I need to display like first 5 fileds in a line and rest of all fields in the next line.
{ for(i=5;i<NF;++i) s= $i; print $1,$2,$3,$4,$5,"\n",$s}
Is the above... (1 Reply)
Discussion started by: senthilkumar_ak
1 Replies
5. Shell Programming and Scripting
How do I remove parentheses using sed?
input (192.168.1.1)
output 192.168.1.1 (4 Replies)
Discussion started by: streetfighter2
4 Replies
6. Shell Programming and Scripting
I have a log output with a format similar to this:
a=1, b= 2
c=0, d= 45, e=100
... and so on.
I figure I can just use awk or something to pipe the file to sed, but I'm trying to replace all the values above with 0.
I've tried:
cat blah | sed 's/=\(.*\),/0/'but that didn't work. ... (6 Replies)
Discussion started by: throw_a_stick
6 Replies
7. Shell Programming and Scripting
I have the following line an in input file I want to digest with sed and simple replace the bold part with a variable defined in my bash script. I can do this in several sed operations but I know there must be a way to do it in a single sed line. What is the syntax?
Line in file:... (1 Reply)
Discussion started by: graysky
1 Replies
8. Shell Programming and Scripting
Script newbie, so I'm sure I'm missing something obvious here, but how come this simple script does not work?
#!/bin/bash ... (3 Replies)
Discussion started by: KidCactus
3 Replies
9. Shell Programming and Scripting
I have what a think is a simple question but I'm just a beginner in scripting. I'm my unix command line I run a date command that returns the following:
Wed Apr 3 10:39:30 EDT 2013
How do I awk out the "10" only in awk? Or is awk the way to do it or is there a better way? (7 Replies)
Discussion started by: scj2012
7 Replies
10. UNIX for Beginners Questions & Answers
I don't understand this command behavior.
echo "abc" |sed 's/a/&_&/' (4 Replies)
Discussion started by: Vartika18
4 Replies
LEARN ABOUT SUSE
create_domain
CREATE
DOMAIN(7) SQL Commands CREATE DOMAIN(7)
NAME
CREATE DOMAIN - define a new domain
SYNOPSIS
CREATE DOMAIN name [ AS ] data_type
[ DEFAULT expression ]
[ constraint [ ... ] ]
where constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | CHECK (expression) }
DESCRIPTION
CREATE DOMAIN creates a new domain. A domain is essentially a data type with optional constraints (restrictions on the allowed set of val-
ues). The user who defines a domain becomes its owner.
If a schema name is given (for example, CREATE DOMAIN myschema.mydomain ...) then the domain is created in the specified schema. Otherwise
it is created in the current schema. The domain name must be unique among the types and domains existing in its schema.
Domains are useful for abstracting common constraints on fields into a single location for maintenance. For example, several tables might
contain email address columns, all requiring the same CHECK constraint to verify the address syntax. Define a domain rather than setting
up each table's constraint individually.
PARAMETERS
name The name (optionally schema-qualified) of a domain to be created.
data_type
The underlying data type of the domain. This can include array specifiers.
DEFAULT expression
The DEFAULT clause specifies a default value for columns of the domain data type. The value is any variable-free expression (but
subqueries are not allowed). The data type of the default expression must match the data type of the domain. If no default value is
specified, then the default value is the null value.
The default expression will be used in any insert operation that does not specify a value for the column. If a default value is
defined for a particular column, it overrides any default associated with the domain. In turn, the domain default overrides any
default value associated with the underlying data type.
CONSTRAINT constraint_name
An optional name for a constraint. If not specified, the system generates a name.
NOT NULL
Values of this domain are not allowed to be null.
NULL Values of this domain are allowed to be null. This is the default.
This clause is only intended for compatibility with nonstandard SQL databases. Its use is discouraged in new applications.
CHECK (expression)
CHECK clauses specify integrity constraints or tests which values of the domain must satisfy. Each constraint must be an expression
producing a Boolean result. It should use the key word VALUE to refer to the value being tested.
Currently, CHECK expressions cannot contain subqueries nor refer to variables other than VALUE.
EXAMPLES
This example creates the us_postal_code data type and then uses the type in a table definition. A regular expression test is used to verify
that the value looks like a valid US postal code:
CREATE DOMAIN us_postal_code AS TEXT
CHECK(
VALUE ~ '^\d{5}$'
OR VALUE ~ '^\d{5}-\d{4}$'
);
CREATE TABLE us_snail_addy (
address_id SERIAL PRIMARY KEY,
street1 TEXT NOT NULL,
street2 TEXT,
street3 TEXT,
city TEXT NOT NULL,
postal us_postal_code NOT NULL
);
COMPATIBILITY
The command CREATE DOMAIN conforms to the SQL standard.
SEE ALSO
ALTER DOMAIN [alter_domain(7)], DROP DOMAIN [drop_domain(7)]
SQL - Language Statements 2010-05-14 CREATE DOMAIN(7)