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 BSD
fsplit
FSPLIT(1) General Commands Manual FSPLIT(1)NAME
fsplit - split a multi-routine Fortran file into individual files
SYNOPSIS
fsplit [ -e efile] ... [ file ]
DESCRIPTION
Fsplit takes as input either a file or standard input containing Fortran source code. It attempts to split the input into separate routine
files of the form name.f, where name is the name of the program unit (e.g. function, subroutine, block data or program). The name for
unnamed block data subprograms has the form blkdtaNNN.f where NNN is three digits and a file of this name does not already exist. For
unnamed main programs the name has the form mainNNN.f. If there is an error in classifying a program unit, or if name.f already exists,
the program unit will be put in a file of the form zzzNNN.f where zzzNNN.f does not already exist.
Normally each subprogram unit is split into a separate file. When the -e option is used, only the specified subprogram units are split
into separate files. E.g.:
fsplit -e readit -e doit prog.f
will split readit and doit into separate files.
DIAGNOSTICS
If names specified via the -e option are not found, a diagnostic is written to standard error.
AUTHOR
Asa Romberger and Jerry Berkman
BUGS
Fsplit assumes the subprogram name is on the first noncomment line of the subprogram unit. Nonstandard source formats may confuse fsplit.
It is hard to use -e for unnamed main programs and block data subprograms since you must predict the created file name.
4.2 Berkeley Distribution April 29, 1985 FSPLIT(1)