awk: creating a fixed-width single file from 2 different files Post: 302398254

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

edit entire column from a fixed-width file using awk or sed

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

4. Shell Programming and Scripting

Fixed Width Join & Pad Sed/Awk Help

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

5. Shell Programming and Scripting

Appending string (charachters inside the line) to a fixed width file using awk or sed

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

7. Shell Programming and Scripting

Print column details from fixed width file using awk command

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

8. Shell Programming and Scripting

Replace using awk on fixed width file.

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

9. Shell Programming and Scripting

awk issue splitting a fixed-width file containing line feed in data

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

10. Shell Programming and Scripting

Joining fixed width files

Hi All, I need to join fixed width files on a column which is position 1 to 3 and need to have all the records from file1 file1.txt Cu1nullL1L2 Cu2nullL1L2 Cu3nullL1L2 file2.txt Cu1B1B2 Cu3B1B2 output.txt Cu1L1B1L2B2 Cu2L1L2 Cu3L1B1L2B3 I tried but not getting the expected...

LEARN ABOUT SUNOS

cachefslog

cachefslog(1M)						  System Administration Commands					    cachefslog(1M)

NAME

       cachefslog - Cache File System logging

SYNOPSIS

       cachefslog [-f logfile | -h]  cachefs_mount_point

DESCRIPTION

       The  cachefslog	command displays where CacheFS statistics are being logged. Optionally, it sets where CacheFS statistics are being logged,
       or it halts logging for a cache specified by cachefs_mount_point. The cachefs_mount_point argument is a mount point of a cache file system.
       All file systems cached under the same cache as cachefs_mount_point will be logged.

OPTIONS

       The following options are supported. You must be super-user to use the -f and -h options.

       -f logfile      Specify the log file to be used.

       -h	       Halt logging.

OPERANDS

       cachefs_mount_point     A mount point of a cache file system.

USAGE

       See largefile(5) for the description of the behavior of cachefslog when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes).

EXAMPLES

       Example 1: Checking the Logging of a directory.

       The example below checks if the directory /home/sam is being logged:

       example% cachefslog /home/sam
       not logged: /home/sam

       Example 2: Changing the logfile.

       The example below changes the logfile of  /home/sam to /var/tmp/samlog:

       example# cachefslog -f /var/tmp/samlog /home/sam
       /var/tmp/samlog: /home/sam

       Example 3: Verifying the change of a logfile.

       The example below verifies the change of the previous example:

       example% cachefslog /home/sam
       /var/tmp/samlog: /home/sam

       Example 4: Halting the logging of a directory.

       The example below halts logging for the /home/sam directory:

       example# cachefslog -h /home/sam
       not logged: /home/sam

EXIT STATUS

       The following exit values are returned:

       0	       success

       non-zero        an error has occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       cachefsstat(1M), cachefswssize(1M), cfsadmin(1M), attributes(5), largefile(5)

DIAGNOSTICS

       Invalid path    It is illegal to specify a path within a cache file system.

SunOS 5.10							    7 Feb 1997							    cachefslog(1M)