Sponsored Content
Full Discussion: Manipulating a file
Top Forums Shell Programming and Scripting Manipulating a file Post 302429523 by jim mcnamara on Monday 14th of June 2010 05:11:58 PM
Old 06-14-2010
Code:
awk 'BEGIN {quote=0} 
     
      $1~/^VAL/{
                quote=1; 
                printf( "%s ", $0)
                next
               }
      quote {if ($0 ~ /"$/)
             {
                gsub(/"$/, ""); 
                gsub(/^ /, "");
                printf("%s\n", $1)
                quote=0;
                print "                       {[404], [10]}| {[405], [10]}| {[406], [10]}| {[407], [10]}| {[408], [10]}|"
                printf("                       {[409], [10]}| {[410], [10]}| {[411], [10]}| {[412], [10]}| {[413], [10]}%c\n", 34);
             } 
             else 
             {
               printf("%s ", $1)
             }
             next
            }
       ! quote {print}     
     '  filename

 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Manipulating output file

I have a file containing two fields, Name and Time, with about 57 lines in this file. I am struggling to create a loop that will cut out the first ten lines of this file and echo it to the screen. Can anybody help me please. (1 Reply)
Discussion started by: mariner
1 Replies

2. Shell Programming and Scripting

Manipulating a text file

hey guys, need ur expert help. m a core banker got stuck in someting techie and cant find a solution have manged to extract a file from oracle apps in a format that looks something like this... REC- A b c d x INV- A b... (6 Replies)
Discussion started by: komalkg
6 Replies

3. Solaris

Manipulating File

Help...please. I have a log that contains Warning Authentication Failed: User GHDT88998HS doesn't exit: The User GHDT88998HS could not be found Mar 22, 2008 5:22:22AM com.hometel.ttm.auth.userlogin. about maybe a thousand entries failed user acct message How can I grab just the username... (2 Replies)
Discussion started by: rivendell500
2 Replies

4. UNIX for Dummies Questions & Answers

Help!! manipulating file

Hi all, I need help manipulating the file below. Here is what I needed to do. First, I have to replace INSUPD to DELETE. Then I need to change the content of the file around by flipping the contents in the file from the bottom to the top (start from "CMD") How should I attack this? Here... (2 Replies)
Discussion started by: sirrtuan
2 Replies

5. Shell Programming and Scripting

parsing a file and manipulating the contents

Hi I have a text file as follows BOB 14/14 TOM 94/94 SAM 3/3 CRIS 13/13 TOM 6/6 CRIS 27/27 SAM 2/2 JACK 25/25 CRIS (6 Replies)
Discussion started by: shellignorant
6 Replies

6. Shell Programming and Scripting

Manipulating the etc/passwd file with sed

How can i use sed to extract the user name and home directory from the /etc/passwd/ file on my server. (11 Replies)
Discussion started by: Pauline mugisha
11 Replies

7. Shell Programming and Scripting

Help Manipulating Large Csv File

Hello everyone, I am trying to manipulate a large .csv file where I have output similar to the following - http://imgur.com/TEXD8.png The result that I am looking for would be to consolidate the first column, but combine the second and third column so it still relates to the first. I... (8 Replies)
Discussion started by: xxwohxx
8 Replies

8. Shell Programming and Scripting

Manipulating csv file

We need to convert a field in a csv file which is in cents to dollars.(divide by 100) in our shell script. Can some body help me? (3 Replies)
Discussion started by: Deepthz
3 Replies

9. Shell Programming and Scripting

need help on manipulating a file

Hi, I need a shell/command to achieve this task. I've a delimited unloaded file from oracle in a scrambled format as shown below with many blank lines in it, I'm just trying to tailor it in a format that would be compatible to view and load it to a IDS db. Here is the problem ... (1 Reply)
Discussion started by: divak
1 Replies

10. Shell Programming and Scripting

Manipulating column in a file in UNIX

Hi I have a file content.txt where I want to replace the value of second column of the file with half of the value of that column. I only have to replace if the second column starts with COM_, rest all values have to be same eg, cat content.txt |COM_A|123|JHV|8475 |ABC|2765|BV|876... (7 Replies)
Discussion started by: infyanurag
7 Replies
DB2_ESCAPE_STRING(3)							 1						      DB2_ESCAPE_STRING(3)

db2_escape_string - Used to escape certain characters

SYNOPSIS
string db2_escape_string (string $string_literal) DESCRIPTION
Prepends backslashes to special characters in the string argument. PARAMETERS
o $string_literal - The string that contains special characters that need to be modified. Characters that are prepended with a backslash are x00, , , , ', " and x1a. RETURN VALUES
Returns $string_literal with the special characters noted above prepended with backslashes. EXAMPLES
Example #1 A db2_escape_string(3) example Result of using the db2_escape_string(3) function <?php $conn = db2_connect($database, $user, $password); if ($conn) { $str[0] = "All characters: x00 , , , , ' , " , x1a ."; $str[1] = "Backslash (). Single quote ('). Double quote (")"; $str[2] = "The NULL character must be quoted as well"; $str[3] = "Intersting characters: x1a , x00 ."; $str[4] = "Nothing to quote"; $str[5] = 200676; $str[6] = ""; foreach( $str as $string ) { echo "db2_escape_string: " . db2_escape_string($string). " "; } } ?> The above example will output: db2_escape_string: All characters: , , , \ , ' , " ,  . db2_escape_string: Backslash (\). Single quote ('). Double quote (") db2_escape_string: The NULL character must be quoted as well db2_escape_string: Intersting characters:  , . db2_escape_string: Nothing to quote db2_escape_string: 200676 db2_escape_string: SEE ALSO
db2_prepare(3). PHP Documentation Group DB2_ESCAPE_STRING(3)
All times are GMT -4. The time now is 06:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy