First and foremost thanks for looking into this .My requirement is to modify the following in an input file
1> change the directory in attribute Output file directory to a parameterized directory.
2> strip of any directory from the attribute output filename if the filename is prefixed with path , and just retain the filename along with extension
3> change the directory in attribute Log filename and keep the filename as is.
4> all of the above can be present multiple times in a file , and modification needs to be done for multiple files.
I was trying to achieve this step by step, hence you could have felt a change in requirement. I also realized that by mistake I have given a / in the filename , this is a mistake and there is no / after the filename. I apologize for the inconvenience /confusion caused by this.
my sample input data file looks like
Code:
<SESSION>
<SESSIONEXTENSION>
<CONNECTIONREFERENCE CNXREFNAME ="Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="" VARIABLE =""/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="\data\targetfiledirectory\"/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="\thirdparty\targetfiledirectory\"/>
<ATTRIBUTE NAME ="Output filename" VALUE ="\data\targetfiledirectory\\target1.csv"/>
<ATTRIBUTE NAME ="Log filename" VALUE ="/data/logfiledirectory\log1.log"/>
<ATTRIBUTE NAME ="Command" VALUE =""/>
<ATTRIBUTE NAME ="File Reader Truncate String Null" VALUE ="NO"/>
<ATTRIBUTE NAME ="Codepage Parameter" VALUE =""/>
</SESSIONEXTENSION>
<SESSIONEXTENSION>
<CONNECTIONREFERENCE CNXREFNAME ="Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="" VARIABLE =""/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="/data/targetfiledirectory"/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="/$Thirdparty"/>
<ATTRIBUTE NAME ="Output filename" VALUE ="/$Thirdparty\target2"/>
<ATTRIBUTE NAME ="Log filename" VALUE ="/data/logfiledirectory\log2.log"/>
<ATTRIBUTE NAME ="Command" VALUE =""/>
<ATTRIBUTE NAME ="File Reader Truncate String Null" VALUE ="NO"/>
<ATTRIBUTE NAME ="Codepage Parameter" VALUE =""/>
</SESSIONEXTENSION>
</SESSION>
this is my desired output
Code:
<SESSION>
<SESSIONEXTENSION>
<CONNECTIONREFERENCE CNXREFNAME ="Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="" VARIABLE =""/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="$Outputfiledirectory\folder1"/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="$Outputfiledirectory\folder1"/>
<ATTRIBUTE NAME ="Output filename" VALUE ="target1.csv"/>
<ATTRIBUTE NAME ="Log filename" VALUE ="$logfiledirectory\log1.log"/>
<ATTRIBUTE NAME ="Command" VALUE =""/>
<ATTRIBUTE NAME ="File Reader Truncate String Null" VALUE ="NO"/>
<ATTRIBUTE NAME ="Codepage Parameter" VALUE =""/>
</SESSIONEXTENSION>
<SESSIONEXTENSION>
<CONNECTIONREFERENCE CNXREFNAME ="Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="" VARIABLE =""/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="$Outputfiledirectory\folder1"/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="$Outputfiledirectory\folder1"/>
<ATTRIBUTE NAME ="Output filename" VALUE ="/$Thirdparty.target2"/>
<ATTRIBUTE NAME ="Log filename" VALUE ="$logfiledirectory\log2.log"/>
<ATTRIBUTE NAME ="Command" VALUE =""/>
<ATTRIBUTE NAME ="File Reader Truncate String Null" VALUE ="NO"/>
<ATTRIBUTE NAME ="Codepage Parameter" VALUE =""/>
</SESSIONEXTENSION>
</SESSION>
thanks in advance.
Last edited by ajmani; 03-09-2015 at 11:45 PM..
Reason: correcting typo errors
I want to change the false in Node 1 to true. How do I do that?
<Node1>
<Usage>false</Usage>
<Url>ABC</Url>
</Node1>
<Node2>
<Usage>false</Usage>
<Url>DEF<Url>
</Node2> (8 Replies)
its again sed question. i have line -
sed "s/$old/$new/g" "$f" > $TFILE && mv $TFILE "$f"
working well if
old="myoldfile"
new="mynewfile"
but if i want
old="/home/shailesh/1test/"
new="/home/shailesh/workspace/"
it gives error like
sed: -e expression #1, char 9: unknown option to... (2 Replies)
Hello,
I was looking around, but could not find the answer, so I hope you ppl can help me.
I want simply to replace text.:rolleyes:
I found out SED would be good for this task.:b:
So I tried: :confused:
1.) find text in a line and replace this particular line:
for finding... (3 Replies)
Hi,
I have a text file and I would like to replace all occurrences of single quote ' with two consecutive single quotes '' .
I have tried sed s/\'/\'\'/ < Folder/outputFile.txt > Folder/otherFile.txt but this replaces only the first occurrence of ' with ''. I want it to replace all the single... (7 Replies)
My need is :
Want to change
docBase="/something/something/something"
to
docBase="/only/this/path/for/all/files"
I have some (about 250 files)xml files.
In FileOne it contains
<Context path="/PPP" displayName="PPP" docBase="/home/me/documents" reloadable="true" crossContext="true">... (1 Reply)
hi
my input file has got
>,,,, or >, or >,,,,,,
there are independent number of commas after >....
i want the o/p as > only that is just to remove "," after">"
another is:
i want to replace the last line of the file and to replace it by "hello"...how to do?...
any nice script
plz help (2 Replies)
hi Guys,
I have a rar file which consists of 10 files. each file has a space in its file name.
how can i replace all spaces with _
i can replace them using sed but the thing is i need to replace using a script and not command.
can anyone help me out??:confused: (2 Replies)
Data not replacing using sed,please check below.
Replace_value=$$dbconn_target
Search_value=$$dbcon_source
sed -e s/\${Search_value}/\${Replace_value}/g intrepid_sps_val.parm (2 Replies)
Hi all,
I am trying to change the below word. but the changes is not reflecting in the new file
sed -n 's/apple/orange/' filename
---------- Post updated at 12:51 AM ---------- Previous update was at 12:41 AM ----------
I tried this it works
perl -pi.bak -e... (9 Replies)