I am trying to process file which has following data
#23456789012345
ACNASPSA13N0N0
ACNAPCPA05N0N0
ACNAFATS11N0N0
I want to take out each line from the file and what to put in the file by name which if part of the line starting from offset 10 to 15. It means I want to create three file... (3 Replies)
I have a 3-column data file, for which I wish to print certain parts of $3
PHI PSI A(x)
-177.5 -177.5 1.0625
-177.5 -172.5 0.55
-177.5 -167.5 0.0478125
-177.5 -162.5 0
-177.5 -157.5 0.284375
-177.5 -152.5 0.187188
-177.5 -147.5 0.236875
-177.5 -142.5 0.383438
-177.5 ... (3 Replies)
Input File:
1234, 2345,abc
1,24141,gw
222,rff,sds
2232145,sdsd,121
Output file to be generated:
000001234,2345,abc
000000001,24141,gw
000000222,rff,sds
002232145,sdsd,121
i.e; the first column is padded to get 9 digits.
I tried with following: (1 Reply)
Input File:
1234, 2345,abc
1,24141,gw
222,rff,sds
2232145,sdsd,121
Output file to be generated:
000001234,2345,abc
000000001,24141,gw
000000222,rff,sds
002232145,sdsd,121
i.e; the first column is padded to get 9 digits.
I tried with following: (3 Replies)
Hello ,
I have comma delimited file with over 20 fileds that i need to do some validations on. I have to check if certain fields are null and then write the line containing the null field into a new file and then delete the line from the current file.
Can someone tell me how i could go... (2 Replies)
Hello,
I extracted a list of files in a directory with the command ls . However this is not my computer, so the ls functionality has been revamped so that it gives the filesizes in front like this :
This is the output of ls command : I stored the output in a file filelist
1.1M... (5 Replies)
Need to use dd to generate a large file from a sample file of random data. This is because I don't have /dev/urandom.
I create a named pipe then:
dd if=mynamed.fifo do=myfile.fifo bs=1024 count=1024
but when I cat a file to the fifo that's 1024 random bytes:
cat randomfile.txt >... (7 Replies)
I have one input file ABC.txt and one output DEF.txt. After the ABC is processed and created output, I want to rename ABC.txt to ABC.orig and DEF to ABC.txt. Currently when I am doing this, it does not process the input file as it cannot read and write to the same file. How can I achieve this?
... (12 Replies)
hello All, I'm new to AWK programming and learned myself few things to process a file and deal with duplicate lines, but I got into a scenario which makes me clueless to handle. Here is the scenario..
Input file:
user role
----- ----
AAA add
AAA delete
BBB delete
CCC delete
DDD ... (10 Replies)
Hi - I want to interrogate information about my poker hands, sessions are all recorded in a text file in a particular format. Each hand starts with the string <PokerStars> followed by a unique hand reference and other data like date/time. There is then all the information about each hand. My first... (5 Replies)
Discussion started by: rbeech23
5 Replies
LEARN ABOUT CENTOS
alter_trigger
ALTER TRIGGER(7) PostgreSQL 9.2.7 Documentation ALTER TRIGGER(7)NAME
ALTER_TRIGGER - change the definition of a trigger
SYNOPSIS
ALTER TRIGGER name ON table_name RENAME TO new_name
DESCRIPTION
ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing
the trigger definition.
You must own the table on which the trigger acts to be allowed to change its properties.
PARAMETERS
name
The name of an existing trigger to alter.
table_name
The name of the table on which this trigger acts.
new_name
The new name for the trigger.
NOTES
The ability to temporarily enable or disable a trigger is provided by ALTER TABLE (ALTER_TABLE(7)), not by ALTER TRIGGER, because ALTER
TRIGGER has no convenient way to express the option of enabling or disabling all of a table's triggers at once.
EXAMPLES
To rename an existing trigger:
ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs;
COMPATIBILITY
ALTER TRIGGER is a PostgreSQL extension of the SQL standard.
SEE ALSO
ALTER TABLE (ALTER_TABLE(7))
PostgreSQL 9.2.7 2014-02-17 ALTER TRIGGER(7)