08-10-2005
remove precursing zeros
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 used to viewing the seconed set of data, Is there a way to remove the 's' and precursing zeros? I was thinking of a tr command, but quickly realized the folly in that idea. I am not sure that a sed would work. Like I say it's not to big of a deal so if there is something simple I am all for it. Thanks in advance for any replies guys, I appriciate it.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: mahalakshmi
10 Replies
2. UNIX for Dummies Questions & Answers
Hi can I know command to pad Zeros to a value
I get 16 and I need to send 0000000016 (5 Replies)
Discussion started by: mgirinath
5 Replies
3. UNIX for Advanced & Expert Users
Hi,
I want to trim +with leading zero's with amount fields.I know using awk for trimming leading zeros with +,but I want get the entire row itself.
cat file_name |awk -F " " '{printf "%14.4f%f\n",$4}'
ex:
10 xyz bc +00000234.4500
20 yzx foxic +002456.000
Expexted
10 xyz bc... (3 Replies)
Discussion started by: mohan705
3 Replies
4. Shell Programming and Scripting
Is it possible by using awk to remove leading zeros for a hex number?
ex:
0000000011179E0A -> 11179E0A
Thank you! (4 Replies)
Discussion started by: carloszhang
4 Replies
5. Shell Programming and Scripting
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)
Discussion started by: theflamingmoe
10 Replies
6. UNIX for Dummies Questions & Answers
Hello Everyone,
I've got a comma-delimited file that looks like this:
0012,123 ,456 ,05/12/2014
0123,525 ,286 ,05/12/2014
0456,791 ,300 ,05/12/2014
1095,759 ,300 ,05/12/2014
1344,576 ,292 ,05/12/2014
1558,551 ,283 ,05/12/2014
002183719, , ... (9 Replies)
Discussion started by: Scottie1954
9 Replies
7. 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
8. Shell Programming and Scripting
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)
Discussion started by: Joselouis
4 Replies
9. UNIX for Beginners Questions & Answers
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
10. UNIX for Beginners Questions & Answers
Hi Folks -
I need help manipulating a file.
For column 2, I need to replace the first 3 leading zeros with spaces.
The file looks like such:
00098|00011250000003|00000000000.0200|D|1|07|51|04INDP |04|00820|CS|000000|092717|000000000000.0000|000|... (3 Replies)
Discussion started by: SIMMS7400
3 Replies
LEARN ABOUT CENTOS
lastlog
LASTLOG(8) System Management Commands LASTLOG(8)
NAME
lastlog - reports the most recent login of all users or of a given user
SYNOPSIS
lastlog [options]
DESCRIPTION
lastlog formats and prints the contents of the last login log /var/log/lastlog file. The login-name, port, and last login time will be
printed. The default (no flags) causes lastlog entries to be printed, sorted by their order in /etc/passwd.
OPTIONS
The options which apply to the lastlog command are:
-b, --before DAYS
Print only lastlog records older than DAYS.
-h, --help
Display help message and exit.
-R, --root CHROOT_DIR
Apply changes in the CHROOT_DIR directory and use the configuration files from the CHROOT_DIR directory.
-t, --time DAYS
Print the lastlog records more recent than DAYS.
-u, --user LOGIN|RANGE
Print the lastlog record of the specified user(s).
The users can be specified by a login name, a numerical user ID, or a RANGE of users. This RANGE of users can be specified with a min
and max values (UID_MIN-UID_MAX), a max value (-UID_MAX), or a min value (UID_MIN-).
If the user has never logged in the message ** Never logged in** will be displayed instead of the port and time.
Only the entries for the current users of the system will be displayed. Other entries may exist for users that were deleted previously.
NOTE
The lastlog file is a database which contains info on the last login of each user. You should not rotate it. It is a sparse file, so its
size on the disk is usually much smaller than the one shown by "ls -l" (which can indicate a really big file if you have in passwd users
with a high UID). You can display its real size with "ls -s".
FILES
/var/log/lastlog
Database times of previous user logins.
CAVEATS
Large gaps in UID numbers will cause the lastlog program to run longer with no output to the screen (i.e. if in lastlog database there is
no entries for users with UID between 170 and 800 lastlog will appear to hang as it processes entries with UIDs 171-799).
shadow-utils 4.1.5.1 05/25/2012 LASTLOG(8)