Sponsored Content
Top Forums Shell Programming and Scripting To replace the value of the column in a fixed width file Post 302839793 by ginrkf on Saturday 3rd of August 2013 01:48:08 AM
Old 08-03-2013
Thanks a lot.Its working fine.

if possible can you please tell me how to replace only the header & trailer of the file rest of the records need to be the same

---------- Post updated 08-03-13 at 12:48 AM ---------- Previous update was 08-02-13 at 07:17 PM ----------

Code:
sed 's/\(.\{1\}\)../\1yyy/'

This command is actually replacing the value of all the records in the file.But I need to replace the value of header & trailer only .Please some one help here
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparing column of variable length anf fixed width file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8... (5 Replies)
Discussion started by: manneni prakash
5 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

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 Replies)
Discussion started by: manneni prakash
5 Replies

4. UNIX for Dummies Questions & Answers

Remove duplicates based on a column in fixed width file

Hi, How to output the duplicate record to another file. We say the record is duplicate based on a column whose position is from 2 and its length is 11 characters. The file is a fixed width file. ex of Record: DTYU12333567opert tjhi kkklTRG9012 The data in bold is the key on which... (1 Reply)
Discussion started by: Qwerty123
1 Replies

5. Shell Programming and Scripting

How to split a fixed width text file into several ones based on a column value?

Hi, I have a fixed width text file without any header row. One of the columns contains a date in YYYYMMDD format. If the original file contains 3 dates, I want my shell script to split the file into 3 small files with data for each date. I am a newbie and need help doing this. (14 Replies)
Discussion started by: bhanja_trinanja
14 Replies

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

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

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 {... (3 Replies)
Discussion started by: pinnacle
3 Replies

9. 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
GIT-INTERPRET-TRAI(1)						    Git Manual						     GIT-INTERPRET-TRAI(1)

NAME
       git-interpret-trailers - add or parse structured information in commit messages

SYNOPSIS
       git interpret-trailers [options] [(--trailer <token>[(=|:)<value>])...] [<file>...]
       git interpret-trailers [options] [--parse] [<file>...]

DESCRIPTION
       Help parsing or adding trailers lines, that look similar to RFC 822 e-mail headers, at the end of the otherwise free-form part of a commit
       message.

       This command reads some patches or commit messages from either the <file> arguments or the standard input if no <file> is specified. If
       --parse is specified, the output consists of the parsed trailers.

       Otherwise, this command applies the arguments passed using the --trailer option, if any, to the commit message part of each input file. The
       result is emitted on the standard output.

       Some configuration variables control the way the --trailer arguments are applied to each commit message and the way any existing trailer in
       the commit message is changed. They also make it possible to automatically add some trailers.

       By default, a <token>=<value> or <token>:<value> argument given using --trailer will be appended after the existing trailers only if the
       last trailer has a different (<token>, <value>) pair (or if there is no existing trailer). The <token> and <value> parts will be trimmed to
       remove starting and trailing whitespace, and the resulting trimmed <token> and <value> will appear in the message like this:

	   token: value

       This means that the trimmed <token> and <value> will be separated by ': ' (one colon followed by one space).

       By default the new trailer will appear at the end of all the existing trailers. If there is no existing trailer, the new trailer will
       appear after the commit message part of the output, and, if there is no line with only spaces at the end of the commit message part, one
       blank line will be added before the new trailer.

       Existing trailers are extracted from the input message by looking for a group of one or more lines that (i) is all trailers, or (ii)
       contains at least one Git-generated or user-configured trailer and consists of at least 25% trailers. The group must be preceded by one or
       more empty (or whitespace-only) lines. The group must either be at the end of the message or be the last non-whitespace lines before a line
       that starts with ---. Such three minus signs start the patch part of the message.

       When reading trailers, there can be whitespaces after the token, the separator and the value. There can also be whitespaces inside the
       token and the value. The value may be split over multiple lines with each subsequent line starting with whitespace, like the "folding" in
       RFC 822.

       Note that trailers do not follow and are not intended to follow many rules for RFC 822 headers. For example they do not follow the encoding
       rules and probably many other rules.

OPTIONS
       --in-place
	   Edit the files in place.

       --trim-empty
	   If the <value> part of any trailer contains only whitespace, the whole trailer will be removed from the resulting message. This applies
	   to existing trailers as well as new trailers.

       --trailer <token>[(=|:)<value>]
	   Specify a (<token>, <value>) pair that should be applied as a trailer to the input messages. See the description of this command.

       --where <placement>, --no-where
	   Specify where all new trailers will be added. A setting provided with --where overrides all configuration variables and applies to all
	   --trailer options until the next occurrence of --where or --no-where.

       --if-exists <action>, --no-if-exists
	   Specify what action will be performed when there is already at least one trailer with the same <token> in the message. A setting
	   provided with --if-exists overrides all configuration variables and applies to all --trailer options until the next occurrence of
	   --if-exists or --no-if-exists.

       --if-missing <action>, --no-if-missing
	   Specify what action will be performed when there is no other trailer with the same <token> in the message. A setting provided with
	   --if-missing overrides all configuration variables and applies to all --trailer options until the next occurrence of --if-missing or
	   --no-if-missing.

       --only-trailers
	   Output only the trailers, not any other parts of the input.

       --only-input
	   Output only trailers that exist in the input; do not add any from the command-line or by following configured trailer.*  rules.

       --unfold
	   Remove any whitespace-continuation in trailers, so that each trailer appears on a line by itself with its full content.

       --parse
	   A convenience alias for --only-trailers --only-input --unfold.

CONFIGURATION VARIABLES
       trailer.separators
	   This option tells which characters are recognized as trailer separators. By default only : is recognized as a trailer separator, except
	   that = is always accepted on the command line for compatibility with other git commands.

	   The first character given by this option will be the default character used when another separator is not specified in the config for
	   this trailer.

	   For example, if the value for this option is "%=$", then only lines using the format <token><sep><value> with <sep> containing %, = or
	   $ and then spaces will be considered trailers. And % will be the default separator used, so by default trailers will appear like:
	   <token>% <value> (one percent sign and one space will appear between the token and the value).

       trailer.where
	   This option tells where a new trailer will be added.

	   This can be end, which is the default, start, after or before.

	   If it is end, then each new trailer will appear at the end of the existing trailers.

	   If it is start, then each new trailer will appear at the start, instead of the end, of the existing trailers.

	   If it is after, then each new trailer will appear just after the last trailer with the same <token>.

	   If it is before, then each new trailer will appear just before the first trailer with the same <token>.

       trailer.ifexists
	   This option makes it possible to choose what action will be performed when there is already at least one trailer with the same <token>
	   in the message.

	   The valid values for this option are: addIfDifferentNeighbor (this is the default), addIfDifferent, add, replace or doNothing.

	   With addIfDifferentNeighbor, a new trailer will be added only if no trailer with the same (<token>, <value>) pair is above or below the
	   line where the new trailer will be added.

	   With addIfDifferent, a new trailer will be added only if no trailer with the same (<token>, <value>) pair is already in the message.

	   With add, a new trailer will be added, even if some trailers with the same (<token>, <value>) pair are already in the message.

	   With replace, an existing trailer with the same <token> will be deleted and the new trailer will be added. The deleted trailer will be
	   the closest one (with the same <token>) to the place where the new one will be added.

	   With doNothing, nothing will be done; that is no new trailer will be added if there is already one with the same <token> in the
	   message.

       trailer.ifmissing
	   This option makes it possible to choose what action will be performed when there is not yet any trailer with the same <token> in the
	   message.

	   The valid values for this option are: add (this is the default) and doNothing.

	   With add, a new trailer will be added.

	   With doNothing, nothing will be done.

       trailer.<token>.key
	   This key will be used instead of <token> in the trailer. At the end of this key, a separator can appear and then some space characters.
	   By default the only valid separator is :, but this can be changed using the trailer.separators config variable.

	   If there is a separator, then the key will be used instead of both the <token> and the default separator when adding the trailer.

       trailer.<token>.where
	   This option takes the same values as the trailer.where configuration variable and it overrides what is specified by that option for
	   trailers with the specified <token>.

       trailer.<token>.ifexists
	   This option takes the same values as the trailer.ifexists configuration variable and it overrides what is specified by that option for
	   trailers with the specified <token>.

       trailer.<token>.ifmissing
	   This option takes the same values as the trailer.ifmissing configuration variable and it overrides what is specified by that option for
	   trailers with the specified <token>.

       trailer.<token>.command
	   This option can be used to specify a shell command that will be called to automatically add or modify a trailer with the specified
	   <token>.

	   When this option is specified, the behavior is as if a special <token>=<value> argument were added at the beginning of the command
	   line, where <value> is taken to be the standard output of the specified command with any leading and trailing whitespace trimmed off.

	   If the command contains the $ARG string, this string will be replaced with the <value> part of an existing trailer with the same
	   <token>, if any, before the command is launched.

	   If some <token>=<value> arguments are also passed on the command line, when a trailer.<token>.command is configured, the command will
	   also be executed for each of these arguments. And the <value> part of these arguments, if any, will be used to replace the $ARG string
	   in the command.

EXAMPLES
       o   Configure a sign trailer with a Signed-off-by key, and then add two of these trailers to a message:

	       $ git config trailer.sign.key "Signed-off-by"
	       $ cat msg.txt
	       subject

	       message
	       $ cat msg.txt | git interpret-trailers --trailer 'sign: Alice <alice@example.com>' --trailer 'sign: Bob <bob@example.com>'
	       subject

	       message

	       Signed-off-by: Alice <alice@example.com>
	       Signed-off-by: Bob <bob@example.com>

       o   Use the --in-place option to edit a message file in place:

	       $ cat msg.txt
	       subject

	       message

	       Signed-off-by: Bob <bob@example.com>
	       $ git interpret-trailers --trailer 'Acked-by: Alice <alice@example.com>' --in-place msg.txt
	       $ cat msg.txt
	       subject

	       message

	       Signed-off-by: Bob <bob@example.com>
	       Acked-by: Alice <alice@example.com>

       o   Extract the last commit as a patch, and add a Cc and a Reviewed-by trailer to it:

	       $ git format-patch -1
	       0001-foo.patch
	       $ git interpret-trailers --trailer 'Cc: Alice <alice@example.com>' --trailer 'Reviewed-by: Bob <bob@example.com>' 0001-foo.patch >0001-bar.patch

       o   Configure a sign trailer with a command to automatically add a 'Signed-off-by: ' with the author information only if there is no
	   'Signed-off-by: ' already, and show how it works:

	       $ git config trailer.sign.key "Signed-off-by: "
	       $ git config trailer.sign.ifmissing add
	       $ git config trailer.sign.ifexists doNothing
	       $ git config trailer.sign.command 'echo "$(git config user.name) <$(git config user.email)>"'
	       $ git interpret-trailers <<EOF
	       > EOF

	       Signed-off-by: Bob <bob@example.com>
	       $ git interpret-trailers <<EOF
	       > Signed-off-by: Alice <alice@example.com>
	       > EOF

	       Signed-off-by: Alice <alice@example.com>

       o   Configure a fix trailer with a key that contains a # and no space after this character, and show how it works:

	       $ git config trailer.separators ":#"
	       $ git config trailer.fix.key "Fix #"
	       $ echo "subject" | git interpret-trailers --trailer fix=42
	       subject

	       Fix #42

       o   Configure a see trailer with a command to show the subject of a commit that is related, and show how it works:

	       $ git config trailer.see.key "See-also: "
	       $ git config trailer.see.ifExists "replace"
	       $ git config trailer.see.ifMissing "doNothing"
	       $ git config trailer.see.command "git log -1 --oneline --format="%h (%s)" --abbrev-commit --abbrev=14 $ARG"
	       $ git interpret-trailers <<EOF
	       > subject
	       >
	       > message
	       >
	       > see: HEAD~2
	       > EOF
	       subject

	       message

	       See-also: fe3187489d69c4 (subject of related commit)

       o   Configure a commit template with some trailers with empty values (using sed to show and keep the trailing spaces at the end of the
	   trailers), then configure a commit-msg hook that uses git interpret-trailers to remove trailers with empty values and to add a
	   git-version trailer:

	       $ sed -e 's/ Z$/ /' >commit_template.txt <<EOF
	       > ***subject***
	       >
	       > ***message***
	       >
	       > Fixes: Z
	       > Cc: Z
	       > Reviewed-by: Z
	       > Signed-off-by: Z
	       > EOF
	       $ git config commit.template commit_template.txt
	       $ cat >.git/hooks/commit-msg <<EOF
	       > #!/bin/sh
	       > git interpret-trailers --trim-empty --trailer "git-version: $(git describe)" "$1" > "$1.new"
	       > mv "$1.new" "$1"
	       > EOF
	       $ chmod +x .git/hooks/commit-msg

SEE ALSO
       git-commit(1), git-format-patch(1), git-config(1)

GIT
       Part of the git(1) suite

Git 2.17.1							    10/05/2018						     GIT-INTERPRET-TRAI(1)
All times are GMT -4. The time now is 07:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy