Splitting a file based on negative and positive numbers Post: 303034642

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...

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...

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...

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

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...

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 ...

7. Shell Programming and Scripting

Splitting file based on line numbers

Hello friends, Is there any way to split file from n to n+6 into 1 file and (n+7) to (n+16) into other file etc. f.e I have source pipe delimated file with 20 lines and i need to split 1-6 in file1 and 7-16 in file2 and 17-20 in file 3 I need to split into fixed number of file like 4 files...

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...

9. UNIX for Beginners Questions & Answers

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 sed 's/ $*$$/ -\1/;t;s/$.*$-/\1/ myfile myfile...

LEARN ABOUT LINUX

csplit

CSPLIT(1)							   User Commands							 CSPLIT(1)

NAME

       csplit - split a file into sections determined by context lines

SYNOPSIS

       csplit [OPTION]... FILE PATTERN...

DESCRIPTION

       Output pieces of FILE separated by PATTERN(s) to files `xx00', `xx01', ..., and output byte counts of each piece to standard output.

       Mandatory arguments to long options are mandatory for short options too.

       -b, --suffix-format=FORMAT
	      use sprintf FORMAT instead of %02d

       -f, --prefix=PREFIX
	      use PREFIX instead of `xx'

       -k, --keep-files
	      do not remove output files on errors

       -n, --digits=DIGITS
	      use specified number of digits instead of 2

       -s, --quiet, --silent
	      do not print counts of output file sizes

       -z, --elide-empty-files
	      remove empty output files

       --help display this help and exit

       --version
	      output version information and exit

       Read standard input if FILE is -.  Each PATTERN may be:

       INTEGER
	      copy up to but not including specified line number

       /REGEXP/[OFFSET]
	      copy up to but not including a matching line

       %REGEXP%[OFFSET]
	      skip to, but not including a matching line

       {INTEGER}
	      repeat the previous pattern specified number of times

       {*}    repeat the previous pattern as many times as possible

       A line OFFSET is a required `+' or `-' followed by a positive integer.

AUTHOR

       Written by Stuart Kemp and David MacKenzie.

REPORTING BUGS

       Report csplit bugs to bug-coreutils@gnu.org
       GNU coreutils home page: <http://www.gnu.org/software/coreutils/>
       General help using GNU software: <http://www.gnu.org/gethelp/>
       Report csplit translation bugs to <http://translationproject.org/team/>

COPYRIGHT

       Copyright (C) 2010 Free Software Foundation, Inc.  License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
       This is free software: you are free to change and redistribute it.  There is NO WARRANTY, to the extent permitted by law.

SEE ALSO

       The  full documentation for csplit is maintained as a Texinfo manual.  If the info and csplit programs are properly installed at your site,
       the command

	      info coreutils 'csplit invocation'

       should give you access to the complete manual.

GNU coreutils 8.5						   February 2011							 CSPLIT(1)