Splitting CSV into variables then to XML file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Splitting CSV into variables then to XML file
# 8  
Old 07-26-2017
remove spaces in front of closing EOF label
# 9  
Old 07-26-2017
Code:
 
 #!/bin/ksh
  
 while IFS=, read f1 f2 f3 f4
do
cat < EOF
        <applicationGroup name="${f1}">
        <field task="update" name="${f2}">
        <mapping dbvalue="${f4}" task="add" displayedValue="${f3}" />
EOF
done < input.txt > out.xml

Code:
./2.ksh[5]: syntax error at line 9 : `newline or ;' unexpected

# 10  
Old 07-26-2017
cat << EOF
# 11  
Old 07-26-2017
Code:
 
 ./2.ksh[3]: syntax error at line 5 : `<' unmatched

# 12  
Old 07-26-2017
cat <<EOF
# 13  
Old 07-26-2017
Along the same lines, but without a here-document (and IMHO a lot easier to read and to maintain, but that might be personal bias):

Code:
 
#!/bin/ksh

exec 3>/path/to/outfile    # to overwrite the file
# exec 3>>/path/to/outfile # instead, to append to the file
  
while IFS=, read f1 f2 f3 f4 ; do
     print -u3 - "<applicationGroup name=\"${f1}\">"
     print -u3 - "     <field task=\"update\" name=\"${f2}\">"
     print -u3 - "          <mapping dbvalue=\"${f4}\" task=\"add\" displayedValue=\"${f3}\" />"
done < input.txt

exec 3>&-

I hope this helps.

bakunin
# 14  
Old 07-27-2017
I tried the above solution and it does not output anything into my output file which Im assuming is defined in

Code:
  exec 3>


Last edited by bakunin; 07-27-2017 at 01:32 PM.. Reason: accidentally edited this post, sorry.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question