09-13-2011
change value to negative
How to change value in column 5 to negative based on value in column 2 ?
Example: For all records with A in column 2 change value in column 5 to negative.
file
Code:
1234~A~b~c~10~e~f~g~h~09/10/09
1234~A~b~c~75~e~f~g~h~11/12/10
1234~A~b~c~40~e~f~g~h~12/06/10
5678~B~b~c~2~e~f~g~h~01/11/11
5678~B~b~c~6~e~f~g~h~03/28/13
8910~A~b~c~80~e~f~g~h~07/29/11
1023~B~b~c~15~e~f~g~h~10/22/09
1023~B~b~c~22~e~f~g~h~04/22/14
desired output
Code:
1234~A~b~c~-10~e~f~g~h~09/10/09
1234~A~b~c~-75~e~f~g~h~11/12/10
1234~A~b~c~-40~e~f~g~h~12/06/10
5678~B~b~c~2~e~f~g~h~01/11/11
5678~B~b~c~6~e~f~g~h~03/28/13
8910~A~b~c~-80~e~f~g~h~07/29/11
1023~B~b~c~15~e~f~g~h~10/22/09
1023~B~b~c~22~e~f~g~h~04/22/14
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi.
I want to know how can I negate a write permission for a file to an expecific user when that user have that permission becouse he belongs to a group what have a write permission for the file. (4 Replies)
Discussion started by: sickoboy
4 Replies
2. Programming
Function: int fcntl(int fd, int cmd, struct flock * lock)
Data Type: struct flock
This structure is used with the fcntl function to describe a file lock. It has these members:
off_t l_start
This specifies the offset of the start of the region to which the lock applies, and... (1 Reply)
Discussion started by: DNAx86
1 Replies
3. SCO
Hello.
I just installed a SCO Openserver 6 box and it's suckin' mud.
sar -v (see below) shows something that has me quite concerned... after time, it shows that the number of inodes being used as a negative value. When this happens, the server runs extremely slow until I reboot. The server... (0 Replies)
Discussion started by: debtman3535
0 Replies
4. Shell Programming and Scripting
I have a config file as below. This file is delimited by ; First field is the starting directory for find command. Second field is -mtime value for the find command. Third field is combination of folder and file delimited by |
/home/export/temp;+30;file1|dir1|file2... (3 Replies)
Discussion started by: cmoulee
3 Replies
5. Shell Programming and Scripting
I have read many tutorials and cannot get this to work. I need to use pcre (because that is what the library in the software we are using uses) and pcregrep everything except /home from the /etc/fstab
pcregrep '(?!/home)' /etc/fstab
It returns the entire fstab (This is on a RHEL5... (1 Reply)
Discussion started by: insania
1 Replies
6. Shell Programming and Scripting
Hi all,
I have a file that looks like shown below. I want to find places where the value in column 2 change from negative to positive and vice versa and return the value on column 1 at that point. I wonder if this is possible in shell script or awk .. please help!
Here is the original data
... (6 Replies)
Discussion started by: malandisa
6 Replies
7. UNIX for Dummies Questions & Answers
How to do Negative testing in Unix ??
Please reply asap.
Regards
Esha (0 Replies)
Discussion started by: eshalife
0 Replies
8. Shell Programming and Scripting
how can we do negative testing in unix ? (2 Replies)
Discussion started by: eshalife
2 Replies
9. Post Here to Contact Site Administrators and Moderators
Hi All,
I have received a notification that I have posted a question double times.
But I have not done all this intentionally. I have just joined this site and was not aware of the rules. Also I have my bits in negative.
what does that mean.
Thanks (1 Reply)
Discussion started by: Palak Sharma
1 Replies
LEARN ABOUT PHP
db2_field_precision