Sponsored Content
Full Discussion: Xml to csv
Special Forums UNIX and Linux Applications Xml to csv Post 302993812 by RudiC on Tuesday 14th of March 2017 03:47:52 PM
Old 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

Help to convert XML to CSV

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

CSV to XML

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

CSV processing to XML

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

XML to csv transformation

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

XML to CSV specific

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

Convert xml to csv

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

How to convert xml to csv ?

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

XML to CSV

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

Xml to csv (again)

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

Converting XML to CSV

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)
All times are GMT -4. The time now is 10:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy