Sponsored Content
Full Discussion: Insert/Update using sed
Top Forums Shell Programming and Scripting Insert/Update using sed Post 302669711 by vivek_damodaran on Thursday 12th of July 2012 05:14:44 AM
Old 07-12-2012
Sorry, I should have made it clear in my first post.

The xml itself is a big file, so unfortunately I can't try the echo option. Also the insert/update should be committed using the solution.

To re-iterate:

Code:
<Date="" Node1="50" Groups="20">

is a part of a big xml file Config.xml and I am trying to insert/update the Date field and commit the changes.

Reason for Insert/update option
1) Insert: The Date field could be blank (Date="")
2) Update: xml could already have a date in it ((Date="20120610")). So the command should replace it.


something like this
Code:
#! /bin/ksh
dt=20120701
sed -e 's/Date=.*"/Date=$dt/' Config.xml

---------- Post updated 07-12-12 at 04:14 AM ---------- Previous update was 07-11-12 at 07:42 AM ----------

Hi,

Can someone please help with my query?

Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed search and insert

how can i modify a file using sed when searching for a pattern and insert newline after the pattern? pattern example: $ ...(any characters)...$ $ may082001.../tmp/msg.001,,$ REPT CLEAR ALARMS ON UNIT 1 $ may082001.../tmp/msg.002,,$ UNIT 1 IN SERVICE into: $... (1 Reply)
Discussion started by: apalex
1 Replies

2. Shell Programming and Scripting

sed: how to insert tab?

Hi, I'm using the following to insert lines into file: sed ${rowNr}i'\ first row\ second row\ third row\ ' file.txt How can I add tab in front of each added line? "\t" or actual TAB does not seem to work? Thanks! (2 Replies)
Discussion started by: Juha
2 Replies

3. UNIX and Linux Applications

how to create a logfile in unix after insert/update/delete from informix

I am running a Informix-4GL program to insert/update/delete on a particular table (say xxx). Now I want to create a logfile in unix which will store the affected data(say xxx.*) along with user information (say uname,IP address etc.) what command I should use from Informix-4GL ? I have tried the... (0 Replies)
Discussion started by: subhamukh
0 Replies

4. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies

5. Shell Programming and Scripting

sed to insert a character

Hi all, I have a file like this Q8N302 21-84 Q8N157 15-45 Q99996 167-201 202-251 269-318 I want to insert a character or space if the line starts with a number and I used the command sed 's/^/#/' But in the output file, when it inserts this character, first digit in the number is... (2 Replies)
Discussion started by: kaav06
2 Replies

6. Shell Programming and Scripting

sed insert new line does not update file

Hi all, I have a file called "text.cpp" with the first line of "1" afterwards I tried in Ubuntu to type the following sed '12iasdasdasdasdsad' test.cpp > output.txt however when I tried to see the result of output.txt #cat output.txt 1 why is the line 12 is not updated to the... (6 Replies)
Discussion started by: peuceul
6 Replies

7. Shell Programming and Scripting

Sed: how do I insert a \ in my replace

I'm in the process of being forward-thinking and finally converting my site's db to UTF-8. I've already done the UTF-8 conversion (on a copy for testing) and now I want to go through and convert html entities to their actual characters. I ran an entity decode on a mysqldump file but realized... (10 Replies)
Discussion started by: dheian
10 Replies

8. Programming

MYSQL - trigger update on record insert or update

Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works: UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` ); So now I want this... (5 Replies)
Discussion started by: barrydocks
5 Replies

9. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies

10. Shell Programming and Scripting

Insert one table and update another with shellscript

I have a problem with my shell script. I want to insert data from file to table1(empty) and then, compare table1 with table2 and update some fields. The first part is correct, but the second part does not work. The only way it works is if after the first part I truncate table1 and run the script... (1 Reply)
Discussion started by: nika_mill
1 Replies
Date::Manip::Obj(3)					User Contributed Perl Documentation				       Date::Manip::Obj(3)

NAME
Date::Manip::Obj - Base class for Date::Manip objects SYNOPSIS
The Date::Manip::Obj class is the base class used for the following Date::Manip classes: Date::Manip::Base Date::Manip::TZ Date::Manip::Date Date::Manip::Delta Date::Manip::Recur This module is not intended to be called directly and performs no useful function by itself. Instead, use the various derived classes which inherit from it. DESCRIPTION
This module contains a set of methods used by all Date::Manip classes listed above. You should be familiar with the Date::Manip::Objects and Date::Manip::Config documentation. In the examples below, Date::Manip::Date objects will be used as examples, but (unless otherwise stated), all of the classes listed above have the same methods, and work in the same fashion. METHODS FOR CREATING OBJECTS
new $date = new Date::Manip::Date; $date = new Date::Manip::Date @opts; $date = new Date::Manip::Date $string; $date = new Date::Manip::Date $string,@opts; In order to create the first Date::Manip object, use any of the forms listed above. They will all create a new Date::Manip::Date object (with new Date::Manip::Base, and Date::Manip::TZ objects embedded in it). The Date::Manip::Date, Date::Manip::Delta, and Date::Manip::Recur classes work in exactly the same way. A set of options (described in the Date::Manip::Config documentation) can be passed to the object to set configuration variables. In addition, a string can be passed in which will be parsed to form the initial date stored in the object. Strings can also be passed in to the Date::Manip::Delta and Date::Manip::Recur objects which will be parsed to form initial values. In all cases, refer to the parse method of the class. $dmt = new Date::Manip::TZ; $dmt = new Date::Manip::TZ @opts; If the first Date::Manip object you need is a Date::Manip::TZ object, use either of the above calls. This will also create a Date::Manip::Base object which will be embedded in the Date::Manip::TZ object. A set of options can be passed in as well, but there is no option for passing in a string. $dmb = new Date::Manip::Base; $dmb = new Date::Manip::Base @opts; If you work with Date::Manip::Base objects directly, no other object will be created. The options can be passed in here as well. Once a Date::Manip::Date object (or any object in any other Date::Manip class) is created, one of calls below should be used in order to preserve cached data in the interest of performance and memory usage. $date = new Date::Manip::Date $obj; $date = new Date::Manip::Date $obj,@opts; $date = new Date::Manip::Date $obj,$string; $date = new Date::Manip::Date $obj,$string,@opts; $obj can be an object from any of the Date::Manip classes, but in the interest of making efficient use of cached data, you should pass in the highest level object available. In other words, you should always pass in a Date::Manip::Date, Date::Manip::Delta, or Date::Manip::Recur object if you have one. In their absence, pass in a Date::Manip::TZ object. Pass in a Date::Manip::Base object only if that is the only Date::Manip object available. The one caveat is if you are working with multiple configurations as described in the Date::Manip::Objects document. In that case, additional care should be taken to make sure that the correct object is passed in. If $obj is a Date::Manip::Date object, these lines can be expressed equivalently as: $date = $obj->new(); $date = $obj->new(@opts); $date = $obj->new($string); $date = $obj->new($string,@opts); If @opts is passed in, new Date::Manip::Base and Date::Manip::TZ objects will be created with the configuration specified, so you should only do this if you explicitly want to work with multiple configurations. If you want to modify an existing configuration, you must use the config method described below. new_config $obj2 = $obj1->new_config(); $obj2 = $obj1->new_config($string); $obj2 = $obj1->new_config($string,@opts); $obj2 = $obj1->new_config(@opts); This creates a new instance with a new Date::Manip::Base object and a separate set of config options (even if no config options are included). new_date new_delta new_recur $date = $obj->new_date(); $date = $obj->new_date($string); $date = $obj->new_date($string,@opts); $date = $obj->new_date(@opts); These create a new instance of the specified object. In this case, $obj can be any of the Date::Manip classes, so a date can be created from a delta: $delta = new Date::Manip::Delta; $date = $delta->new_date(); OTHER METHODS
base $dmb = $obj->base(); This returns the Date::Manip::Base object associated with the given object. config $obj->config($var1,$val1,$var2,$val2,...); This will set the value of any configuration variables. Please refer to the Date::Manip::Config manual for a list of all configuration variables and their description. err $err = $obj->err(); This will return the full error message if the previous operation failed for any reason. $obj->err(1); will clear the error code. is_date is_delta is_recur $flag = $obj->is_date(); Returns 0 or 1, depending on the object. For example, a Date::Manip::Date object returns 1 with the is_date method, and 0 for the other two. tz $dmb = $obj->tz(); This returns the Date::Manip::TZ object associated with the given object. version $vers = $obj->version($flag); This returns the version of Date::Manip. If $flag is passed in, and $obj is not a Date::Manip::Base object, the version and timezone information will be passed back. KNOWN BUGS
None known. BUGS AND QUESTIONS
Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author. SEE ALSO
Date::Manip - main module documentation LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHOR
Sullivan Beck (sbeck@cpan.org) perl v5.12.1 2010-01-12 Date::Manip::Obj(3)
All times are GMT -4. The time now is 12:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy