Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with File Processing (AWK)
Top Forums Shell Programming and Scripting Help with File Processing (AWK) Post 302597416 by karumudi7 on Friday 10th of February 2012 08:55:29 AM
Old 02-10-2012
Question Help with File Processing (AWK)
Input File:
Code:
1234, 2345,abc
1,24141,gw
222,rff,sds
2232145,sdsd,121

Output file to be generated:
Code:
000001234,2345,abc
000000001,24141,gw
000000222,rff,sds
002232145,sdsd,121

i.e; the first column is padded to get 9 digits.

I tried with following:
Code:
 awk -F"," 'BEGIN{OFS=",";} {printf ("%09d\n",$1 $2 $3)}' testfile

But I am not getting the desired output. Somewhere I am doing mistake in printf.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

processing a file with sed and awk

Hello, I have what is probably a simple task in text manipulation, but I just can't wrap my brain around it. I have a text file that looks something like the following. Note that some have middle initials in the first field and some don't. john.r.smith:john.smith@yahoo.com... (4 Replies)
Discussion started by: manouche
4 Replies

2. Shell Programming and Scripting

how to change the current file processing to some other random file in awk ?

Hello, say suppose i am processing an file emp.dat the field of which are deptno empno empname etc now say suppose i want to change the file to emp.lst then how can i do it? Here i what i attempted but in vain BEGIN{ system("sort emp.dat > emp.lst") FILENAME="emp.lst" } { print... (2 Replies)
Discussion started by: salman4u
2 Replies

3. UNIX for Dummies Questions & Answers

poor performance processing file with awk

Hello, I'm running a script on AIX to process lines in a file. I need to enclose the second column in quotation marks and write each line to a new file. I've come up with the following: #!/bin/ksh filename=$1 exec >> $filename.new cat $filename | while read LINE do echo $LINE | awk... (2 Replies)
Discussion started by: scooter53080
2 Replies

4. Shell Programming and Scripting

awk help in processing file.

I am trying to process file which has following data #23456789012345 ACNASPSA13N0N0 ACNAPCPA05N0N0 ACNAFATS11N0N0 I want to take out each line from the file and what to put in the file by name which if part of the line starting from offset 10 to 15. It means I want to create three file... (3 Replies)
Discussion started by: ekb
3 Replies

5. Programming

AWK processing of a three-column file

I have a 3-column data file, for which I wish to print certain parts of $3 PHI PSI A(x) -177.5 -177.5 1.0625 -177.5 -172.5 0.55 -177.5 -167.5 0.0478125 -177.5 -162.5 0 -177.5 -157.5 0.284375 -177.5 -152.5 0.187188 -177.5 -147.5 0.236875 -177.5 -142.5 0.383438 -177.5 ... (3 Replies)
Discussion started by: chrisjorg
3 Replies

6. Shell Programming and Scripting

Help with File Processing (AWK)

Input File: 1234, 2345,abc 1,24141,gw 222,rff,sds 2232145,sdsd,121 Output file to be generated: 000001234,2345,abc 000000001,24141,gw 000000222,rff,sds 002232145,sdsd,121 i.e; the first column is padded to get 9 digits. I tried with following: (1 Reply)
Discussion started by: karumudi7
1 Replies

7. Programming

awk processing / Shell Script Processing to remove columns text file

Hello, I extracted a list of files in a directory with the command ls . However this is not my computer, so the ls functionality has been revamped so that it gives the filesizes in front like this : This is the output of ls command : I stored the output in a file filelist 1.1M... (5 Replies)
Discussion started by: ajayram
5 Replies

8. UNIX for Dummies Questions & Answers

awk - Rename output file, after processing, same as input file

I have one input file ABC.txt and one output DEF.txt. After the ABC is processed and created output, I want to rename ABC.txt to ABC.orig and DEF to ABC.txt. Currently when I am doing this, it does not process the input file as it cannot read and write to the same file. How can I achieve this? ... (12 Replies)
Discussion started by: High-T
12 Replies

9. Shell Programming and Scripting

Help with file processing using awk

hello All, I'm new to AWK programming and learned myself few things to process a file and deal with duplicate lines, but I got into a scenario which makes me clueless to handle. Here is the scenario.. Input file: user role ----- ---- AAA add AAA delete BBB delete CCC delete DDD ... (10 Replies)
Discussion started by: julearn
10 Replies

10. Shell Programming and Scripting

Processing a formatted file with awk

Hi - I want to interrogate information about my poker hands, sessions are all recorded in a text file in a particular format. Each hand starts with the string <PokerStars> followed by a unique hand reference and other data like date/time. There is then all the information about each hand. My first... (5 Replies)
Discussion started by: rbeech23
5 Replies

LEARN ABOUT DEBIAN

ecaccess-job-get

ECACCESS-JOB-GET(1p)					User Contributed Perl Documentation				      ECACCESS-JOB-GET(1p)

NAME

       ecaccess-job-get - Download a Job Output/Input/Error File

SYNOPSIS

       ecaccess-job-get -version|-help|-manual

       ecaccess-job-get [-debug] [-input|-error] [-encrypt] [-binary] [-bufsize length] job-id local-target-file

DESCRIPTION

       Allow downloading the Job Output/Input/Error Files with identifier job-id.

       The file is downloaded localy in the local-target-file.

ARGUMENTS

       job-id  The identifier of the ECaccess Job to retrieve.

       local-target-file
	       The name of the Local Target File.

OPTIONS

       -input  By default the Job Output File is downloaded. Using this option allow downloading the Job Input File instead.

       -error  By default the Job Output File is downloaded. Using this option allow downloading the Job Error File instead.

       -encrypt
	       By default files are downloaded through the plain text channel (http). Using this option will force the download to occurs through
	       the SSL secure channel (https).

       -binary By default files are downloaded as text files. This option will download files as binary files (decode_base64 required). Please
	       note that text files can also be downloaded in binary mode but text mode is faster. You should use this option if your job output
	       is containing non-text characters.

       -bufsize length
	       Specify the length of the buffer (in bytes) which is used to download the file.	The larger the buffer the smaller the number of
	       http/s requests. By default a buffer of 524288 bytes(512KB) is used.

       -version
	       Display version number and exits.

       -help   Print a brief help message and exits.

       -manual Prints the manual page and exits.

       -debug  Display the SOAP messages exchanged.

EXAMPLES

       ecaccess-job-get 124356 ./ecaccess-job-124356.output

       Download the output of the ECaccess Job 124356 in the local ecaccess-job-124356.output file.

SEE ALSO

       ecaccess-job-delete, ecaccess-job-list, ecaccess-job-restart, ecaccess-job-submit and ecaccess.

perl v5.14.2							    2012-04-16						      ECACCESS-JOB-GET(1p)
All times are GMT -4. The time now is 11:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy