03-14-2017
That's because your file has two j151 entries in each record, and, as said, each drags along a <newline> char.
Looks like you want to suppress the second entry? Still unclear.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Apologies if this has already been covered in this site somewhere, I did try looking but without any success. I am new to the whole XML thing, very late starter, and have a requirement to convert an XML fiule to a CSV fomat. I am crrently working on a Solaris OS. Does anyone have any suggestions,... (2 Replies)
Discussion started by: rossingi_33
2 Replies
2. Shell Programming and Scripting
Iam pretty new to UNIX and would like to convert a CSV to an XML file using AWK scripts. Can anybody suggest a solution? My CSV file looks something like this :
Serial No Growth% Annual % Commission % Unemployed %
1 35% 29% 59% 42%
2 61% ... (15 Replies)
Discussion started by: pjanakir
15 Replies
3. Shell Programming and Scripting
Hi,
i am really fresh with shell scripting and programming,
i have an issue i am not able to solve to populate data on my server for Cisco IP phones.
I have CSV file within the following format:
;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;... (9 Replies)
Discussion started by: angel2008
9 Replies
4. Shell Programming and Scripting
Hi,
I want to write a perl script. Which should accept the xml file, one xsl file and the loaction. The perl script should process the xml file using the xsl file and puts the out put in specified location.
For example:
My.perl is perls cript.
my.xml
is like this
<?xml version="1.0"... (2 Replies)
Discussion started by: siba.s.nayak
2 Replies
5. Shell Programming and Scripting
Hi ,
Please any one to help on ,extract this xml code into csv columns list.
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="1"
FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19"
LEVEL ="0" NAME ="BUSINESS_DATE"... (4 Replies)
Discussion started by: mohan705
4 Replies
6. Shell Programming and Scripting
I need to convert below xml code to csv. I searched other posts as well but this post (_https://www.unix.com/shell-programming-scripting/174417-extract-parse-xml-data-statistic-value-csv.html) gives "sed command garbled" error. As of now I have written a long script to do it, but can it be done with... (7 Replies)
Discussion started by: dineshydv
7 Replies
7. Shell Programming and Scripting
I am in need of converting billions of XML into csv file to load data to DB, i have found the below code in perl but not sure why it's not working properly.
CODE:
#!/usr/bin/perl
# Script to illustrate how to parse a simple XML file
# and pick out all the values for a specific element, in... (1 Reply)
Discussion started by: rspwilliam
1 Replies
8. Shell Programming and Scripting
I want to pharse below Xml Using Shell Scripting .
Thanks in Advance
<md>
<neid>
<neun>1523</neun>
<nedn>XXX1212</nedn>
<nesw>fffff12515</nesw>
</neid>
<mi>
<mts>20141128001500</mts>
<gp>550</gp>
<mt>pmct1</mt>
<mt>pmNo2</mt>
<mt>pmNo3S</mt>
<mv>
<moid>Ma=1,Rn=1,Ul=311C</moid>... (6 Replies)
Discussion started by: pareshkp
6 Replies
9. UNIX for Beginners Questions & Answers
Hello,
I have copied .xml code for a single item below. I am trying to extract three items (field indices*b244 (second occurrence), b203, and j151), so the desired output would be:
9780323013543 Manual of Natural Veterinary Medicine: Science and Tradition, 1e 68.95
A parallel solution,... (14 Replies)
Discussion started by: palex
14 Replies
10. Shell Programming and Scripting
Hello,
For i while i have been using XMLStarlet to convert several XML files to CSV files. So far this always went fine.
Today however i got a new XML format however but i cannot find out how to get the data i need.
Below is part of the code where it shows the different format. What... (10 Replies)
Discussion started by: SDohmen
10 Replies
dir(5) File Formats Manual dir(5)
Name
dir - format of directories
Syntax
#include <sys/types.h>
#include <sys/dir.h>
Description
A directory behaves exactly like an ordinary file, except that no user may write into a directory. The fact that a file is a directory is
indicated by a bit in the flag word of its i-node entry. For further information, see The structure of a directory entry is given in the
include file.
A directory consists of some number of blocks of DIRBLKSIZ bytes, where DIRBLKSIZ is chosen such that it can be transferred to disk in a
single atomic operation (for example, 512 bytes on most machines).
Each DIRBLKSIZ byte block contains some number of directory entry structures, which are of variable length. Each directory entry has a
struct direct at the front of it, containing its inode number, the length of the entry, and the length of the name contained in the entry.
These are followed by the name padded to a 4-byte boundary with null bytes. All names are guaranteed null terminated. The maximum length
of a name in a directory is MAXNAMLEN.
The macro DIRSIZ(dp) gives the amount of space required to represent a directory entry. Free space in a directory is represented by
entries which have dp->d_reclen > DIRSIZ(dp). All DIRBLKSIZ bytes in a directory block are claimed by the directory entries. This action
usually results in the last entry in a directory having a large
dp->d_reclen. When entries are deleted from a directory, the space is returned to the previous entry in the same directory block by
increasing its dp->d_reclen. If the first entry of directory block is free, then its dp->d_ino is set to 0. Entries other than the first
in a directory do not normally have dp->d_ino set to 0.
#ifdef KERNEL
#define DIRBLKSIZ DEV_BSIZE
#else
#define DIRBLKSIZ 512
#endif
#define MAXNAMLEN 255
The DIRSIZ macro gives the minimum record length that will hold the directory entry. This requires the amount of space in struct direct
without the d_name field, plus enough space for the name with a terminating null byte (dp->d_namlen+1), rounded up to a 4-byte boundary.
#undef DIRSIZ
#define DIRSIZ(dp)
((sizeof (struct direct) - (MAXNAMLEN+1)) +
(((dp)->d_namlen+1 + 3) &~ 3))
struct direct {
u_long d_ino;
short d_reclen;
short d_namlen;
char d_name[MAXNAMLEN + 1];
/* typically shorter */
};
struct _dirdesc {
int dd_fd;
long dd_loc;
long dd_size;
char dd_buf[DIRBLKSIZ];
};
By convention, the first two entries in each directory are for dot (.) and dot dot (..). The first is an entry for the directory itself.
The second is for the parent directory. The meaning of `..' is modified for the root directory of the master file system ("/"), where dot
dot has the same meaning as dot.
See Also
fs(5)
dir(5)