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 each of those files with 2 separate names to an SFTP server. I was trying something with an awk command, but I was told that using the split command might make this easier. Below is what I started with. Any help would be appreciated.
Last edited by RavinderSingh13; 05-01-2019 at 01:15 AM..
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)
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)
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)
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)
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)
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)
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... (2 Replies)
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)
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... (6 Replies)
Discussion started by: arunkumar_mca
6 Replies
LEARN ABOUT DEBIAN
aida2flat
AIDA2FLAT(1) User Commands AIDA2FLAT(1)NAME
aida2flat - Convert AIDA data files to a flat format
SYNOPSIS
aida2flat [options] aidafile [aidafile2 ...]
DESCRIPTION
Convert AIDA data files to a flat format which is more human-readable then the XML (and by default also plottable directly using
make-plots). The output is by default written out to standard output unless the --split, --smart-output, --gnuplot, or --output options are
specified. When specifying either input or output filenames, a '-' is used to refer to stdin or stdout as appropriate.
Histograms can also be filtered by AIDA path, using the -m or -M options for a positive or negative regex pattern patch respectively.
OPTIONS -h, --help
show this help message and exit
-o OUTPUT, --output=OUTPUT
Write all histos to a single output file, rather than the default writing to stdout. stdout can be explicitly specified by setting
'-' as the output filename. This option will be disregarded if --split, --smart-output, or --gnuplot is specified.
-s, --split
Write each histo to a separate output file, with names based on the histo path
-S, --smart-output
Write to output files with names based on the corresponding input filename. This option will be disregarded if --split is specified.
-g, --gnuplot
Provide output suitable for Gnuplot's 'plot "foo.dat" with xye'. This option implies --split and will override --output or
--smart-output
--plotinfodir=PLOTINFODIR
directory which may contain plot header information
-m PATHPATTERNS, --match=PATHPATTERNS
Only write out histograms whose $path/$name string matches these regexes
-M PATHUNPATTERNS, --unmatch=PATHUNPATTERNS
Exclude histograms whose $path/$name string matches these regexes
AUTHOR
This manual page was written by Lifeng Sun <lifongsun@gmail.com> for the Debian system (but may be used by others).
Rivet June 2012 AIDA2FLAT(1)