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 SUSE
alter_group
ALTER GROUP(7) SQL Commands ALTER GROUP(7)NAME
ALTER GROUP - change role name or membership
SYNOPSIS
ALTER GROUP groupname ADD USER username [, ... ]
ALTER GROUP groupname DROP USER username [, ... ]
ALTER GROUP groupname RENAME TO newname
DESCRIPTION
ALTER GROUP changes the attributes of a user group. This is an obsolete command, though still accepted for backwards compatibility,
because groups (and users too) have been superseded by the more general concept of roles.
The first two variants add users to a group or remove them from a group. (Any role can play the part of either a ``user'' or a ``group''
for this purpose.) These variants are effectively equivalent to granting or revoking membership in the role named as the ``group''; so the
preferred way to do this is to use GRANT [grant(7)] or REVOKE [revoke(7)].
The third variant changes the name of the group. This is exactly equivalent to renaming the role with ALTER ROLE [alter_role(7)].
PARAMETERS
groupname
The name of the group (role) to modify.
username
Users (roles) that are to be added to or removed from the group. The users must already exist; ALTER GROUP does not create or drop
users.
newname
The new name of the group.
EXAMPLES
Add users to a group:
ALTER GROUP staff ADD USER karl, john;
Remove a user from a group:
ALTER GROUP workers DROP USER beth;
COMPATIBILITY
There is no ALTER GROUP statement in the SQL standard.
SEE ALSO
GRANT [grant(7)], REVOKE [revoke(7)], ALTER ROLE [alter_role(7)]
SQL - Language Statements 2010-05-14 ALTER GROUP(7)