i want a command for my script!!!
say file consists of character 123 125 127.
i need a query to replace the number 2 with 0
so the output should be 103 105 107.
i use unix-aix (8 Replies)
Hi All,
I have file contains the following information.
chem00s4.mis.amat.com ] Critical 3/21
chem00s4.mis.amat.com ] Normal 3/22
chem00s4.mis.amat.com ] Normal 3/23
chem00s4.mis.amat.com ] Normal 3/24
chem00s4.mis.amat.com ] Critical 3/25... (2 Replies)
Can someone help me to write a script / command to read in a file, character by character, replace any unknown ASCII characters with space. then write out the file to a new filename/
Thanks! (1 Reply)
Hi all,
Been trying to find a solution to this, I'm sure its a sed 1 liner, but I don't know sed well enough to work it out...
I have a text file in the following format:
431 666 1332 2665 0.24395
432 670 ... (3 Replies)
Greetings UNIX folks,
I am running a tcsh script and trying to replace the last character of a file with the number 0. I know that the last character of the file will always be 1, but I only want to replace the last character.
Example:
78062
26.55
78.77
1
MYGF1
24.89
15.78
1
... (2 Replies)
Something like vlookup in excel, column 2 in file 2 is blank and should be replaced by column 2 in file 1 based on comparing column 1 in both files.
file1
Code:
1234~abc~b~c~d~e~f~g~h~09/10/09
5678~def~b~c~d~e~f~g~h~12/06/10
8910~hij~b~c~d~e~f~g~h~03/28/13... (1 Reply)
Hi all,
I have 89 columns,1200 rows in a flat file, some of the values are just '.' (the character dot). I want to replace them by nothing (blank), but when I do so, it affects the decimal numbers too. so 12.34 becomes 1234.
How can I just replace values which are only '.' with 1 white... (13 Replies)
hi,
i need to replace a blank tab output in a file to zero.
input file:
2015/08/04 00:00:00 171 730579 27088 <blank> 3823 30273 1621778 ... (6 Replies)
Hi all,
i have a .csv file with only two columns, like:
Login;Status
Luca;S
Marco;
Stefano;
Elettra;S
Laura;
...
I need to replace the blank space on Status column whit Enabled end, on the same column, S whit Disabled, like:
Login;Status
Luca;Disabled
Marco;Enabled
Stefano;Enabled... (10 Replies)
Dear All,
In a CSV file, say that a given column has been extracted. In that column, information is missing (i.e. blank lines appear). I would like to replace the blank lines by the last valid line (not blank) previously read.
For example, consider the extract below:
123
234
543
111... (7 Replies)
Discussion started by: bagvian
7 Replies
LEARN ABOUT OSX
alter_tablespace
ALTER TABLESPACE(7) SQL Commands ALTER TABLESPACE(7)NAME
ALTER TABLESPACE - change the definition of a tablespace
SYNOPSIS
ALTER TABLESPACE name RENAME TO newname
ALTER TABLESPACE name OWNER TO newowner
DESCRIPTION
ALTER TABLESPACE changes the definition of a tablespace.
You must own the tablespace to use ALTER TABLESPACE. To alter the owner, you must also be a direct or indirect member of the new owning
role. (Note that superusers have these privileges automatically.)
PARAMETERS
name The name of an existing tablespace.
newname
The new name of the tablespace. The new name cannot begin with pg_, as such names are reserved for system tablespaces.
newowner
The new owner of the tablespace.
EXAMPLES
Rename tablespace index_space to fast_raid:
ALTER TABLESPACE index_space RENAME TO fast_raid;
Change the owner of tablespace index_space:
ALTER TABLESPACE index_space OWNER TO mary;
COMPATIBILITY
There is no ALTER TABLESPACE statement in the SQL standard.
SEE ALSO
CREATE TABLESPACE [create_tablespace(7)], DROP TABLESPACE [drop_tablespace(7)]
SQL - Language Statements 2010-05-14 ALTER TABLESPACE(7)