Insert values into template Post: 302974961

Sponsored Content

Top Forums Shell Programming and Scripting Insert values into template Post 302974961 by RudiC on Monday 6th of June 2016 03:08:42 PM

06-06-2016

Registered User

Not too sophisticated, but may pass for a zeroth approach:

Code:

awk '
NR==FNR         {T[NR] = $0
                 MX = NR   
                 next   
                }

                {X = T[2]
                 Y = T[3]
                 Z = T[4]
                 sub ("]\[", "]" $2 " " $3 "[", X)
                 sub ("]\[", "]" $4 " " $5 "[", Y)
                 sub (/""/, "\"" $1 "\"",  Z)
                 print T[1]
                 print X
                 print Y
                 print Z   
                 print T[5]
                }
' file2 file1
[TYPE]SELECT[/TYPE]
[BEGIN]06/05/2016 10:00:00[/BEGIN]
[END]06/05/2016 05:08:59[/END]
[SECTION]NAME = "SERVER1"[/SECTION]
[VALUE]DEATILS[/VALUE]
[TYPE]SELECT[/TYPE]
[BEGIN]06/04/2016 09:50:00[/BEGIN]
[END]06/05/2016 01:03:59[/END]
[SECTION]NAME = "SERVER2"[/SECTION]
[VALUE]DEATILS[/VALUE]
[TYPE]SELECT[/TYPE]
[BEGIN]06/06/2016 11:26:00[/BEGIN]
[END]06/06/2016 10:31:55[/END]
[SECTION]NAME = "SERVER3"[/SECTION]
[VALUE]DEATILS[/VALUE]

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

insert pipe in file to separate values

hi all... i need your help, because i don�t know what to do... i have a flat file like this: B065200512312004123111010000061451 000021853 B065200512312004123111020000621907 000417802 B065200512312004123111030000005214 000005861 B065200512312004123111040000120133 000088448 and i need...

2. Shell Programming and Scripting

hw to insert array values sequentially in a file

Hi All :), I am very new to unix. I am requiring ur help in developing shell script for below problem. I have to replace the second field of file with values of array sequentially where first field is ValidateKeepVar <File> UT-ExtractField 1 | &LogEntry &Keep(DatatoValidate)...

3. Shell Programming and Scripting

insert values into sqlplus database using shell script

hello all, I am new to shell scripting and to unix... so the following is my assignment.. here i am trying to insert a values into sqlplus database using shell script. the following is my shell script InsertDelete.sh #! /bin/sh echo "*********The MENU******** 1.Insert The Values...

4. Shell Programming and Scripting

Insert Inverted Commas Around Numeric Values

Hi, I am trying to insert Inverted Commas around all the numeric values within a comma seperated string / variable. 1111,2222,3333,4444 I would like it to be: '1111','2222','3333','4444' Note - This string could have a differing amount of numeric values each time the variable is...

5. Shell Programming and Scripting

Insert values

HI Guys, I have a data in a file in the below format 45783 23457 23556 54584 Now i want to convert this data into the below format reader='45783' or reader='23457' or reader='23556' or reader='54584' Please help how to convert as i am applying loop but not able to get the data...

6. Shell Programming and Scripting

insert dummy values in a file

Hey guys, i have a file a.txt and i need to insert a dummy data into it as per the below pattern.. bash: cat a.txt 1234,34 3434,45 4545,56 3434,56 Now i need the file in the below pattern 1234,34,a0001,C_01 3434,45,a0002,C_02 4545,56,a0003,C_03 3434,56,a0004,C_04 here the count of...

7. Shell Programming and Scripting

Insert strings/values between text

Hello Guru, I'm trying to insert a value between 2 fields (between last and second last field) But end up the script actually replacing the value in the second last field. What should i put to fix the problem? Input File: apple,mango,grape,lemonExpected output: apple,mango,grape,0,lemon awk...

8. Shell Programming and Scripting

Insert bulk values in DB table using isql

Hello, Objective is to insert bulk values in DB table using isql. Following code tried: isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt cat file.txt for i in `cat data_value_file.txt` do insert into tempdb..temp_table11 values ('$i') go done cat...

9. Shell Programming and Scripting

Insert missing values

Hi, please help with this, I need to insert missing values into a matrix for a regression analysis. I have made up an example. The first three columns are variables with levels and the next 3 are values, the 4th column missing values should be replaced by 0s, and 5th and 6th column missing...

10. Shell Programming and Scripting

Insert values into a file 0 as per the date wise

LEARN ABOUT SUSE

end

END(7)								   SQL Commands 							    END(7)

NAME

       END - commit the current transaction

SYNOPSIS

       END [ WORK | TRANSACTION ]

DESCRIPTION

       END  commits  the  current  transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
       crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT [commit(7)].

PARAMETERS

       WORK

       TRANSACTION
	      Optional key words. They have no effect.

NOTES

       Use ROLLBACK [rollback(7)] to abort a transaction.

       Issuing END when not inside a transaction does no harm, but it will provoke a warning message.

EXAMPLES

       To commit the current transaction and make all changes permanent:

       END;

COMPATIBILITY

       END is a PostgreSQL extension that provides functionality equivalent to COMMIT [commit(7)], which is specified in the SQL standard.

SEE ALSO

       BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)]

SQL - Language Statements					    2010-05-14								    END(7)