Sponsored Content
Top Forums Shell Programming and Scripting Replace using awk on fixed width file. Post 302945271 by Chubler_XL on Wednesday 27th of May 2015 05:44:44 PM
Old 05-27-2015
It looks like your repl function was written to expect FROM and TO values so you should be calling it like this:

Code:
a=repl(a,478,487,"2011-01-01")


Or update repl() to use FROM and LENGTH as RudiC mentioned:

Code:
function repl(s,f,L,v)
{ return substr(s,1,f-1) sprintf("%-*s", L, v) substr(s,f+L) }


Code:
$ printf "%c" {1..9} {0..9} | awk '
function repl(s,f,L,v) { return substr(s,1,f-1) sprintf("%-*s", L, v) substr(s,f+L) }
{print repl($0,8,3,"AB") }'
1234567AB 123456789


Last edited by Chubler_XL; 05-27-2015 at 06:51 PM..
 

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 Replies)
Discussion started by: alok.benjwal
2 Replies

2. 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... (10 Replies)
Discussion started by: tamahomekarasu
10 Replies

3. 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... (10 Replies)
Discussion started by: Cho Nagurai
10 Replies

4. 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 Replies)
Discussion started by: tamahomekarasu
6 Replies

5. Shell Programming and Scripting

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

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

To replace the value of the column in a fixed width file

I have a fixed with file with header & trailer length having the same length of the detail record file. The details record length of this file is 24, for Header and Trailer the records will be padded with spaces to match the record length of the file Currently I am adding 3 spaces in header... (14 Replies)
Discussion started by: ginrkf
14 Replies

7. 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. ... (5 Replies)
Discussion started by: deepakwins
5 Replies

8. 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... (5 Replies)
Discussion started by: kcdg859
5 Replies

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"... (8 Replies)
Discussion started by: pchang
8 Replies

10. Shell Programming and Scripting

Search and replace value based on certain conditions in a fixed width file

Hi Forum. I tried searching for a solution using the internet search but I haven't been able to find any solution for what I'm trying to accomplish. I have a fixed width column file where I need to search for any occurrences of "D0" in col pos.#1-2, 10-11, 20-21 and replaced it with "XD". ... (2 Replies)
Discussion started by: pchang
2 Replies
SISC(1) 						      General Commands Manual							   SISC(1)

NAME
sisc - Second Interpreter of Scheme Code SYNOPSIS
sisc [ option ... ] [ argument ... [ -- [ program-option ... ] ] DESCRIPTION
SISC, the Second Interpreter of Scheme Code, is an extensible Java based interpreter of the Scheme language as described in the Revised^5 Report on the Algorithmic Language Scheme and adds numerous extensions including Java integration. STARTUP FILE AND EXPRESSION OPTIONS
-c name --call-with-args name Calls the top-level procedure name with the remaining command-line arguments after the -- delimiter. -e expr --eval expr Evaluates the provided expression. -x --no-repl Instructs SISC to run the command line and then exit without entering the REPL. -h heap-file --heap heap-file Specifies that heap-file should be used as the initial heap image. -p config-file --properties config-file Specifies a Java property file that contains application properties. -l [<host>:]<port> --listen [<host>:]<port> Server Mode. Listen on <host>/<port> for REPL connections. COMMAND LINE BEHAVIOR
The commandline is processed in the following manner. First, the entire command line is processed, noting the settings of each switch and accumulating all Scheme source files and arguments after the end of options sequence. Second, the heap file is loaded. Third, each Scheme source file is loaded in the order they occured on the command line. Errors are noted. Fourth, if present, the expression in an --eval switch is evaluated. Errors are noted. Fifth, if present, named function in a --call-with-args switch is applied to the arguments after the end of options sequence. Its return value is noted. Sixth, --no-repl was not specified, the REPL is invoked. Finally, if the REPL was run if its return value is an integer, that integer is returned as SISC's overall return code. If the REPL was not run, and any return code supporting step above was run, the most recent return code is returned. If no return code step was performed, but a success/failure step was performed, 1 is returned if any failures occured, 0 otherwise. EXECUTABLE SCRIPTS
SISC supports all the required SRFI-22 bootstraps, consult the body of SRFI-22 for more information about using it to write executable Scheme programs. MORE INFORMATION
For further information on SISC, please read the SISC for Seasoned Schemers manual available at http://sisc.sourceforge.net/manual/ BUGS
Submit bug reports to the SISC Users Mailing List. AUTHOR
SISC was created by Scott G. Miller (sgmiller@gmail.com) with significant contribution from Matthias Radestock (matthias@sorted.org). 4th Berkeley Distribution June 2005 SISC(1)
All times are GMT -4. The time now is 02:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy