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

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 Dummies Questions & Answers

SED or AWK: Appending a line Identifier that changes with paragraph?

Have another question that has been eluding me all day. I have data file I'm trying to reformat so that each line is appended with an ID code, but the ID code needs to update as it searches through the file. I.e. ----Begin Original Datafile----- Condition = XXX Header Line 1 Header...

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

awk;sed appending line to previous line....

I know this has been asked before but I just can't parse the syntax as explained. I have a set of files that has user information spread out over two lines that I wish to merge into one: User1NameLast User1NameFirst User1Address E-Mail:User1email User2NameLast User2NameFirst User2Address...

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

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

7. Shell Programming and Scripting

Remove new line character and add space to convert into fixed width file

I have a file with different record length. The file as to be converted into fixed length by appending spaces at the end of record. The length should be calculated based on the record with maximum length in the file. If the length is less than the max length, the spaces should be appended...

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

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

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

LEARN ABOUT OSX

tabify

textutil::tabify(n)				    Text and string utilities, macro processing 			       textutil::tabify(n)

__________________________________________________________________________________________________________________________________________________

NAME

       textutil::tabify - Procedures to (un)tabify strings

SYNOPSIS

       package require Tcl  8.2

       package require textutil::tabify  ?0.7?

       ::textutil::tabify::tabify string ?num?

       ::textutil::tabify::tabify2 string ?num?

       ::textutil::tabify::untabify string ?num?

       ::textutil::tabify::untabify2 string ?num?

_________________________________________________________________

DESCRIPTION

       The package textutil::tabify provides commands that convert between tabulation and ordinary whitespace in strings.

       The complete set of procedures is described below.

       ::textutil::tabify::tabify string ?num?
	      Tabify  the string by replacing any substring of num space chars by a tabulation and return the result as a new string. num defaults
	      to 8.

       ::textutil::tabify::tabify2 string ?num?
	      Similar to ::textutil::tabify this command tabifies the string and returns the result as a new string. A different algorithm is used
	      however. Instead of replacing any substring of num spaces this command works more like an editor. num defaults to 8.

	      Each line of the text in string is treated as if there are tabstops every num columns. Only sequences of space characters containing
	      more than one space character and found immediately before a tabstop are replaced with tabs.

       ::textutil::tabify::untabify string ?num?
	      Untabify the string by replacing any tabulation char by a substring of num space chars and return the result as a  new  string.  num
	      defaults to 8.

       ::textutil::tabify::untabify2 string ?num?
	      Untabify	the  string  by  replacing  any  tabulation  char by a substring of at most num space chars and return the result as a new
	      string. Unlike textutil::tabify::untabify each tab is not replaced by a fixed number of space characters.  The command overlays each
	      line  in	the  string  with tabstops every num columns instead and replaces tabs with just enough space characters to reach the next
	      tabstop. This is the complement of the actions taken by ::textutil::tabify::tabify2. num defaults to 8.

	      There is one asymmetry though: A tab can be replaced with a single space, but not the other way around.

BUGS, IDEAS, FEEDBACK
       This document, and the package it describes, will undoubtedly contain bugs and other problems.  Please report such in the category textutil
       of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you may have for
       either package and/or documentation.

SEE ALSO

       regexp(n), split(n), string(n)

KEYWORDS

       formatting, string, tabstops

CATEGORY

       Text processing

textutil								0.7						       textutil::tabify(n)