Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Converting negative number to positive in a file Post 303014988 by arunkumar_mca on Sunday 25th of March 2018 08:51:48 AM
Old 03-25-2018
Converting negative number to positive in a file

Hi ALL,

I am having semi column separated file as below. I am having negative values for the records starting with 11095. How can I convert that positive number

I tried this below seems not working

Code:
sed 's/ \([0-9.]*\)$/ -\1/;t;s/\(.*\)-/\1/ myfile

Code:
myfile
18223;15402;292;;;;;;;13360.18;;;;;;;;;;;;;;;;;;;;;;;;;;
18223;15404;292;;;;;;;537250.91;;;;;;;;;;;;;;;;;;;;;;;;;;
18223;15405;292;;;;;;;3907337.18;;;;;;;;;;;;;;;;;;;;;;;;;;
11095;15280;292;;;;;;;-3180799.65;;;;;;;;;;;;;;;;;;;;;;;;;;
11095;15280;292;;;;;;;-6.99;;;;;;;;;;;;;;;;;;;;;;;;;;
11095;15281;292;;;;;;;-2849107.45;;;;;;;;;;;;;;;;;;;;;;;;;;
11095;15281;292;;;;;;;-6548.14;;;;;;;;;;;;;;;;;;;;;;;;;;
11095;15282;292;;;;;;;-27638.72;;;;;;;;;;;;;;;;;;;;;;;;;;
11095;15282;292;;;;;;;-32744579.66;;;;;;;;;;;;;;;;;;;;;;;;;;
11095;15405;292;;;;;;;-55763720.12;;;;;;;;;;;;;;;;;;;;;;;;;;
99822;15280;292;;;;;;;8672148.20;;;;;;;;;;;;;;;;;;;;;;;;;;
99822;15281;292;;;;;;;252847.13;;;;;;;;;;;;;;;;;;;;;;;;;;
99822;15282;292;;;;;;;39879533.02;;;;;;;;;;;;;;;;;;;;;;;;;;
99822;15283;292;;;;;;;4690420.03;;;;;;;;;;;;;;;;;;;;;;;;;;
99822;15284;292;;;;;;;992923.68;;;;;;;;;;;;;;;;;;;;;;;;;;


Last edited by arunkumar_mca; 03-25-2018 at 09:57 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help in adding positive & negative values in a column

Hi Gurus, In my file I have an amount field from position 74 to 87, which contains values starting with '+' as well as '-'. I want to add all positive values in a varible called "CREDIT" and all negative values in a variable "DEBIT". I know, we can use grep to identify values with positive and... (4 Replies)
Discussion started by: berlin_germany
4 Replies

2. Shell Programming and Scripting

Perl output with negative and positive numbers

Hello, For my weather station I have made a little perl script to put the data into cacti. The next problem I have. I can only get positive numbers or negative numbers. What do I do: Though a shell scrip I call the perl script. Shell script: #!/bin/sh cat data.txt | stats.pl Perl... (4 Replies)
Discussion started by: rbl-blacklight
4 Replies

3. Shell Programming and Scripting

Finding the most positive and negative value and defining its position

Hi, I have a file that looks like this: Jake 2 3 4 6 4 3 -2 -1 Jerry 1 2 3 2 1 7 -6 -1 Timmy -1 -4 -5 -8 9 3 1 I want to find the most positive and negative value for each row and also define its position (based on column #) So the output would look... (7 Replies)
Discussion started by: gisele_l
7 Replies

4. Shell Programming and Scripting

Sorting positive and negative values

Hello, I have a list like this : 1 2 -4 0 -3 -7 5 6 etc. Is there a way to remove all the positive values and print only the negative values, without using grep, sed or awk? Thanks, Prasanna (4 Replies)
Discussion started by: prasanna1157
4 Replies

5. Shell Programming and Scripting

addition of both positive and negative numbers

Let, I have three numbers +00123.25 -00256.54 +00489.23 I need to sum up all those three numbers, after storing them in three variables (say var1, var2, var3). I used both expr and BC, but they didn't work for me. But, I am not able to sum up them, as I don't have any idea how to... (13 Replies)
Discussion started by: mady135
13 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. Shell Programming and Scripting

Taking largest (negative) number from column of coordinates and adding positive form to every other

Hello all, I'm new to the forums and hope to be able to contribute something useful in the future; however I must admit that what has prompted me to join is the fact that currently I need help with something that has me at the end of my tether. I have a PDB (Protein Data Bank) file which I... (13 Replies)
Discussion started by: crunchgargoyle
13 Replies

8. Shell Programming and Scripting

Splitting a file based on positive and negative numbers

Dear All, I have to split a tab delimited file in two files based on the presence of a positive or negative in column number 9 , for example file: A 1 5 erg + 6766 0.9889 0.9817 9.01882 erg inside upstream B 1 8 erg2 + 6766 0.9889 0.9817 -9.22 erg2 inside... (3 Replies)
Discussion started by: paolo.kunder
3 Replies

9. UNIX for Beginners Questions & Answers

Splitting a file based on negative and positive numbers

I have a file that is pipe delimited and in Column F they have number values, both positive and negative. I need to take the one file I am starting with and split it into two separate files based on negative and positive numbers. What is the command to do so? And then I need to also transfer... (4 Replies)
Discussion started by: cckaiser15
4 Replies
__gnu_cxx::slist< _Tp, _Alloc >(3)			     Library Functions Manual				__gnu_cxx::slist< _Tp, _Alloc >(3)

NAME
__gnu_cxx::slist< _Tp, _Alloc > - SYNOPSIS
Inherits __gnu_cxx::_Slist_base< _Tp, _Alloc >. Public Types typedef _Base::allocator_type allocator_type typedef _Slist_iterator< _Tp, const _Tp &, const _Tp * > const_iterator" typedef const value_type * const_pointer typedef const value_type & const_reference typedef ptrdiff_t difference_type typedef _Slist_iterator< _Tp, _Tp &, _Tp * > iterator" typedef value_type * pointer typedef value_type & reference typedef size_t size_type typedef _Tp value_type Public Member Functions template<class _Integer > void _M_assign_dispatch (_Integer __n, _Integer __val, __true_type) template<class _InputIterator > void _M_assign_dispatch (_InputIterator __first, _InputIterator __last, __false_type) void _M_fill_assign (size_type __n, const _Tp &__val) void assign (size_type __n, const _Tp &__val) template<class _InputIterator > void assign (_InputIterator __first, _InputIterator __last) iterator before_begin () const_iterator before_begin () const iterator begin () const_iterator begin () const void clear () bool empty () const iterator end () const_iterator end () const iterator erase (iterator __pos) iterator erase (iterator __first, iterator __last) iterator erase_after (iterator __pos) iterator erase_after (iterator __before_first, iterator __last) reference front () const_reference front () const allocator_type get_allocator () const iterator insert (iterator __pos, const value_type &__x) iterator insert (iterator __pos) void insert (iterator __pos, size_type __n, const value_type &__x) template<class _InIterator > void insert (iterator __pos, _InIterator __first, _InIterator __last) iterator insert_after (iterator __pos, const value_type &__x) iterator insert_after (iterator __pos) void insert_after (iterator __pos, size_type __n, const value_type &__x) template<class _InIterator > void insert_after (iterator __pos, _InIterator __first, _InIterator __last) size_type max_size () const void merge (slist &__x) template<class _StrictWeakOrdering > void merge (slist &, _StrictWeakOrdering) void pop_front () iterator previous (const_iterator __pos) const_iterator previous (const_iterator __pos) const void push_front (const value_type &__x) void push_front () void remove (const _Tp &__val) template<class _Predicate > void remove_if (_Predicate __pred) void resize (size_type new_size, const _Tp &__x) void resize (size_type new_size) void reverse () size_type size () const void sort () template<class _StrictWeakOrdering > void sort (_StrictWeakOrdering __comp) void splice (iterator __pos, slist &__x) void splice (iterator __pos, slist &__x, iterator __i) void splice (iterator __pos, slist &__x, iterator __first, iterator __last) void splice_after (iterator __pos, iterator __before_first, iterator __before_last) void splice_after (iterator __pos, iterator __prev) void splice_after (iterator __pos, slist &__x) void swap (slist &__x) void unique () template<class _BinaryPredicate > void unique (_BinaryPredicate __pred) Public Attributes const value_type const allocator_type & __a" __pad0__: _Base(__a) {} slist(size_type __n const value_type & __x Private Types typedef _Alloc::template rebind< _Slist_node< _Tp > >::other _Node_alloc" Private Member Functions _Slist_node_base * _M_erase_after (_Slist_node_base *__pos) _Slist_node_base * _M_erase_after (_Slist_node_base *, _Slist_node_base *) _Slist_node< _Tp > * _M_get_node () void _M_put_node (_Slist_node< _Tp > *__p) Private Attributes _Slist_node_base _M_head Detailed Description template<class _Tp, class _Alloc = allocator<_Tp>>class __gnu_cxx::slist< _Tp, _Alloc > This is an SGI extension. Todo Needs documentation! See http://gcc.gnu.org/onlinedocs/libstdc++/manual/documentation_style.html Definition at line 292 of file slist. Author Generated automatically by Doxygen for libstdc++ from the source code. libstdc++ Tue Jun 10 2014 __gnu_cxx::slist< _Tp, _Alloc >(3)
All times are GMT -4. The time now is 07:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy