Sponsored Content
Top Forums UNIX for Beginners Questions & Answers How to preserve the same text and modify the same text to append? Post 303039462 by Scrutinizer on Sunday 6th of October 2019 03:53:00 AM
Old 10-06-2019
Hi, try:

Code:
awk '
  /SELECT *LISTAGG/ {
    printf "--ignore begin\n%s\n--ignore end\n\n", $0
    gsub(/LISTAGG[^)]*\)/,"CountMannuArray(&)")
  }
  {
    print
  }
' RS= ORS='\n\n' file

This only works if there are really no spaces on the empty lines that separate the SELECT statements.

Last edited by Scrutinizer; 10-06-2019 at 05:25 AM..
This User Gave Thanks to Scrutinizer For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Modify a text or xml file

Hi all, I want to write a shell which would allow me to edit a text file or a xml file. Basically i want to add a new node in a existing xml file. The values for this new node are based on user input. Thanks in advance Zing (9 Replies)
Discussion started by: zing
9 Replies

2. Shell Programming and Scripting

Modify Specific Line of a Text File

Given a text file, how do you add a line of text after a specific line number? I believe I would want to use "sed" but I am unsure of the syntax. Thank you. Mike (5 Replies)
Discussion started by: msb65
5 Replies

3. Shell Programming and Scripting

how preserve the content of the text box

I have used get method in my form and retrieving the content of text box in $value using: $buffer = $ENV{'QUERY_STRING'}; ($name,$value)=split(/=/,$buffer); Now I want to preserve my text box: I had tried: print "<form action='/cgi-bin/abcd.cgiv' method='get'>"; print "<input... (7 Replies)
Discussion started by: therockravi
7 Replies

4. UNIX for Dummies Questions & Answers

Modify Text File

Hi, I would like to remove any lines from a text file that begin with #, or that are blank. How can I do that with BASH? Mike (3 Replies)
Discussion started by: msb65
3 Replies

5. Shell Programming and Scripting

Modify text file using shell script

Hi, I have a text file which is following format - COL VAL ABC 1 ABC 2 ABC 3 ABC 4 ABC 5 My requirement is to search for a particular value (provided by user) in the file and comment the previous entries including that as well. E.g. If I search for number 3, then the output... (6 Replies)
Discussion started by: bhupinder08
6 Replies

6. Shell Programming and Scripting

Modify the text file by script

Hi All the Helpers! I have a text file which looks like input.txt.I would request to please suggest me how can I make this file look like output.txt input.txt VOP 111 0 1 2 DEM 111 0 222 333 444 555 879 888 987 888 989 VOP 118 0... (2 Replies)
Discussion started by: Indra2011
2 Replies

7. Shell Programming and Scripting

Use sed to append text to filenames if text not already present

I have some html with hrefs that contain local links to pdf filenames. These filenames should have standardised names, i.e. there should be a label prior to the ".pdf" filename suffix. There can be many of these links on a single line of text and some may already have the label. For example ... (13 Replies)
Discussion started by: adb
13 Replies

8. Shell Programming and Scripting

Modify one line in a plain text file

Hi everyone, I want to know, if there is a way to modify one line in a text file with unix script, with out re-writing all the file. For example, i have this file: CONFIGURATION_1=XXXX CONFIGURATION_2=YYYY CONFIGURATION_3=ZZZZ supose i have a command or function "modify" that... (7 Replies)
Discussion started by: Xedrox
7 Replies

9. Shell Programming and Scripting

Modify text file using awk

I have text file with lines as shown here. Each row has 11 columns separated by tab. In each row, i want to split the 8th column such that the output should look like shown below. Here value in the 9th column is DP value and in the 10th column is MQ value followed by the values after resource.EFF=.... (15 Replies)
Discussion started by: mehar
15 Replies

10. Shell Programming and Scripting

Modify text file using sed

Hello all, I have some text files I need to do the following on: Delete banner page (lines 1-56) --I am doing this using sed Remove ^M --I am doing this using vi Remove trailer page --this can vary based on the contents of the file, it usually starts with *************************** I am... (5 Replies)
Discussion started by: jeffs42885
5 Replies
ANNO(1) 							     [nmh-1.5]								   ANNO(1)

NAME
anno - annotate messages SYNOPSIS
anno [+folder] [msgs] [-component field] [-inplace | -noinplace] [-date | -nodate] [-draft] [-append] [-list] [-delete] [-number [num|all]] [-preserve | -nopreserve] [-version] [-help] [-text body] DESCRIPTION
Anno manipulates header fields or annotations in messages. Header fields consist of a field name and an optional field body as defined by RFC-2822. The -component option specifies the field name, and the -text option specifies the field body. The messages are either the msgs in the named folder, or the draft if invoked with the -draft option. Usually, annotation is performed by the commands dist, forw, and repl, if they are given the -anno switch. This allows you to keep track of your distribution of, forwarding of, and replies to a message. By using anno, you can perform arbitrary annotations of your own. Each message selected will be annotated with the lines field: date field: body The -nodate switch inhibits the date annotation, leaving only the body annotation. By default, anno prepends the annotations to the message. Annotations are instead appended if the -append option is specified. If a -component field is not specified when anno is invoked, anno will prompt the user for the name of field for the annotation. The field specified must be a valid 2822-style message field name, which means that it may only consist of alphanumerics and dashes, The body specified is arbitrary text. Normally anno does the annotation inplace in order to preserve any links to the message. You may change this by using the -noinplace switch. The -list option produces a listing of the field bodies for header fields with names matching the specified component, one per line. The listing is numbered, starting at 1, if the -number option is also used. A tab character separates the number and the field body. The field body is treated as if it is a file name, and only the final path name component is listed. The complete field body is listed if the -text option is used, the contents of the text are ignored. The -delete option removes header fields from messages. The first header field whose name matches the component is deleted if no other options are specified. If the -text option is used in conjunction with the -delete option, the first header field whose name matches the component and whose body matches the text is deleted. The text is treated as if it was a file name; if it begins with a slash, the entire field body must match the text, otherwise just the last path name component of the field body must match. If the -number option is used in conjuction with the -delete option, header field num whose name matches the component is deleted. The number matches that which is pro- duced by the -list option. The special value all can be used for the number, and causes all components that match the name to be deleted. By default, anno changes the last-accessed and last-modified times on annotate messages to the time at which the annotation occurs. Anno preserves the original times if the -preserve option is used. A matching -nopreserve option exists that allows time preservation to be turned off if enabled in the profile. FILES
$HOME/.mh_profile The user profile PROFILE COMPONENTS
Path: To determine the user's nmh directory Current-Folder: To find the default current folder SEE ALSO
dist(1), forw(1), repl(1) DEFAULTS
`+folder' defaults to the current folder `msgs' defaults to cur `-inplace' `-date' CONTEXT
If a folder is given, it will become the current folder. The first message annotated will become the current message. MH.6.8 11 June 2012 ANNO(1)
All times are GMT -4. The time now is 08:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy