KSH - help needed for creating a script to generate xml file from text file
Dear Members,
I have a table in Oracle DB and one of its column name is INFO which has data in text format which we need to fetch in a script and create an xml file of a new table from the input.
The contents of a single cell of INFO column is like:
So, we have to take the contents of this cell as input to the script and create an xml file from it in the following format:
I see that in the above xml many tags are constant (like ColAuditData) and such a format can be repeated, but how are we supposed to add new column values for table and the subsequent values within tags.
Also, if we already have such an XML file created, how can we parse till the end of the file and add a new column if the need arises?
I am an amateur in scripting and will require a lot of help from you talented members.
Please help me understand the script too so that I can tweak it as and when the need arises.
Hello,
I have a excel file which has almost ten columns on the shared drive. I have to write a shell script to ftp that daily to unix server and then extract some columns from there and generate oracle standard text file. The columns should be in proper order and aligned properly, otherwise... (1 Reply)
Hi All,
My requirement is create an unix script to parse the xml file and display the values of the Elements/value between the tags on console. Like say, I would like to fetch the value of errorCode from the below xml which is 'U007' and display it. Can we use SED command for this? I have tried... (10 Replies)
FILE-1
USER username@foo.com
TOOLIN tool-a
TOOL2 tool-b
TOOL3 tool-c
TOOL4 tool-d
TOOL5 tool-e
USER username_2@foo.com
TOOLIN tool-e
TOOL2 tool-f
TOOL3 tool-c
TOOL4 tool-d
....
I need to take this file and generate a target XML file -
<access>
<managed>
... (3 Replies)
Hello Members,
I have to create a script to parse a text file in the following format:
Increment By:1
Max Value:999999
Related Table: Dummy_table
Related Table Column: dummy_id
Sequence Name: dummy_table_1SQ
Start With:1
and create an xml file from the above text file using KSH... (4 Replies)
hi all i want a script to FTP a file and should generate a quality checksum file
means when I FTP a file from one server to another server it should generate a QC file which should contain timestamp,no.of records in that file
Thanks in advance
saikumar (3 Replies)
need a shell script for the following requirement
how to generate 5 versions of a file in a folder
after generating them in a folder i want to maintian the past 2 versions of the file in the folder and i have to delete the the remaining.
for example if i ran the script today and tommorow... (3 Replies)
Hello Team,
I have 2 files.one contains english text and another contains Japanese. so i have to read english text and replace the text with Japanesh text in third file.
Basically, I need a help to write japanese language in text/xml file.I heard wstring does this.Not sure how do i write... (2 Replies)