Sponsored Content
Full Discussion: change value to negative
Top Forums Shell Programming and Scripting change value to negative Post 302555042 by birei on Tuesday 13th of September 2011 05:12:22 PM
Old 09-13-2011
Hi,

Using Perl:
Code:
$ cat infile
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
$ perl -F"~" -lane 'printf "%s\n", join "~", @F[0..3], $F[1] eq "A" ? $F[4]*-1 : $F[4], @F[5..$#F]' infile 
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

Regards,
Birei
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

negative permissions

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

Negative Offset

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

Help with negative inodes on sco 6

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

find negative search

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

PCRE negative lookahead

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

Find Where Values Change From Positive To Negative and viceversa

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

Negative testing in Unix

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

Negative testing in unix

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

Bits in Negative

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
COLRM(1)						    BSD General Commands Manual 						  COLRM(1)

NAME
colrm -- remove columns from a file SYNOPSIS
colrm [start [stop]] DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read from the standard input. Output is written to the standard output. If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec- ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not zero. Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one. ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7). EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs. SEE ALSO
awk(1), column(1), cut(1), paste(1) HISTORY
The colrm command appeared in 3.0BSD. BSD
August 4, 2004 BSD
All times are GMT -4. The time now is 03:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy