Printf padded string


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Printf padded string
# 8  
Old 09-11-2015
My apologies if any confusion caused!
I should be more specific with my examples. My input format always starts with char/string and followed by numbers of different length. So my original example starts with single char, which is
Code:
S1
S2 
S12 
S21

expected output is:
Code:
S01
S02
S12
S21

and second example starts with string:
Code:
sk1
sk12
sk321
sk1344

output is:
Code:
sk0001
sk0012
sk0321
sk1344

The printf utility (or awk printf function) is not able to determine where digits are in an alphanumeric string. This clarified my question, anyway.
Yoda's answer seems to be the first choice for me, so that I can strip the leading char(s) then handle the rest digits with printf format identifier.
Thanks a lot again!
# 9  
Old 09-11-2015
Here is an awk approach that might work:-
Code:
awk '
        NR == FNR {
                m = ( m < length ? length : m )
                next
        }
        {
                match( $0, /[0-9]/ )
                format = "%s%0" ( m - RSTART ) + 1 "d\n"
                printf format, substr($0, 1, RSTART-1 ), substr( $0, RSTART )
        }
' file file

These 2 Users Gave Thanks to Yoda For This Post:
# 10  
Old 09-11-2015
Since you refused to answer most of my questions, I will make one final attempt at trying to handle a general case. Since you didn't give enough information about the desired output format, I'll make some code that reads input strings and produces output strings with the following characteristics:
  1. Input strings to be processed are lines in a file named file.
  2. Each input string is an alphanumeric string ending in one or more decimal digits.
  3. The string of trailing decimal digits identify an integer value that can be stored in an object equivalent to a C language signed long integer.
  4. The length of the leading alphanumeric character string before the ending decimal digits varies in length from 0 characters up to the number of characters in the input string minus 1.
  5. The decimal digits at the end of each output string are to be padded with leading zeros such that the string of decimal digits at the end of each output string contains the same number of ending decimal digits as the longest string of ending decimal digits in the input strings being processed.
  6. The output string will contain the leading alphanumeric characters before the ending string of decimal digits found in the input string followed by the decimal digit string found at the end of that input string with leading zeros added as described in #5 above.
  7. If the input does not conform to the above specifications, the output format is undefined.
Since you refused to specify the length of the desired ending zero filled decimal digit output string, I'll use awk for this example to avoid reading the input file twice:
Code:
awk '
BEGIN {	m = 1
}
{	tail[NR] = substr($0, match($0, /[[:digit:]]*$/))
	head[NR] = substr($0, 1, RSTART - 1)
	if(RLENGTH > m)
		m = RLENGTH
}
END {	for(i = 1; i <= NR; i++)
		printf("%s%0*d\n", head[i], m, tail[i])
}' file

If file contains:
Code:
S1
S2
S12
S21
sk1
sk12
sk321
sk1344
strange1prefix2long99
123

it produces the output:
Code:
S0001
S0002
S0012
S0021
sk0001
sk0012
sk0321
sk1344
strange1prefix2long0099
0123

and if file just contains the 1st four input lines shown above, the output would be:
Code:
S01
S02
S12
S21


Last edited by Don Cragun; 09-11-2015 at 06:10 PM.. Reason: Fix typo in Item #6 in the list.
This User Gave Thanks to Don Cragun For This Post:
# 11  
Old 09-11-2015
Thanks Don!
I never meant to refuse to answer your question. Wish I did not offend you when I should have pointed my reply corresponding to your very question.
Originally I was trying to find the format specifier of printf() to pad any alphanumeric string in each row. Googled for a while, no luck. Yoda's first reply DID give the answer of my example, but not in the way I could think of. However, your first reply clarified that there is no such specifier for printf() to pad alphanumeric string.
Then I gave a second example to describe what I was looking for, which is padding numbers of the alphanumeric string with "0". The padding is only for the numeric part of the string.
Your "final attempt" did give more than what I wanted, as my case is not that complicated.
Did I answer your questions now?!
Thanks a lot!
# 12  
Old 09-11-2015
Hi yifangt,

As you may have figured out, already, the string containing the representation of numbers must be subdivided and reinterpreted as part unmodified string and part zero padded number.

test.file
Code:
S1
S2
S12
S21
sk1
sk12
sk321
sk1344
strange1prefix2long99
123


Code:
$ perl -ne 'printf "%s%04s\n", /(\w*?)(\d+)$/' test.file

Code:
S0001
S0002
S0012
S0021
sk0001
sk0012
sk0321
sk1344
strange1prefix2long0099
0123

This User Gave Thanks to Aia For This Post:
# 13  
Old 09-12-2015
Just as my inital post here:
Change digits to 4, and change s to sk...
Code:
...
digits=4
printf "SK%0${digits}d\n" $numbers

Cheers n' good bye
This User Gave Thanks to sea For This Post:
# 14  
Old 09-13-2015
Quote:
Originally Posted by yifangt
Thanks Don!
I never meant to refuse to answer your question. Wish I did not offend you when I should have pointed my reply corresponding to your very question.
Originally I was trying to find the format specifier of printf() to pad any alphanumeric string in each row. Googled for a while, no luck. Yoda's first reply DID give the answer of my example, but not in the way I could think of. However, your first reply clarified that there is no such specifier for printf() to pad alphanumeric string.
Then I gave a second example to describe what I was looking for, which is padding numbers of the alphanumeric string with "0". The padding is only for the numeric part of the string.
Your "final attempt" did give more than what I wanted, as my case is not that complicated.
Did I answer your questions now?!
Thanks a lot!
I wasn't offended; just disappointed...

In post #1 in this thread, you said:
Quote:
Is possible to print padded string in printf?
and the four sample inputs you provided and the output you said you wanted seemed to indicate that you wanted two digit, leading zero filled numbers. And Yoda showed you how to do that.

In post #3, you said:
Quote:
Is there a simpler answer similar for number like printf "%04d" 12 #have 0012 to give any leading character you pick?
which I misread to mean that you wanted to use some character to pad numeric strings other than the <space> and <digit 0> fill that printf format strings %4d and %04d provide. And, I showed you how you can use any character you want instead of space and zero.

So, in post #6 you said:
Quote:
The format of my input is a combination of string(or a char, in the example) plus number, and the numbers are with different length of digits.
and you gave four more sample input strings and showed us the output you wanted for those specific four input strings. And, the samples implied that you wanted four digit zero filled numbers this time. Note that there is nothing in the above description that says that the string part of the input is alphabetic, fixed length, nor constant. Therefore, from the given descriptions to this point, there is no way to know where string ends and number begins for any input line, other than by making assumptions based on your two samples.

So, in post #7 in this thread, I said:
Quote:
Give us a clear definition of the input string formats you want to process, the output strings you want to produce from those input strings, and the parameters that will be supplied to specify output field width, fill characters to be used, where the input strings are coming from (a file, another string, command-line arguments, ...), how to determine where an input string prefix ends and the number begins, etc.
And, in post #8, you replied:
Quote:
I should be more specific with my examples. My input format always starts with char/string and followed by numbers of different length. So my original example starts with single char, which is ...
followed by the same two examples given earlier and repeating that the 1st example had a character that needed to be stripped and the 2nd example had a string (not two character string, not alphabetic string, not even fixed length string; just string) that needed to be stripped. You didn't supply any information that clearly defined the input string formats your script is supposed to handle, anything indicating if your script will receive a parameter indicating the width of the output string, anything indicating if your script will receive a parameter indicating how many digits should be displayed in the numbers, anything indicating if your script will receive a parameter indicating the desired fill character, and nothing indicating how to reliably determine the end of the initial "string" and the start of the "number" in your input.

So, I tried to come up with a set of requirements for a script that would read input in a format that seemed to cover all of your sample descriptions, write output based on characteristics of the input being processed, and produce output consistent with all of your sample descriptions. And then I wrote a script that tried to fulfill those requirements. It is relatively complicated because it has to deduce several parameters to be applied to the output by examining the input and making assumptions based on what it finds.

If the input alpha string is a constant number of characters for a given invocation of your script, my script can be simplified. If the input alpha string is the same string on every line for a given invocation of your script, my script can be simplified. If you tell the script how many digits you want in the number portion of the output, my script can be simplified. But, you still haven't told use:
  • if the alpha string is a constant number of characters for a given invocation of your script,
  • if the input alpha string is the same string on every line for a given invocation of your script, nor
  • how many digits you want in the number portion of the output.
This User Gave Thanks to Don Cragun For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Printf or any other method to put long string of spec characters - passing passwords

Hello, I am looking for a method to use in my bash script which allows me to use long strings with all special characters. I have found that printf method could be helpful for me but unfortunately, when I trying root@machine:~# tevar=`printf "%s%c"... (2 Replies)
Discussion started by: elxa1
2 Replies

2. Shell Programming and Scripting

Unable to match string within awk printf

Hi All I am working to process txt file into csv commo separated. Input.txt 1,2,asdf,34sdsd,120,haahha2 2,2,wewedf,45sdsd,130,haahha ..... .... Errorcode.txt 120 130 140 myawk.awk code: { BEGIN{ HEADER="f1,f2,f3,f4,f5,f6" (4 Replies)
Discussion started by: krsnadasa
4 Replies

3. Shell Programming and Scripting

Printf question: getting padded zero in decimal plus floating point together.

Hi Experts, Quick question: I am trying to get the output with decimal and floating point but not working: echo "20.03" | awk '{printf "%03d.2f\n" , $0 }' 020.2f How to get the output as : 020.03 Thank you. (4 Replies)
Discussion started by: rveri
4 Replies

4. Shell Programming and Scripting

How to print a string using printf?

I want to print a string say "str1 str2 str3 str4" using printf. If I try printing it using printf it is printing as follows. output ------- str1 str2 str3 str4 btw I'm working in AIX. This is my first post in this forum :) regards, rakesh (4 Replies)
Discussion started by: enigmatrix
4 Replies

5. Shell Programming and Scripting

String formatting using awk printf

Hi Friends, I am trying to insert lines of the below format in a file: # x3a4914 Joe 2010/04/07 # seh Lane 2010/04/07 # IN01379 Larry 2010/04/07 I am formatting the strings as follows using awk printf: awk 'printf "# %s %9s %18s\n", $2,$3,$4}' ... (2 Replies)
Discussion started by: sugan
2 Replies

6. Shell Programming and Scripting

Explanation for printf string in awk

hi all can any one help me to understand this bdf -t vfxs | awk '/\//{printf("%-30s%-10s%-10s%-10s%-5s%-10s\n",$1,$2,$3,$4,$5,$6)}' i want to understand the numbers %-30S% (4 Replies)
Discussion started by: maxim42
4 Replies

7. Shell Programming and Scripting

Help formatting a string. Something like printf?

Hi I'm having a problem with converting a file: ID X 1 7 1 8 1 3 2 5 2 7 2 2 To something like this: ID X1 X2 X3 1 7 8 3 2 5 7 2 I've tried the following loop: for i in `cat tst.csv| awk -F "," '{print $1}'| uniq`;do grep -h $i... (4 Replies)
Discussion started by: flotsam
4 Replies

8. Shell Programming and Scripting

printf with Character String

I am trying to use printf with a character string that is used within a do loop. The problem is that while in the loop, the printf prints the variable name instead of the value. The do loop calls the variable name from a text file (called device.txt): while read device do cat $device.clean... (2 Replies)
Discussion started by: dleblanc67
2 Replies

9. Shell Programming and Scripting

awk printf formatting using string format specifier.

Hi all, My simple AWK code does C = A - B If C can be a negative number, how awk printf formating handles it using string format specifier. Thanks in advance Kanu :confused: (9 Replies)
Discussion started by: kanu_pathak
9 Replies

10. Shell Programming and Scripting

find: problems escaping printf-command string

Hi Folks! Can you help me with this find -printf command. I seem to be unable to execute the printf-command from my shell script. I'm confused: :confused: My shell script snippet looks like this: #!/bin/sh .. COMMAND="find ./* -printf '%p %m %s %u %g \n'" echo "Command: ${COMMAND}"... (1 Reply)
Discussion started by: grahamb
1 Replies
Login or Register to Ask a Question