UNIX for Dummies Questions & Answers

I have flat file in which the length of the a record is 1000 characters. the last field of the file range is from 951 to 1000. So currently i am getting the last field data to be less than 1000 characters ( from 951 to 1000 i see that the data varies from 10 to 50). So is there a way we can pad up these kind of data with 0and ensure it is of size of the last field of the record is 50 and total row length is 1000.

printf (available in shell and in most languages) may be what you require (hard to tell from your post to be honest, could do with a bit of clarification)

Code:

perl -ne 'chomp;print "$_","0"x(1000-length($_)),"\n"' inputfile

Example

Input : 2343.........456( 1 record of 934 char)
3465.........345( 1 record of 60 char)
output :2343..........456000...00(1 record of 1000 char)
3465.........345(1 record of 60 char)

I ll hav to convert the records of varying length in a flat file to a record of size 1000 by padding neccesary zeros at the end. And also this should be done for record starting with 2343 only. Rest of records should be intact

Try:

Code:

awk '/^2343/{$0=sprintf("%s%0" w-length "s", $0,x)}1' w=1000 infile

HI Scrutnizer

I have a data that is primarily consist of integer and the code you suggested is not working fine. is htere any change i wwill have to make ?

Hi, Akshay, what isn't working fine?