Length of a fixed width file Post: 302823145

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Length of a fixed width file Post 302823145 by Don Cragun on Wednesday 19th of June 2013 01:54:44 AM

06-19-2013

Registered User

Quote:

Originally Posted by Amrutha24

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.

Code:

 
awk '{print length;exit}' <File_name>

The above code gives me length 50.

Code:

 
wc -L <File_name>

The above code gives me length 53.

Please clarify on the above.

According to the standards, the awk command given should print the number of characters in the 1st line in the file (not counting the trailing newline). But, some buggy versions (including Mac OS X's awk) of awk print the number of bytes instead of the number of characters.

The meaning of wc -L is not defined by the standards and the man pages I've seen that include this options say that -L gives the length of the longest line, but does not specify the units (bytes, characters, etc.), but with wc i'd expect that the count includes the terminating newline character.

When you say you have a fixed width file of length 53, it isn't clear whether you mean each line in the file is 53 bytes, 53 characters, 53 32-bit integers, etc., or a file that is a single line of 53 bytes, characters, ... If your input is encoded using UTF-8, 53 characters could take 53 to 313 bytes. Without knowing the actual contents of your input file, the encoding used to store characters in the file, what characters are contained in the file, the meaning of wc's -L option on your system, whether awk's length on your system counts bytes of characters, and what locale is being used when running the above commands; there isn't much we can do to diagnose what is going on in your specific case.

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

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...

2. UNIX Desktop Questions & Answers

Help with Fixed width File Parsing

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...

3. Shell Programming and Scripting

Combining Two fixed width columns to a variable length file

Hi, I have two files. File1: File1 contains two fixed width columns ID of 15 characters length and Name is of 100 characters length. ID Name 1-43<<11 spaces>>Swapna<<94 spaces>> 1-234<<10 spaces>>Mani<<96 spaces>> 1-3456<<9 spaces>>Kapil<<95 spaces>> File2: ...

4. Shell Programming and Scripting

Comparing column of variable length anf fixed width file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8...

5. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know?

6. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected...

7. Shell Programming and Scripting

Fixed-Width file from Oracle

Hi All, I have created a script which generates FIXED-WIDTH file by executing Oracle query. SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe...

8. Shell Programming and Scripting

Manupulating Records in a fixed width file

I am trying to determine what would be a fast and simple way to manipulate data that comes in a fixed width format. This data has 6 segments within a record. Each record needs to written out with a header and the 6 segments. Based on the value in column #6 the fields will be defined accordingly....

9. Shell Programming and Scripting

Comparing two fixed width file

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. Shell Programming and Scripting

Alter Fixed Width File

Thank u so much .Its working fine as expected. ---------- Post updated at 03:41 PM ---------- Previous update was at 01:46 PM ---------- I need one more help. I have another file(fixed length) that will get negative value (ex:-00000000003000) in postion (98 - 112) then i have to...

LEARN ABOUT MOJAVE

ttk_image

ttk_image(n)							 Tk Themed Widget						      ttk_image(n)

__________________________________________________________________________________________________________________________________________________

NAME

       ttk_image - Define an element based on an image

SYNOPSIS

       ttk::style element create name image imageSpec ?options?
_________________________________________________________________

DESCRIPTION

       The  image  element  factory creates a new element in the current theme whose visual appearance is determined by Tk images.  imageSpec is a
       list of one or more elements.  The first element is the default image name.  The rest of the list is a sequence of statespec / value  pairs
       specifying other images to use when the element is in a particular state or combination of states.

OPTIONS

       Valid options are:

       -border padding
	      padding  is a list of up to four integers, specifying the left, top, right, and bottom borders, respectively.  See IMAGE STRETCHING,
	      below.

       -height height
	      Specifies a minimum height for the element.  If less than zero, the base image's height is used as a default.

       -padding padding
	      Specifies the element's interior padding.  Defaults to -border if not specified.

       -sticky spec
	      Specifies how the image is placed within the final parcel.  spec contains zero or more characters "n", "s", "w", or "e".

       -width width
	      Specifies a minimum width for the element.  If less than zero, the base image's width is used as a default.

IMAGE STRETCHING

       If the element's allocated parcel is larger than the image, the image will be placed in the parcel based on the	-sticky  option.   If  the
       image  needs to stretch horizontally (i.e., -sticky ew) or vertically (-sticky ns), subregions of the image are replicated to fill the par-
       cel based on the -border option.  The -border divides the image into 9 regions: four fixed corners, top and left edges (which may be  tiled
       horizontally), left and right edges (which may be tiled vertically), and the central area (which may be tiled in both directions).

EXAMPLE

	      set img1 [image create photo -file button.png]
	      set img2 [image create photo -file button-pressed.png]
	      set img3 [image create photo -file button-active.png]
	      style element create Button.button image 
		  [list $img1  pressed $img2  active $img3] 
		  -border {2 4} -sticky we

SEE ALSO

       ttk::intro(n), ttk::style(n), ttk_vsapi(n), image(n), photo(n)

KEYWORDS

       style, theme, appearance, pixmap theme, image

Tk									8.5							      ttk_image(n)