Fixed width file with newline field separators

10 More Discussions You Might Find Interesting

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

2. UNIX for Dummies Questions & Answers

Replace the unexpected newline char with space in a Fixed width file

Input eg: Ouput Expected. The #rd line had the unexpted new line, which need to be replaced with space. I was planing to go with checking the length of each line using awk and if the length is less than the defeined limit, (12 in above case) will replace the newline with space. ...

3. UNIX for Dummies Questions & Answers

Length of a fixed width file

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

4. Shell Programming and Scripting

Fixed width file comparision not working

when i used diff/cmp/cat -v commands i am getting the difference cmp command cmp -l file1 file2 |head -1 1300 15 10 Manually checked records. record length and data matched. diff file1 file2 3C3 <record information Manually checked records. record length and data matched....

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

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

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

8. Shell Programming and Scripting

Changing particular field in fixed width file

I have a fixed width file and i need to change 36th field to "G" in for about random 20 records? How can I do it?

9. UNIX for Advanced & Expert Users

Converting field into fixed width csv

Hi I have a file having record as - 1,aaa,a123,a I need this converted to as 2nd col to 5 chars wide & 3rd col to 6chars wide such as - 1,aaa ,a123 ,a How we could achieve this? Thx in advance.

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

LEARN ABOUT DEBIAN

dbfdump

SHAPELIB(1)							   User Commands						       SHAPELIB(1)

NAME

       dbfdump - dump xBase DBF files as text

SYNOPSIS

       dbfdump [-h] [-m] [-r] file

DESCRIPTION

       Dumps  the contents of file to standard output.	The first line contains the field names appearing in file, and each of the following lines
       contains the field values of a record.  Field names and values are padded by spaces to their field widths.  Empty fields are printed as the
       string "(NULL)".

OPTIONS

       -h     Prints the column field definitions before other output.	Each field definition consists of a line of the form

	      Field: index, Type=type, Title=`name', Width=width, Decimals=precision

	      where  index  is the zero offset column number of the field; the type indicates the datatype of the field value and is either "Inte-
	      ger", "Real" or "String"; name is the field's name; width is the number of bytes reserved for the field's value;	and  precision	is
	      the number of decimal places of precision for "Real" type fields, and is zero for "Integer" and "String" type fields.

       -m     Prints  each  record in multiline format separated by empty lines.  The first line of a record gives the number of the record in the
	      form

	      Records: record_index

	      where record_index is the zero offset number of the record in the file, and then each field of the record appears on its own line in
	      the format

	      name: value

       -r     Prints the exact bytes occurring in file for field values and suppresses printing "(NULL)" for empty values.

EXIT STATUS

       0      Successful program execution.

       1      Missing file argument.

       2      Failed to open file.

       3      There are no fields in file.

DIAGNOSTICS

       The following diagnostics may be issued on stdout:

       DBFOpen(file,"r") failed.

       There are no fields in this table!

AUTHORS

       Frank  Warmerdam (warmerdam@pobox.com) is the maintainer of the shapelib shapefile library.  Joonas Pihlaja (jpihlaja@cc.helsinki.fi) wrote
       this man page.

BUGS

       Unless the -r option is given, values in numeric fields that overflow the int or double types of the C language	are  printed  as  plus	or
       minus a huge number.  For integer fields the huge value is HUGE_VALL from <stdlib.h> and for real fields it is HUGE_VALF.

SEE ALSO

       dbf_dump(1), dbfcreate(1), dbfadd(1), shpadd(1), shpcreate(1), shpdump(1), shprewind(1)

shapelib							   OCTOBER 2004 						       SHAPELIB(1)

Shell Programming and Scripting