11-29-2010
Hi,
well it works with the file "toto" :
egrep -ve '^[\s]*$|^[ \t]*<[^>=]*>$' toto | tail +3 | sed 'N;N;s/\n/#/g;s/[^<"]*="//g;s/<[^">]*>/#/g;s/[ <>]//g;s/["]/#/g;s/##*/#/g'
my problem is that the paragraph could be with different longer
<filedata
................................
</filedata>
if my paragraph is :
<filedata notesversion="8" odsversion="51" logged="yes" backup="no" id="C125742C:0038C006" iid="7630E56A:ADB4562F" link="1" dboptions="8192,4849664,17276934,0">
<replica id="41256605:0048070F" flags="72" count="1">
<cutoff interval="90">20100811T010253,56+02</cutoff>
</replica>
<path>/base/base01/mail/mail-20/valerie_deshuissard.nsf</path>
<name>valerie_deshuissard.nsf</name>
<title>Valerie DESHUISSARD</title>
<template></template>
<inheritedtemplate>M0170DIT</inheritedtemplate>
<category>M5;w230;W230;F250;PDPI2</category>
<size current="129325927" max="0" usage="49429504"/>
<quota limit="0" warning="0"/>
<created>20080415T121951,74+02</created>
<lastcompact>20101119T182500,73+01</lastcompact>
<unread marks="yes" replicate="never"/>
<daos enabled="readwrite" objects="107" bytes="78994279" lastsync="20101126T151637,20+01"/>
</filedata>
the sort is made over many lines in place of only one and in another order like this :
90#20100811T010253,56+02#/base/base01/mail/mail-20/valerie_deshuissard.nsf#valerie_deshuissard.nsf#
#ValerieDESHUISSARD#M0170DIT#
#M5;w230;W230;F250;PDPI2#129325927#0#49429504#/#0#0#/
#20080415T121951,74+02#20101119T182500,73+01#yes#never#/
thanks
Christian
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI All,
I have a text file memory.txt which has following values.
Average: 822387 7346605 89.93 288845 4176593 2044589 51883 2.47 7600
i want to convert this file in csv format and i am using following command to do it.
sed s/_/\./g <... (3 Replies)
Discussion started by: mkashif
3 Replies
2. 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
3. Shell Programming and Scripting
Hello Friends,
I am new to UNIX shell scripting. Using bash....Could you please help me in converting a flat file into an XML style output file.
Flat file: (Input File entries looks like this)
John Miller: 617-569-7996:15 Bunting lane, staten Island, NY: 10/21/79: 60600
The... (4 Replies)
Discussion started by: humkhn
4 Replies
4. Shell Programming and Scripting
I have huge xml file in server and i want to convert it to .csv with specific column ...
i have search in blog but i didn't get any usefully command.
Thanks in advance (1 Reply)
Discussion started by: pareshkp
1 Replies
5. Shell Programming and Scripting
Hi list,
This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module.
I have an excel document with multiple tabs of data and graphs.
One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies
6. Shell Programming and Scripting
Hi,
I have a text file with the following format. Some of the fields are blank.
1234 3456 23 45464 327837283232 343434
5654353 34 34343 3434345 434242
....
....
....
I need to convert this file to a CSV file, like
1234, ,23, ... (3 Replies)
Discussion started by: wintersnow2011
3 Replies
7. Shell Programming and Scripting
Hi Friends,
I want to convert a XML file to flat file.
Sample I/p:
<?xml version='1.0' encoding='UTF-8' ?>
<DataFile xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' contactCount='4999' date='2012-04-14' time='22:00:14' xsi:noNamespaceSchemaLocation='gen
.xsd'>
<Contact... (3 Replies)
Discussion started by: karumudi7
3 Replies
8. Shell Programming and Scripting
Hi,
I have a requirement to convert rows into columns. data looks like:
c1,c2,c3,..
r1,r2,r3,..
p1,p2,p3,..
and so on..
output shud be like this:
c1,r1,p1,..
c2,r2,p2,..
c3,r3,p3,..
Thanks in advance, (12 Replies)
Discussion started by: Divya1987
12 Replies
9. UNIX for Beginners Questions & Answers
Hi All,
I have a data file and need to extract and convert it into csv format:
1) Read and extract the line containing string ending with "----" (file sample_linebyline.txt file) and to make a .csv file from this.
2) To read the flat file flatfile_sample.txt which consists of similar data (... (9 Replies)
Discussion started by: abhi_123
9 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
LEARN ABOUT DEBIAN
msh2geo
msh2geo(1rheolef) rheolef-6.1 msh2geo(1rheolef)
NAME
msh2geo - convert gmsh mesh in geo format
SYNOPSIS
msh2geo [-zr|-rz] input[.msh] > output.geo
DESCRIPTION
Convert a gmsh `.msh' into `.geo' one. The output goes to standart output. See the gmsh documentation for a detailed description of the
`.mshcad' input file for gmsh.
EXAMPLES
gmsh -2 toto.mshcad -o toto.msh
msh2geo toto.msh > toto.geo
gmsh -2 -order 2 toto.mshcad -o toto2.msh
msh2geo toto2.msh > toto2.geo
COORDINATE SYSTEM OPTION
Most of rheolef codes are coordinate-system independant. The coordinate system is specified in the geometry file `.geo'.
-zr
-rz the 2d mesh is axisymmetric: zr (resp. rz) stands when the symmetry is related to the first (resp. second) coordinate.
NOTES
Pk triangle, when k>=5, may have internal nodes renumbered: from the
GMSH DOCUMENTATION
The nodes of a curved element are numbered in the following order:
the element principal vertices;
the internal nodes for each edge;
the internal nodes for each face;
the volume internal nodes.
The numbering for face and volume internal nodes is recursive,
i.e., the numbering follows that of the nodes of an embedded face/volume.
The higher order nodes are assumed to be equispaced on the element.
In rheolef, internal triangle nodes are numbered from left to right and then from bottom to top. The numbering differ for triangle when k
>= 5. Thus, msh2geo fix the corresponding internal nodes numbering during the conversion.
Pk tetrahedrons and hexaedrons in gmsh and rheolef has not the same edge-node order nd orientation. E.g. for tetrahedrons, edges 13 and 23
should be swaped and reoriented as 32 and 31. Thus, msh2geo fix the corresponding internal nodes numbering.
TODO
Fix for P3-tetra: swap edges orientations for 3,4,5 and swap faces 1 and 2. Check P4(T) for face orientation. Perform face visualisation
with gnuplot face fill.
See also hexa edges orient and faces numbers and orient.
Check that node are numbered by vertex-node, then edge-node, then face(tri,qua)-node and then volume(T,P,H)-node. Otherwise, renumber all
nodes.
Support for high order >= 6 element ? not documented in gmsh, but gmsh supports it at run
rheolef-6.1 rheolef-6.1 msh2geo(1rheolef)