Hi,
I have a input file with following contents
---------------------------------------------------------Run Number: 1-----------------------------------------------------------
test_run -layout test_vaal -i |Started|05/28/2007 02:19:30|TEST|8651... (2 Replies)
My script is throwing the error 'Syntax error: redirection unexpected'
My line of code..
cat nsstatustest.html | sed s/<tr><td align="left">/<tr><td align="left" bgcolor="#000000"><font color="white">/ > ztmp.Ps23zp2s.2-Fpps3-wmmm0dss3
HTML tags are getting in the way but they're needed to... (3 Replies)
hi guys!!
I am new to shell script..
here is what i want do, i want to search original string in export.txt file which is:
export mib =/opt/old_mib/
i want to replace it by
export mibs =/opt/new_mibs/
i tried
sed -e 's/export mib =/opt/old_mib//export mibs =/opt/new_mibs//g'
... (4 Replies)
Hi Leute
Kann mir bitte jemand diesen Fehler rerklären?
Ohne Zuweisung gehts und es kommt der modifizierte String raus.
Weise ich es einem String zu kommt dieser Fehler.
Was mache ich da flasch?
0:521:root@pendrive /media/disk/system_setup # STRING=/mnt/new/path
0:522:root@pendrive... (3 Replies)
Hello,
I want to remove .txt from every file name:
for file in *.txt; des=$(echo $file | sed 's/\.txt//'); mv "$file" "$des"; done
but this gives me:
bash: syntax error near unexpected token `des=$(echo $file | sed 's/\.txt//')'
I understand that there's other ways of doing this... (1 Reply)
Hi,
I am trying to write an SED script to extract some strings from each line of a file and print it into another file.
The sample input looks like this.
AVE_LOC_ADDED <= 1.1429: 0 (28035.0/53.0) <IG:0.09933947301390625; GR:0.21494375103088412; WeightedGR:6679.592007035755>... (4 Replies)
Hi,
I'm trying to go through a file and replace in each word (separated by new lines if it matters) the first occurrence of a vowel with #.
works, but of course it replaces all vowels.
However, removing the /g produces an error that says:
Can anyone help?? (1 Reply)
Hello All,
I have something like below
LDC100/rel/prod/libinactrl.a
LAA2000/rel/prod/libinactrl.a
I want to remove till first forward slash that is outputshould be as below
rel/prod/libinactrl.a
rel/prod/libinactrl.a
How can I do that ??? (8 Replies)
I am using this command:
sed 's///g' file1
I want to keep only Arabic Characters and remove all others. I get this error:
sed: -e expression #1, char 17: Invalid collation character (3 Replies)
Hi,
I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :-
./sample.sh: line... (12 Replies)
Discussion started by: satishmallidi
12 Replies
LEARN ABOUT REDHAT
select_into
SELECT INTO(7) SQL Commands SELECT INTO(7)NAME
SELECT INTO - create a new table from the results of a query
SYNOPSIS
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ AS output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start ]
[ FOR UPDATE [ OF tablename [, ...] ] ]
INPUTS
TEMPORARY
TEMP If specified, the table is created as a temporary table. Refer to CREATE TABLE [create_table(7)] for details.
new_table
The name (optionally schema-qualified) of the table to be created.
All other inputs are described in detail for SELECT [select(7)].
OUTPUTS
Refer to CREATE TABLE [create_table(7)] and SELECT [select(7)] for a summary of possible output messages.
DESCRIPTION
SELECT INTO creates a new table and fills it with data computed by a query. The data is not returned to the client, as it is with a normal
SELECT. The new table's columns have the names and data types associated with the output columns of the SELECT.
Note: CREATE TABLE AS [create_table_as(7)] is functionally equivalent to SELECT INTO. CREATE TABLE AS is the recommended syntax,
since SELECT INTO is not standard. In fact, this form of SELECT INTO is not available in PL/pgSQL or ecpg(1), because they interpret
the INTO clause differently.
COMPATIBILITY
SQL92 uses SELECT ... INTO to represent selecting values into scalar variables of a host program, rather than creating a new table. This
indeed is the usage found in PL/pgSQL and ecpg(1). The PostgreSQL usage of SELECT INTO to represent table creation is historical. It's
best to use CREATE TABLE AS for this purpose in new code. (CREATE TABLE AS isn't standard either, but it's less likely to cause confu-
sion.)
SQL - Language Statements 2002-11-22 SELECT INTO(7)