I'm trying to create a csv file by running awk and sed on a number of xml files in a directory; I'm using this below:
The issue I have is that I can't write and deploy a shell script onto the box I'm running the above commands on (not allowed basically - insane I know) so I'm having to run the whole of the above as a 1 liner in the terminal when logging onto the box by seperating commands with ';'. This is returning the info I want in the following format:
but I need to generate a csv file in the following format:
is there a way to get the above format by extending the what I have already?
I'm trying to merge multiple CSV (comma separated value) files into one large master file. All files have a field that is unique to act as the key for entry/merging into the master file & and all files have the same number of fields that are in the master file.
I'll give an example here:
... (2 Replies)
Hi I am Newbie to Unix.Appreciate Help from forum
user would loada b.Csv File(Below example) in /data/m/ directory.Program need to read the b.csc to extract certain column and create a new file /data/d/ directory as csv file with new name.
User File Format
1232,samshouston,12345... (3 Replies)
Hi All
I am trying to create a csv file in the korn shell and the script segment is as follows:
if
then
# NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP
echo "$drive $percent% $space "|\
awk '{printf("%d/t"|"%d/t"|"%d/t\n",... (6 Replies)
Hello,
I've been tasked with sending 3 types of data (file size, row count, and file name) to a csv file every month for various vendors. I have been asked to put this in one csv or xls file with each vendor being a different tab (or worksheet). Until now, we have been finding and emailing... (4 Replies)
I have a requirement which will select the files with a specific naming convention which got created in past 7 days in a specific directory.Lets say the directory is /data/XYZ and the file names follow the below nomenclature like Daily_File*.txt
I just need to create one CSV file which will... (12 Replies)
I've googled a lot on this, but could not fine a simple one-liner to do this.
I have a .csv file that looks like this:
Header one
Header two
Header three
col1,col2,col3
short data, very long data, dataIf I use sed and change the comma to tab, being the colums of variable length I don't get a... (6 Replies)
I have the following simplified script, that consists of a download (wget), a grab of only the lines with a comma (grep) and a rename of the file to indicate its date of origin (mv):
wget http://www.example.com/datafile.csv
grep ',' datafile.csv
mv datafile.csv datafile.`date... (2 Replies)
Hi Gurus,
I need your help in transforming the CSV file into some what a report format.
My source file looks like below
Date,ProdID,TimeID,LevelID
2010-08-31,200,M,1
2010-08-31,201,Q,2
2010-08-31,202,Y,1
2010-08-31,203,M,5
Output required is
... (9 Replies)
Hi guys,
I am not experienced with Unix, so please dont mind if the question seem to be irrelevant.
I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail.
-I stored the query o/p in a file.
-I... (6 Replies)
I have a flat file that contains dynamic list of variables like
a=1
b=2
c=3
.
..
z=26
I need to convert the above into a csv file having the format below:
a,b,c,..,z
1,2,3,..,26
Please note, I do not want a comma separating the last variable.
I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies
LEARN ABOUT DEBIAN
stag-splitter
STAG-SPLITTER(1p) User Contributed Perl Documentation STAG-SPLITTER(1p)NAME
stag-splitter - splits a stag file into multiple files
SYNOPSIS
stag-splitter -split person -name social_security_no file.xml
DESCRIPTION
Splits a file using a user specified parser (default xml) around a specified split node, naming each file according to the name argument
the files will be named anonymously, unless the '-name' switch is specified; this will use the value of the specified element as the
filename
eg; if we have
<top>
<a>
<b>foo</b>
<c>yah</c>
<d>
<e>xxx</e>
</d>
</a>
<a>
<b>bar</b>
<d>
<e>wibble</e>
</d>
</a>
</top>
if we run
stag-splitter -split a -name b
it will generate two files, "foo.xml" and "bar.xml"
input format can be 'xml', 'sxpr' or 'itext' - if this is left blank the format will be guessed from the file suffix
the output format defaults to the same as the input format, but another can be chosen.
files go in the current directory, but this can be overridden with the '-dir' switch
USAGE
stag-splitter [-split <ELEMENT-NAME>] [-name <ELEMENT-NAME>] [-dir <DIR>] [-format <INPUT-FORMAT>] [-outformat <OUTPUT-FORMAT>] <FILENAMES>
-p|parser FORMAT
FORMAT is one of xml, sxpr or itext, or the name of a perl module
xml assumed as default
-w|writer FORMAT
FORMAT is one of xml, sxpr or itext, or the name of a perl module
-split|s NODE
node to split on
-name|n NODE
field/element to use when naming files
will use surrogate IDs if this argument not specified
-dir|d DIR
write files to this directory
perl v5.10.0 2008-12-23 STAG-SPLITTER(1p)