Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

How to left trim padded zeroes

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to left trim padded zeroes
# 1  
Old 11-05-2008
How to left trim padded zeroes
I have a filename 'INITIATE_FINAL_ALL_000080889.dat', and I want to capture just the number '80889' from it.

Here is what I have so far:

%> echo INITIATE_FINAL_ALL_000080889.dat | sed "s/[^0-9]*//g"
000080889

Now, I just need to trim off the padded zeroes.

Thanks,

- CB
# 2  
Old 11-05-2008
Quote:
Originally Posted by ChicagoBlues
I have a filename 'INITIATE_FINAL_ALL_000080889.dat', and I want to capture just the number '80889' from it.

Here is what I have so far:

%> echo INITIATE_FINAL_ALL_000080889.dat | sed "s/[^0-9]*//g"
000080889

Now, I just need to trim off the padded zeroes.

Thanks,

- CB
echo INITIATE_FINAL_ALL_000080889.dat | sed "s/[^0-9]*//g" | sed 's/^[0]\{1,\}//'
# 3  
Old 11-05-2008
Another approach is:

Code:
awk '{gsub(/[^0-9]/,"");print int($0)}'

Regards
# 4  
Old 11-05-2008
Some shells support the following expansion:

Code:
% export f=INITIATE_FINAL_ALL_000080889.dat
% bash -c 'printf "%g\n"  "${f//[^0-9]}"'  
80889
% zsh -c 'printf "%d\n"  "${f//[^0-9]}"'                                         
80889
% ksh -c 'printf "%d\n"  "${f//[^0-9]}"' # this is ksh93
80889

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Printf padded string

Is possible to print padded string in printf? Example echo 1 | awk '{printf("%03d\n", $1)}' 001I want S1 S11 S2 S21to be padded as: S01 S11 S02 S21Thanks! (26 Replies)
Discussion started by: yifangt
26 Replies

2. Shell Programming and Scripting

Comma padded.. Output

Hello, here is the outout of the command below.. Can someone please tell me how to get the output as below output needed: 18914,30716,17051,4139,14155... ( no comma for the last value) ps -e -o pcpu,pid,user,tty,args | sort -n -k 1 -r | head | awk '{print $2}' 18914 30716 17051 4139... (10 Replies)
Discussion started by: kamathg
10 Replies

3. Shell Programming and Scripting

timestamp field was padded with blanks warning

There are two columns on the data base table, create and update timestamps of datatype timestamp. I dont have these fields on the csv file. So I am doing the below. awk -F , -v d="$(date "+ %Y-%m-%d-%H.%M.%S")" '{ OFS=FS; print $1, $2, $3, $4, d, $5, $6, d }' temp.csv > temp1.csv and then... (3 Replies)
Discussion started by: mitr
3 Replies

4. Shell Programming and Scripting

Delimted to padded conversion with unknown field length

I’m looking for an elegant way to convert a delimited file (comma delimited in this case) to padded columns (for printing in non-proportional font) but the length of each column is not known ahead of time. It needs to be calculated for each column from the longest entry in that column in a given... (3 Replies)
Discussion started by: Michael Stora
3 Replies

5. Shell Programming and Scripting

Using Seq As A Variable With Padded Digits

Hi all. Im trying to use a sequence in a while loop like this below. I need it for navigating a year, month, day folder structure where a user can input the start date and have it go to the desired end date. The script will grab a certain file on each day then move onto the next. Ive got all that... (3 Replies)
Discussion started by: Grizzly
3 Replies

6. Shell Programming and Scripting

Convert from CSV to space padded columns (.ksh)

Hello, Could someone please help me to convert a string(s) of comma separated values into space padded columns in .ksh? ex. 10-21-2008,someword,blah,127.0.0.1,8,3 10-21-2008,randomword,ick,128.0.111.128,1,0 converted to 10-21-2008 someword blah 127.0.0.1 8... (6 Replies)
Discussion started by: WhotheWhat
6 Replies

7. Filesystems, Disks and Memory

finding empty files that are padded with zeros

how can search for files that are non-zero length but are empty? (1 Reply)
Discussion started by: polive96
1 Replies

8. Shell Programming and Scripting

Move and rename files in seq. with padded digits

Greetings, I am new to scripting, but find if I can see the code working for a given problem, then I can eventually figure it out. (9 Replies)
Discussion started by: rocinante
9 Replies

9. Shell Programming and Scripting

How to trim the leading zeroes in a Currency field ?

How do I trim the leading zeroes, and (+,-) in the currency field ? I have a text file. Your bill of +00002780.96 for a/c no. 25287324 is due on 11-06. Your bill of +00422270.48 for a/c no. 28931373 is due on 11-06. I want the O/P file to be like. Your bill of 2780.96 for a/c no. 25287324... (22 Replies)
Discussion started by: Amruta Pitkar
22 Replies

10. Shell Programming and Scripting

Problem with echo for var, padded with spaces

While concatenating 2 values, one which expanded to fixed width & other not, I am not getting value expanded as fixed width. Following is script for the same : #!/bin/sh var1="abc" var2="def" var1Fxd=`echo $var1 | awk '{printf("%-6s",$0)}'` echo $var1Fxd""$var2 But, if I try - echo... (2 Replies)
Discussion started by: videsh77
2 Replies
Login or Register to Ask a Question