Sponsored Content
Operating Systems HP-UX Padding zeros after removing commas in file Post 88829 by pranag21 on Wednesday 9th of November 2005 07:50:02 AM
Old 11-09-2005
Padding zeros after removing commas in file

Hi Gurus,

There is a ASCII file in which a comma is used as a seperator for the amount field when the amount exceed seven digits: e.g. 0001300,000. Now, this comma needs to be removed from this field, after padding leading zeros (to maintain the ASCII positions) e.g. 00001300000. Could anyone post a detailed solution which can handle this requirement?. There are multiple records in the file which fall under this category.


Thanks for your help

Prakash
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

removing commas from text file

Dear all I have a file which looks like this xxxxxxxxxxxxxx,xxx,xxxxxxxxxx xxxxxxxxxxxxxx,xxx,xxxxxxxxxx etc basically 14 characters then a comma, three characters, then a comma then 10 characters. We are uploading this file to our mainframe and they want the commas removed, so it... (6 Replies)
Discussion started by: hcclnoodles
6 Replies

2. Shell Programming and Scripting

Removing leading zeros from a variable

How do I remove or add leading zeroa from a variable. To make variable 10 characters long when adding zeros. (6 Replies)
Discussion started by: toshidas2000
6 Replies

3. Shell Programming and Scripting

Help needed in padding leading zeros

Hi all, I have file with numeric values. I need to pad each value with leading zeros such that total lenght of each value is 16. Example: cat tmp.txt 502455 50255 5026 5027 5028 Output 0000000000502455 0000000000050255 0000000000005026 0000000000005027 0000000000005028 Any... (12 Replies)
Discussion started by: jakSun8
12 Replies

4. Shell Programming and Scripting

bash typeset padding with zeros

Hi everybody, I have a question about typesetting. I originally wrote a script for use with ksh and now I am on a system that I cannot modify, and it only has bash. In the original script I just did typeset -RZ4 variable and it would add the leading zeros. In bash, it doesn't work. I've... (2 Replies)
Discussion started by: jwheeler
2 Replies

5. Shell Programming and Scripting

Need help in removing commas

i have the below line as output from a script. I want to delete the string "," and get the output without comma, cat D* | grep "bytes free" | awk '{print $3}' | ????? output: 40,966,189,056 Desired O/P: 40966189056 (1 Reply)
Discussion started by: ali560045
1 Replies

6. Shell Programming and Scripting

Padding with zeros.

Hi Friends, I would like to left pad with "0's" on first column say (width six) I have a large file with the format: FILE: 1: ALFRED 84378 NY 8385: JAMES 88385 FL 323: SMITH 00850 TX My output needs to be like: 000001: ALFRED 84378 NY 008385: JAMES 88385 FL 000323: SMITH... (10 Replies)
Discussion started by: sbasetty
10 Replies

7. Shell Programming and Scripting

Removing commas within semicolon in a flat file

Hi , Im relatively new to unix and have to process a comma serparated flat file . I recieve some of the fields in double quotes and i want to remove it .. INPUT ==== filed1,field2,field3,"fie,ld4" OUTPUT ===== field1,field2,field3,"field4" can anyone tell me how to achieve... (10 Replies)
Discussion started by: r_t_1601
10 Replies

8. Shell Programming and Scripting

Removing commas within semicolon in a flat file

i am recieving a flat file ( comma seperated ) with comma in between double quotes in any of the source fields . i need to remove the comma in double quotes and process the file thereafter fields in file ========= col1,col2,col3,col4 input can be any of the followng... (31 Replies)
Discussion started by: r_t_1601
31 Replies

9. Shell Programming and Scripting

Fixed with file- removing leading zeros and adding the space

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

10. UNIX for Beginners Questions & Answers

Removing commas from CSV file

Hi I'm creating a sh script to generate a csv file. The CSV contains the values from a sql table. The content looks this: a,b,c,c2,c3,,,,,,,,,,,d,e I have some code that can separate the fields using the comma as delimiter, but some values actually contain commas, such as... (2 Replies)
Discussion started by: preema
2 Replies
PRINTF(1)						    BSD General Commands Manual 						 PRINTF(1)

NAME
printf -- formatted output SYNOPSIS
printf format [arguments ...] DESCRIPTION
printf formats and prints its arguments, after the first, under control of the format. The format is a character string which contains three types of objects: plain characters, which are simply copied to standard output, character escape sequences which are converted and copied to the standard output, and format specifications, each of which causes printing of the next successive argument. The arguments after the first are treated as strings if the corresponding format is either b, B, c, or s; otherwise it is evaluated as a C constant, with the following extensions: o A leading plus or minus sign is allowed. o If the leading character is a single or double quote, the value is the ASCII code of the next character. The format string is reused as often as necessary to satisfy the arguments. Any extra format specifications are evaluated with zero or the null string. Character escape sequences are in backslash notation as defined in ANSI X3.159-1989 (``ANSI C89''). The characters and their meanings are as follows: e Write an <escape> character. a Write a <bell> character.  Write a <backspace> character. f Write a <form-feed> character. Write a <new-line> character. Write a <carriage return> character. Write a <tab> character. v Write a <vertical tab> character. ' Write a <single quote> character. " Write a <double quote> character. \ Write a backslash character. um Write an 8-bit character whose ASCII value is the 1-, 2-, or 3-digit octal number num. xxx Write an 8-bit character whose ASCII value is the 1- or 2-digit hexadecimal number xx. Each format specification is introduced by the percent character (``%''). The remainder of the format specification includes, in the follow- ing order: Zero or more of the following flags: # A '#' character specifying that the value should be printed in an ``alternative form''. For b, c, d, and s formats, this option has no effect. For the o format the precision of the number is increased to force the first character of the output string to a zero. For the x (X) format, a non-zero result has the string 0x (0X) prepended to it. For e, E, f, g, and G formats, the result will always contain a decimal point, even if no digits follow the point (normally, a decimal point only appears in the results of those formats if a digit follows the decimal point). For g and G formats, trailing zeros are not removed from the result as they would otherwise be. - A minus sign '-' which specifies left adjustment of the output in the indicated field; + A '+' character specifying that there should always be a sign placed before the number when using signed formats. ' ' A space specifying that a blank should be left before a positive number for a signed format. A '+' overrides a space if both are used; 0 A zero `0' character indicating that zero-padding should be used rather than blank-padding. A '-' overrides a '0' if both are used; Field Width: An optional digit string specifying a field width; if the output string has fewer characters than the field width it will be blank- padded on the left (or right, if the left-adjustment indicator has been given) to make up the field width (note that a leading zero is a flag, but an embedded zero is part of a field width); Precision: An optional period, '.', followed by an optional digit string giving a precision which specifies the number of digits to appear after the decimal point, for e and f formats, or the maximum number of characters to be printed from a string (b, B, and s formats); if the digit string is missing, the precision is treated as zero; Format: A character which indicates the type of format to use (one of diouxXfwEgGbBcs). A field width or precision may be '*' instead of a digit string. In this case an argument supplies the field width or precision. The format characters and their meanings are: diouXx The argument is printed as a signed decimal (d or i), unsigned octal, unsigned decimal, or unsigned hexadecimal (X or x), respec- tively. f The argument is printed in the style [-]ddd.ddd where the number of d's after the decimal point is equal to the precision speci- fication for the argument. If the precision is missing, 6 digits are given; if the precision is explicitly 0, no digits and no decimal point are printed. eE The argument is printed in the style [-]d.ddde+-dd where there is one digit before the decimal point and the number after is equal to the precision specification for the argument; when the precision is missing, 6 digits are produced. An upper-case E is used for an 'E' format. gG The argument is printed in style f or in style e (E) whichever gives full precision in minimum space. b Characters from the string argument are printed with backslash-escape sequences expanded. The following additional backslash-escape sequences are supported: c Causes printf to ignore any remaining characters in the string operand containing it, any remaining string operands, and any additional characters in the format operand. num Write an 8-bit character whose ASCII value is the 1-, 2-, or 3-digit octal number num. ^c Write the control character c. Generates characters `00' through `37`, and `177' (from `^?'). M-c Write the character c with the 8th bit set. Generates characters `241' through `376`. M^c Write the control character c with the 8th bit set. Generates characters `200' through `237`, and `377' (from `M^?'). B Characters from the string argument are printed with unprintable characters backslash-escaped using the `c',`^c',`M-c'or `M^c', formats described above. c The first character of argument is printed. s Characters from the string argument are printed until the end is reached or until the number of characters indicated by the pre- cision specification is reached; if the precision is omitted, all characters in the string are printed. % Print a `%'; no argument is used. In no case does a non-existent or small field width cause truncation of a field; padding takes place only if the specified field width exceeds the actual width. EXIT STATUS
printf exits 0 on success, 1 on failure. SEE ALSO
echo(1), printf(3), vis(3), printf(9) STANDARDS
The printf utility conforms to IEEE Std 1003.1-2001 (``POSIX.1''). Support for the floating point formats and `*' as a field width and precision are optional in POSIX. The behaviour of the %B format and the ', ", xxx, e and [M][-|^]c escape sequences are undefined in POSIX. BUGS
Since the floating point numbers are translated from ASCII to floating-point and then back again, floating-point precision may be lost. Hexadecimal character constants are restricted to, and should be specified as, two character constants. This is contrary to the ISO C stan- dard but does guarantee detection of the end of the constant. NOTES
All formats which treat the argument as a number first convert the argument from its external representation as a character string to an internal numeric representation, and then apply the format to the internal numeric representation, producing another external character string representation. One might expect the %c format to do likewise, but in fact it does not. To convert a string representation of a decimal, octal, or hexadecimal number into the corresponding character, two nested printf invocations may be used, in which the inner invocation converts the input to an octal string, and the outer invocation uses the octal string as part of a format. For example, the following command outputs the character whose code is 0x0A, which is a newline in ASCII: printf "$(printf "\%o" "0x0A")" BSD
May 6, 2008 BSD
All times are GMT -4. The time now is 07:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy