Replace period in a tab delimited file to a number
I have a file like this.
It is tab delimited.
Unfortunately, the missing data was filled in with a period "." (see the leading lines 1-5 columns)
I want to substitute the periods for misisng data with an integer "-999".
however, I do not want the global replace to change the other periods seen in the file.
for e.g, c.17_18del or p.P6fs should stay without change.
awk or sed preferred, but also willing to try other simple solutions.
Have only rudimentary bash programming skills.
Attached an example file.
Thanks
~ GH
Hi all,
I have a file with single white space delimited values, I want to convert them to a tab delimited file.
I tried sed, tr ... but nothing is working.
Thanks,
Rajeevan D (16 Replies)
I'm facing a strange problem, please help me out.
Here we go.
I want to count number of fields in particular file.
filename and delimiter character will be passed through parameter.
On command prompt if i type following i get 27 as output (which is correct)
cat customer.dat | head -1 | awk... (12 Replies)
Hi
I have two tab delimited file with different number of columns but same number of rows. I need to combine these two files in such a way that row 1 in file 2 comes adjacent to row 1 in file 1.
For example:
The content of file1:
field1 field2 field3
a1 a2 a3
b1 b2 b3... (2 Replies)
Hi Forum
I have a tab delimited file that opens well in Openoffice calc (excel). But when I perform any operation in command line, it reads the file incorrectly. When I 'save As' the same file in office as tab delimited then it works fine.
The file that I think is tab delimited is actually... (8 Replies)
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
Hi How to make tab delimited file to space delimited?
in put file:
ABC kgy
jkh ghj
ash kjl
o/p file:
ABC kgy
jkh ghj
ash kjl
Use code tags, thanks. (1 Reply)
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
Hi all,
I am fairly new to UNIX and I was wondering if you could provide me with some help! Lets say i have a file as below :
Line 1
Line 2
Line 3
ABC|12|4|2
Now the number 4 in bold, this number will represent the number of row there is in the file excluding the header and footer... (10 Replies)
Hello Everyone..
I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files
FileP.txt
... (2 Replies)
Discussion started by: YogeshG
2 Replies
LEARN ABOUT HPUX
annuityw
annuity(3M)annuity(3M)NAME
annuity(), annuityf(), annuityl(), annuityw(), annuityq() - present value factor for annuity
SYNOPSIS DESCRIPTION
The function computes the present value factor for an annuity:
(1 - (1 + rate) ** (-periods)) / rate
is a version of it takes arguments and returns a result.
is a version of it takes arguments and returns a result.
is an version of it takes arguments and returns an result.
is equivalent to on HP-UX systems.
USAGE
To use these functions, compile either with the default option or with the and options. To use compile with the option. Make sure your
program includes Link in the math library by specifying on the compiler or linker command line.
RETURN VALUE
If periods equals zero, returns 0.0.
Else, if rate equals zero, returns periods.
Else, if either argument is a NaN, returns a NaN.
Else, if rate < -1, returns a NaN and raises the invalid exception.
Else, if rate = -1 and periods = +INFINITY, returns +INFINITY.
Else, if rate equals -1 and periods > 0, is equivalent to
Else, if rate equals -1, returns -1.
Else, if rate equals +INFINITY and periods >= 0, returns +0.0.
Else, if rate equals +INFINITY and -1 < periods < 0, returns -0.0.
Else, if rate equals +INFINITY and periods = -1, returns -1.
Else, if rate equals +INFINITY, returns -INFINITY.
Else, if periods is infinite and (rate * periods) > 0, is equivalent to
Else, if periods is infinite, returns periods.
returns a properly signed infinity in lieu of a value whose magnitude is too large, and raises the overflow and inexact exceptions.
raises the underflow and inexact exceptions whenever a result is tiny (essentially denormal or zero) and thereby suffers loss of accuracy,
and may raise those exceptions if the result is merely tiny.
ERRORS
No errors are defined.
SEE ALSO compound(3M), exp(3M), expm1(3M), pow(3M), math(5).
STANDARDS CONFORMANCE
These functions are not specified by any standard.
HP Integrity Server Only annuity(3M)