Changing particular field in fixed width file Post: 302166343

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

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

4. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12...

5. Shell Programming and Scripting

Fixed width file with newline field separators

I have some huge files that are produced daily from a production system written in basic (really). The files are fixed width records, 512 bytes, with newline field separators, newlines if the field is null, and trailing newlines for null fields. The data in the fields can be any ascii...

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

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

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

10. Answers to Frequently Asked Questions

Fixed width file issue and resolutions

I have a fixed width file with no separators , but the file has JUNK characters in it and i know how to remove it. but in few cases these junk characters having created a mess by splitting single row into 2 or 3 rows. I need to put them back to a single line like rest of the rows. This fixed...

LEARN ABOUT DEBIAN

dnroute

DNROUTE(8)						      System Manager's Manual							DNROUTE(8)

NAME

       dnroute - DECnet Routing Daemon

SYNOPSIS

       dnroute [options]
       Options:
       [-dvV2Dtnhr]

DESCRIPTION

       dnroute is a daemon that manages the DECnet routing tables to provide a simple
	but probably useful routing policy.
       dnroute	listens  for  incoming	routing  messages  and	adds routes in the kernel for non-local areas that it sees. Routes will be modifed
       according to these messages so that the lowest cost route that is up will always be used. Routes to locally accessible nodes (it  those	in
       the  neighbour  table)  will  also  be  added.	If you want to keep manual control of the route to a particular area, then add a line into
       dnroute.conf. eg:
       manual 26
       will disable dnroute's setting of routing tables for that area. dnetinfo will still show the route that would have been set with (M) on the
       line to show it has been overidden.
       To  implement  its  routing  policies  dnroute  assumes	that  all  interfaces  on the system have a cost of 4. To change this add lines in
       /etc/dnroute.conf for each of the interfaces you need to change. eg
       eth0 6
       eth1 8
       tap0 10
       A script called dnetinfo is provided that gets the routing information from dnroute and displays it on stdout in a format  similar  to  the
       VMS command SHOW NET/OLD.

OPTIONS

       -d     Don't fork and run the background. Use this for debugging.

       -v     Verbose. Log route changes to syslog.

       -D     Debug log. Writes debugging information to stderr. Only useful with -d.

       -h -?  Displays help for using the command.

       -r     Send DECnet routing messages showing the state of local nodes.

       -2     Send DECnet level 2 (area) routing messages. Implies -r.

       -t <secs>
	      Timer to send routing messages on. Defaults to 15 seconds.

       -n     Do not set up routes or send routing messages, just monitor the network. Useful for testing.

       -V     Show the version of dnroute.

SEE ALSO

       dnetd.conf(5), ip(8)

DECnet utilities						   March 30 2006							DNROUTE(8)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Fixed Width file using AWK

Discussion started by: alok.benjwal

2. UNIX for Advanced & Expert Users

Converting field into fixed width csv

Discussion started by: videsh77

3. UNIX Desktop Questions & Answers

Help with Fixed width File Parsing

Discussion started by: sate911

4. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Discussion started by: manneni prakash