12-21-2004
PLEASE HELP: Fixed Width file using AWK
I am using the following command at the Unix prompt to make my 'infile' into a fixed width file of 100 characters.
awk '{printf "%-100s\n",$0}' infile > outfile
However, there are some records with a special character "©"
These records are using 3 characters in place of one and my record size is increasing to 102 because of that.
Can someone suggest me a solution so that the width of the record does not exceed 100 when I transfer this file as text to other server using ftp?
Regards,
Alok
Last edited by alok.benjwal; 12-21-2004 at 07:06 PM..
10 More Discussions You Might Find Interesting
1. UNIX Desktop Questions & Answers
I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated.
I... (4 Replies)
Discussion started by: sate911
4 Replies
2. Shell Programming and Scripting
Col1 Col2 Col3 Col4
12 Completed 08 0830
12 In Progress 09 0829
11 For F U 07 0828
Considering the file above, how could i replace the third column the most efficient way? The actual file size is almost 1G. I am... (10 Replies)
Discussion started by: tamahomekarasu
10 Replies
3. Shell Programming and Scripting
I was wondering someone might be able to push me in the right direction, I am writing a script to modify fixed-width spool files, As you can see below the original spool file broke a single line into two for printability sake.
I have had been able do the joins using sed, the thing I am... (10 Replies)
Discussion started by: Cho Nagurai
10 Replies
4. Shell Programming and Scripting
Source File:
abcdefghijklmnop01qrstuvwxyz
abcdefghijklmnop02qrstuvwxyz
abcdefghijklmnop03qrstuvwxyz
abcdefghijklmnop04qrstuvwxyz
abcdefghijklmnop05qrstuvwxyz
Whatever characters are in 17-18 on each line of the file, it should be concatenated to the same line at the character number... (6 Replies)
Discussion started by: tamahomekarasu
6 Replies
5. Shell Programming and Scripting
I have to create a single file from three files, Please see below for samples:
day.txt
20090101
20090102
item.txt
123456789101
12345678910209
1234567891
str.txt
1
12
123
output.txt
20090101123456789101 1 0
2009010112345678910209 12 ... (2 Replies)
Discussion started by: tamahomekarasu
2 Replies
6. Shell Programming and Scripting
Hi Guys
I am checking the treads to get the answer but i am not able to get the answer for my question.
I have two files. First file is a pattern file and the second file is the file i want to search in it. Output will be the lines from file2.
File1:
P2797f12af 44751228... (10 Replies)
Discussion started by: anshul_er
10 Replies
7. UNIX for Dummies Questions & Answers
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies
8. Shell Programming and Scripting
hi,
i have a fixed width file with multiple columns and need to print data using awk command.
i use: awk -F "|" '($5 == BH) {print $1,$2,$3}' <non_AIM target>.txt for a delimiter file.
but now i have a fixed width file like below:
7518 8269511BH 20141224951050N8262
11148 8269511BH... (5 Replies)
Discussion started by: kcdg859
5 Replies
9. Shell Programming and Scripting
All,
I used to use following command to replace specific location in a fixed width file.
Recently looks like my command stopped working as intended. We are on AIX unix.
awk 'function repl(s,f,t,v)
{ return substr(s,1,f-1) sprintf("%-*s", t-f+1, v) substr(s,t+1) }
NR<=10 {... (3 Replies)
Discussion started by: pinnacle
3 Replies
10. Shell Programming and Scripting
Hi Forum.
I have the following script that splits a large fixed-width file into smaller multiple fixed-width files based on input segment type.
The main command in the script is:
awk -v search_col_pos=$search_col_pos -v search_str_len=$search_str_len -v segment_type="$segment_type"... (8 Replies)
Discussion started by: pchang
8 Replies
LEARN ABOUT OPENSOLARIS
make_sockdfc
MAKE_SOCKDFC(8) System Manager's Manual MAKE_SOCKDFC(8)
NAME
make_sockdfc - Generates frozen configuratyion file for SOCKS server
SYNOPSIS
make_sockdfc [infile [outfile] ]
DESCRIPTION
make_sockdfc reads in a plain-text configuration file for the SOCKS server and produces a frozen configuration file as the output.
Both arguments are optional. The default for infile is /etc/sockd.conf; the default for outfile is /etc/sockd.fc. You may specify infile
while omitting outfile, but you cannot specify outfile without also speficying infile.
The contents of the frozen configuration file is essentially the memory image of the parsed input file. Using the frozen configuration file
can reduce the start-up delay of the SOCKS server program since it no longer has to parse the file contents.
When the SOCKS server starts, it always looks for the frozen configuration file /etc/sockd.fc first. If that file is not found, it then
tries to use the plain-text configuration file /etc/sockd.conf. If you use frozen configuration, you must remember to run make_sockdfc
every time after you modify the plain-text file or the SOCKS server will continue to use the frozen file of a previous configuration.
To find out the contents of a frozen configuration file, use dump_sockdfc.
FILES
/etc/sockd.fc, /etc/sockd.conf
SEE ALSO
dump_sockdfc(8), sockd.conf(5), sockd.fc(5)
AUTHOR
Ying-Da Lee, yingda@best.com or yingda@esd.sgi.com
May 6, 1996 MAKE_SOCKDFC(8)