Sponsored Content
Top Forums Shell Programming and Scripting Splitting CSV into variables then to XML file Post 303001087 by jeffs42885 on Wednesday 26th of July 2017 11:40:15 AM
Old 07-26-2017
Splitting CSV into variables then to XML file

I have a text file that looks like this:
Code:
 
  
 FIELD1, FIELD2, THIS IS FIELD3, FIELD4
 FIELD1, FIELD2, THIS IS FIELD3, FIELD4
 FIELD1, FIELD2, THIS IS FIELD3, FIELD4


I need it to turn it into an XML file to run against a custom application. My ultimate goal is for it to look like this:

Code:
 
 <FIRSTFIELD="FIELD1">
   <task="update" name="FIELD2">
      <field3="FIELD3" task="add" field4="FIELD4" />

Here is what I have tried and it doesn't seem to be parsing the input file properly, or forming the XML. Could it be because of the spaces in field3?

Code:
for i in `cat input.txt`
do
 field1=`echo $i | cut -d"|" -f1`
 field2=`echo $i | cut -|"," -f2`
 field3=`echo $i | cut -d"|" -f3`
 field4=`echo $i | cut -d"|" -f4`
 
echo <FIRSTFIELD="FIELD1"> >> out.xml
echo  <task="update" name="FIELD2"> >> out.xml
echo  <field3="FIELD3" task="add" field4="FIELD4" /> >> out.xml 
done

Help is appreciated
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

splitting a file (xml) into multiple files

To split the files Hi, I'm having a xml file with multiple xml header. so i want to split the file into multiple files. Test.xml --------- <?xml version="UTF_8"> <emp: ....> <name>a</name> <age>10</age> </emp> <?xml version="UTF_8"> <emp: ....> <name>b</name> <age>10</age>... (11 Replies)
Discussion started by: sasi_u
11 Replies

2. UNIX for Advanced & Expert Users

Splitting the single csv file

Hi, I have a requiement where in i will get a single file but there will be mutiple headers. Suppose say for eg: Header1 Data... Data... Header2 Data.. Data.. Header3 Data.. Data.. I want to split each with the corresponding data into a single file. Please let me know how... (1 Reply)
Discussion started by: weknowd
1 Replies

3. Shell Programming and Scripting

Help required in Splitting a xml file into multiple and appending it in another .xml file

HI All, I have to split a xml file into multiple xml files and append it in another .xml file. for example below is a sample xml and using shell script i have to split it into three xml files and append all the three xmls in a .xml file. Can some one help plz. eg: <?xml version="1.0"?>... (4 Replies)
Discussion started by: ganesan kulasek
4 Replies

4. Shell Programming and Scripting

Splitting input CSV file into 3 files

Hi , I am receiving a CSV file that can vary in number of rows each time. I am supposed to split this file into 3 separate files like this: 1. create a file named 'File1.csv' that will contain first 3 rows of the input file 2. create file named 'File2.csv' that will contain last 3 rows of the... (7 Replies)
Discussion started by: kedrick
7 Replies

5. Shell Programming and Scripting

Splitting XML file on basis of line number into multiple file

Hi All, I have more than half million lines of XML file , wanted to split in four files in a such a way that top 7 lines should be present in each file on top and bottom line of should be present in each file at bottom. from the 8th line actual record starts and each record contains 15 lines... (14 Replies)
Discussion started by: ajju
14 Replies

6. Shell Programming and Scripting

Splitting xml file into several xml files using perl

Hi Everyone, I'm new here and I was checking this old post: /shell-programming-and-scripting/180669-splitting-file-into-several-smaller-files-using-perl.html (cannot paste link because of lack of points) I need to do something like this but understand very little of perl. I also check... (4 Replies)
Discussion started by: mcosta
4 Replies

7. Shell Programming and Scripting

Splitting a single xml file into multiple xml files

Hi, I'm having a xml file with multiple xml header. so i want to split the file into multiple files. Sample.xml consists multiple headers so how can we split these multiple headers into multiple files in unix. eg : <?xml version="1.0" encoding="UTF-8"?> <ml:individual... (3 Replies)
Discussion started by: Narendra921631
3 Replies

8. Shell Programming and Scripting

Splitting csv into 3 tables in html file

I have the data in csv in 3 tables. how can I output the same into 3 tables in html.also how can I set the width. tried multiple options . attached is the format. #!/bin/ksh awk 'BEGIN{ FS="," print "<HTML><BODY><TABLE border = '1' cellpadding=10 width=100>" print... (7 Replies)
Discussion started by: archana25
7 Replies

9. Shell Programming and Scripting

Splitting the XML file into three different files

Hello Shell Guru's I have a requirement to split the source xml file into three different text file. And i need your valuable suggestion to finish this. Here is my source xml snippet, here i am using only one entry of <jms-system-resource>. There may be multiple entries in the source file. ... (5 Replies)
Discussion started by: Siv51427882
5 Replies

10. UNIX for Beginners Questions & Answers

Splitting the XML file and renaming the files

Hello Gurus, I have a requirement to split the xml file into different xml files. Can you please help me with that? Here is my Source XML file <jms-system-resource> <name>PS6SOAJMSModule</name> <target>soa_server1</target> <sub-deployment> ... (3 Replies)
Discussion started by: Siv51427882
3 Replies
Jifty::Client(3pm)					User Contributed Perl Documentation					Jifty::Client(3pm)

NAME
Jifty::Client - Subclass of WWW::Mechanize with extra Jifty features DESCRIPTION
This module is a base for building robots to interact with Jifty applications. It currently contains much overlapping code with "Jifty::Test::WWW::Mechanize", except that it does not inherit from "Test::WWW::Mechanize". Expect this code to be refactored in the near future. METHODS
new Overrides WWW::Mechanize's "new" to automatically give the bot a cookie jar. moniker_for ACTION, FIELD1 => VALUE1, FIELD2 => VALUE2 Finds the moniker of the first action of type ACTION whose "constructor" field FIELD1 is VALUE1, and so on. fill_in_action MONIKER, FIELD1 => VALUE1, FIELD2 => VALUE2, ... Finds the fields on the current page with the names FIELD1, FIELD2, etc in the MONIKER action, and fills them in. Returns the HTML::Form object of the form that the action is in, or undef if it can't find all the fields. action_form MONIKER [ARGUMENTNAMES] Returns the form (as an HTML::Form object) corresponding to the given moniker (which also contains inputs for the given argumentnames), and also selects it as the current form. Returns undef if it can't be found. action_field_value MONIKER, FIELD Finds the fields on the current page with the names FIELD in the action MONIKER, and returns its value, or undef if it can't be found. send_action CLASS ARGUMENT => VALUE, [ ... ] Sends a request to the server via the webservices API, and returns the Jifty::Result of the action. "CLASS" specifies the class of the action, and all parameters thereafter supply argument keys and values. The URI of the page is unchanged after this; this is accomplished by using the "back button" after making the webservice request. fragment_request PATH ARGUMENT => VALUE, [ ... ] Makes a request for the fragment at PATH, using the webservices API, and returns the string of the result. field_error_text MONIKER, FIELD Finds the error span on the current page for the name FIELD in the action MONIKER, and returns the text (tags stripped) from it. (If the field can't be found, return undef). uri WWW::Mechanize has a bug where it returns the wrong value for "uri" after redirect. This fixes that. See http://rt.cpan.org/NoAuth/Bug.html?id=9059 session Returns the server-side Jifty::Web::Session object associated with this Mechanize object. continuation [ID] Returns the current continuation of the Mechanize object, if any. Or, given an ID, returns the continuation with that ID. current_user Returns the Jifty::CurrentUser object or descendant, if any. SEE ALSO
Jifty::Test::WWW::Mechanize LICENSE
Jifty is Copyright 2005-2010 Best Practical Solutions, LLC. Jifty is distributed under the same terms as Perl itself. perl v5.14.2 2011-04-14 Jifty::Client(3pm)
All times are GMT -4. The time now is 08:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy