Hello all, I have a list of reports for stores that are numbered like:
s001845,s000022,s198490,s020048,s002385
however the users are displaying the reports as:
1845,22,198490,20048,2385
It isn't real critical but I would like to associate them so they are the same. And since the users are... (2 Replies)
Hi all,
Can anybody help me out to write a program in perl to remove O and preceeding zeros.
for eg input is O0000123089 - output 123089
Thanks
Mahalakshmi.A (10 Replies)
Hi I have a simple request but can't find the answer. I want to remove trailing zeros, and in some cases the fullstops, from the input data. Example of input file:
FR002_15.000_20.000
SD475_5.000_10.500
FG5647_12.250_15.500
BH2463_30.555_32.000
Desired output file would be:
... (10 Replies)
Hi All,
I am using a informatica job to create a csv file and a unix script the mail the generated file.Everything is working fine but I am not seeing leading zeros in the csv file sent in the mail.These zeros were present when the .csv file was generated by informatica procees.
Is there any... (11 Replies)
I have a below file and I wanted to remove the leading zeros in each field separated by pipe
File:
01/09/2017|2017/09/06|2017/02/06|02/06/2017|02/06/2017 06:50:06 AM|2017/02/06|02/06/2017|02/07/2017 05:45:06 AM|
02/08/2017|2017/08/06|2017/09/06|02/05/2017|02/07/2017 05:40:06... (4 Replies)
Hi,
I am trying to remove trailing zeros from numbers in a csv file.
CSV Input : 0.5000,abc,2.00,2.400,285.850,285a.850,205.180800,mno000,a0b0,2.860
Expected Output :
.5,abc,2,2.4,285.85,285a.850,205.1808,mno000,a0b0,2.86
Can you please help.
Thanks. (11 Replies)
Discussion started by: manubatham20
11 Replies
LEARN ABOUT HPUX
strtoumax
strtoimax(3C)strtoimax(3C)NAME
strtoimax(), strtoumax() - convert string to integer
SYNOPSIS DESCRIPTION
or converts the character string pointed to by str to or representation, respectively. The string is scanned up to the first character
inconsistent with the base. Leading ``white-space'' characters (as defined by in ctype(3C)) are ignored. If no conversion can take place,
zero is returned.
If base is greater than or equal to 2 and less than or equal to 36, it is used as the base for conversion. After an optional leading sign,
leading zeros are ignored, and or is ignored if base is 16.
If base is zero, the string itself determines the base as follows: after an optional leading sign, a leading zero indicates octal conver-
sion; a leading or indicates hexadecimal conversion. Otherwise, decimal conversion is used.
If the value of ptr is not a pointer to the character terminating the scan is returned in the location pointed to by ptr. If no integer
can be formed, the location pointed to by ptr is set to str, and zero is returned.
RETURN VALUE
Upon successful completion, all functions return the converted value, if any.
If the correct value would cause overflow:
returns or (according to the sign of the value), and sets to
returns and sets to
For all other errors, zero is returned and is set to indicate the error.
ERRORS
and fail and is set, if any of the following conditions are encountered:
The value of base is not supported.
The value to be returned would have caused overflow.
AUTHOR
and were developed by HP.
SEE ALSO ctype(3C), strtod(3C), strtol(3C), scanf(3S), thread_safety(5).
STANDARDS CONFORMANCE strtoimax(3C)