08-08-2011
Add leading zeros to columns in a file
Hello Gurus,
Quick question. I have a file with the following records:
A~000000000000518000~SLP ~99991231~20090701~88.50~USD~CS~
A~000000000000518000~SLP ~99991231~20090701~102.00~USD~CS~
A~000000000000772000~SLP ~99991231~20100701~118.08~USD~CS~
I wold like to do the following:
1. Add leading zeros before column 6, such that there are 5 places, and 2 decimal positions
2. Add a space after the value of column 7 and another space after the value of column 8, such that the output file looks like the following:
A~000000000000518000~SLP ~99991231~20090701~00088.50~USD ~CS ~
A~000000000000518000~SLP ~99991231~20090701~00102.00~USD ~CS ~
A~000000000000772000~SLP ~99991231~20100701~00118.08~USD ~CS ~
Thanks in advance for your help!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How to insert leading zeros into a left-justisfied zip code?
e.g. Zip code is written as 60320 which is left-justified to make it be read as 0060320.
We have to move it to right-justifiable then insert 2 leading zeros into it... ;) (1 Reply)
Discussion started by: wtofu
1 Replies
2. Shell Programming and Scripting
Hi All,
I am working with a fixed width file Forrmat.
C1 Number (10,3)
C2 Number (10,3)
e.g.
c1= 0000000100.000
c2= 0000000020.000
0000000100.0000000000020.000
I have to perform c1 - c2 . i.e. I want answer to be 0000000080.000. but I am loosing the leading zeros( only getting... (3 Replies)
Discussion started by: Manish Jha
3 Replies
3. Shell Programming and Scripting
Hi
I have a file in which I have 5 columns which are delimited by “|” as shown
ABC|12|YAK|METRIC|000000019.5
XYZ|10|ABX|META|000000002.5
Now my requirement is to take the last column trim the leading zero's for that column values and write back to the same file in the same... (7 Replies)
Discussion started by: nvuradi
7 Replies
4. Shell Programming and Scripting
Hi
i need help in adding leading zero to filenames
e.g file name in my folder are
1_234sd.txt
23_234sd.txt
the output i need is
001_234sd.txt
023_234sd.txt
can i do this shell scripting
please help (2 Replies)
Discussion started by: rsmpk
2 Replies
5. Shell Programming and Scripting
I need to add leading zeros in a floating point numbers.
The length of the number should be 13 including decimal.
The input number is changing so number of leading zeros is not fix.
For example
input output
216.000 000000216.000
1345.000 000001345.000
22345.500 ... (4 Replies)
Discussion started by: reeta_shri
4 Replies
6. Shell Programming and Scripting
Hi,
i have a variable which conatins values like 00001,0003,00067,00459.
I want to use the values one by one and in the same form as they are like 00001,0003,00067,00459.
Also can anyone tell me how to increment those numbers by 1,keeping the format as same like 00002,0004,00068,00460.... (5 Replies)
Discussion started by: arijitsaha
5 Replies
7. Shell Programming and Scripting
I have a list of numbers extracted and need to delete the leading zeros from them, but when i do so, the command I am using also deletes numbers that end in Zero as well. eg 10, 20, 30, etc
this is part of a larger script and the only way I can think of is to try and detect the 10,20 30 etc in... (19 Replies)
Discussion started by: kcpoole
19 Replies
8. Shell Programming and Scripting
Hi All,
i have a fixed width file , where each line is 3200 length.
File:
1ABC 1111 2222 3333 000012341 1001
2ABC 1111 2222 3333 000012342 1002
3ABC 1111 2222 3333 000112343 1003
1DEF 5555 4444 9696 000012344 1004
2DEF 5555 2323 8686 000012345 1005
3DEF 5555 1212 7676 000012346 1006
... (1 Reply)
Discussion started by: mechvijays
1 Replies
9. Shell Programming and Scripting
Hello,
I have a pipe separated file with two major lines. One is header and another is detail line. Header starts with H and Detail start with D.
Sample Content:
H|123456|Joes Watson|UK|4/5/2016|12/5/2016|3456|HC|NW||||||
D|123456|Joes... (13 Replies)
Discussion started by: Mannu2525
13 Replies
10. Shell Programming and Scripting
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)
Discussion started by: karthik adiga
11 Replies
LEARN ABOUT SUNOS
slpsetproperty
SLPSetProperty(3SLP) Service Location Protocol Library Functions SLPSetProperty(3SLP)
NAME
SLPSetProperty - set an SLP configuration property
SYNOPSIS
#include <slp.h>
void SLPSetProperty(const char *pcName, const char *pcValue);
DESCRIPTION
The SLPSetProperty() function sets the value of the SLP property to the new value. The pcValue parameter contains the property value as a
string.
PARAMETERS
pcName A null-terminated string with the property name. pcName cannot be NULL.
pcValue A null-terminated string with the property value. pcValue cannot be NULL
ERRORS
This function or its callback may return any SLP error code. See the ERRORS section in slp_api(3SLP).
EXAMPLES
Example 1: Setting a Configuration Property
The following example shows to set the property net.slp.typeHint to service:ftp:
SLPSetProperty ("net.slp.typeHint" "service:ftp");
ENVIRONMENT VARIABLES
SLP_CONF_FILE When set, use this file for configuration.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWslpu |
+-----------------------------+-----------------------------+
SEE ALSO
slpd(1M), slp_api(3SLP), slp.conf(4), slpd.reg(4), attributes(5)
System Administration Guide: Network Services
Kempf, J. and Guttman, E. RFC 2614, An API for Service Location. The Internet Society. June 1999.
SunOS 5.10 16 Jan 2003 SLPSetProperty(3SLP)