Didn't you "need it to turn it into an XML file for each row"? Try
Code:
awk -v FS="," '
FNR == 1 {split (tolower($0), tags)
next
}
{print "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" > $1
print "<!DOCTYPE properties SYSTEM \"http://java.sun.com/dtd/properties.dtd\">" > $1
print "\t<properties>" > $1
CM = "cm:"
for (i=2; i<=NF; i++) {printf ("\t\t<entry key=\"%s%s\">%s</entry>\n", CM, tags[i], $i) > $1
if (i == 4) CM = ""
}
print "\t</properties>" > $1
}
' file
and check the result files. Your first post was not quite consistent with "birthdate" and "birthday". Your sample file in post #3 has a comma separator too few.
I have a csv file, which is > 2 Gigs. I need to BCP that file to Sybase db , but I cant upload that b'caz first row of the file is failing. ( having some errors probably.) I can manually insert the first line into db & then I can upload the rest of the data in file, if i can delete the first row.
... (2 Replies)
Hi ,
I've a perl script to convert .xls to .csv .After conversion I want to delete first 28 and the last row from .csv file.Is there any efficent way to achive this both together.
I'm deleting first 28 rows by using folllowing my perl code:
exec " tail -n+28 infile.csv > outfile.csv
... (7 Replies)
Hi All,
I am having an XML tag like:
<detail sim_ser_no_1="898407109001000090"
imsi_1="452070001000090">
<security>ADM1=????</security>
<security>PIN1=????</security>
<security>PIN2=????</security>
... (2 Replies)
Hi Guys,
I am new to Shell scripting and need to convert an XML files to a CSV file.
My actual problem is that XML file loading is taking hours and I have decided to convert the XML structure to row based data in a CSV file.
My XML file: Message846 can repeat within main loop and... (1 Reply)
I need to create a xml file(master.xml) with contents from another xml files(children). I have below list of xml files in a temporary location (C:/temp/xmls)
1. child1.xml
2. child2.xml
Below is the content of the child1.xml & child2.xml files,
child1.xml
<root>
<emp>
... (3 Replies)
Hi friend i have input as following XML file
<?xml version="1.0"?>
<Document xmlns="urn:iso:std:iso:20022:tech:xsd:camt.054.001.02">
<BkToCstmrDbtCdtNtfctn>
<GrpHdr><MsgId>LBP-RDJ-TE000000-130042430010001001</MsgId><CreDtTm>2013-01-04T03:21:30</CreDtTm></GrpHdr>... (3 Replies)
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
we have a CSV which i need to convert to XML using Perl or Unix shell scripting.
I was able to build this XML in oracle database. However, SQL/XML query is running for long time. Hence, I'm considering to write a Perl or shell script to generate this XML file. Basically need to build this XML... (3 Replies)
I have a csv file like below.
john,r2,testdomain1,john.r2@hex.com,DOMAINADMIN,testdomain1.dom
maxwell,b2, testdomain1,maxwell.b2@hex.com,DOMAINADMIN,testdomain1.dom
I would need the perl script to read the above csv and create an xml like below.
<Users>
... (1 Reply)
Hi,
I have to find the count of rows starting with "E," in given a.csv file .
Sample Data File.
E,2333AED,A,MC3,25,31-MAY-18
E,2333AED,A,MC3,25,31-MAY-18
CYMC3 25AED 0000
E,2333CZK,A,MC3,25,31-MAY-18
CYMC3 25CZK 0000
E,2333EUR,A,MC3,25,31-MAY-18... (3 Replies)
Discussion started by: Prabhakar Y
3 Replies
LEARN ABOUT OPENSOLARIS
print-service
print-service(1M) System Administration Commands print-service(1M)NAME
print-service - select, report, import, export active print service on a system
SYNOPSIS
print-service [-s service [-m] | -q | -e file | -i file]
DESCRIPTION
The print-service utility manages print service selection, as well as export and import of basic print queue configuration.
Only a user root privileges or with the Printer Management profile can change the active print service or import print queue configuration.
OPTIONS
The following options are supported:
-s service
Select the active print service for on a host. service can be one of lp or cups.
-m
Migrate print queue configuration during print service selection.
-q
Report the active print service on a host.
-e file
Export basic print queue configuration to a file.
-i file
Import basic print queue configuration from a file.
EXAMPLES
Example 1 Selecting a Print Service
The following command selects the CUPS print service as the active print service on a host.
# print-service -s cups
Example 2 Reporting the Active Print Service
The following command reports the active print service on a host.
# print-service -q
Example 3 Exporting a Print Queue Configuration
The following command exports the print queue configuration from the active print service.
# print-service -e /tmp/queues
Example 4 Importing a Print Queue Configuration
The following command imports the print queue configuration to the active print service.
# print-service -i /tmp/queues
EXIT STATUS
0
Successful completion.
non-zero
An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWpcu |
+-----------------------------+-----------------------------+
|Interface Stability |Obsolete |
+-----------------------------+-----------------------------+
SEE ALSO intro(1), attributes(5)NOTES
The print queue configuration saved and restored during export, import, and migration is limited to queue name and device name. It is
likely that further configuration changes will be required before imported or migrated print queues become usable.
SunOS 5.11 18 Mar 2008 print-service(1M)