Convert tab separated text to non-trivial xml. (pwsafe --> KeePassx)
I'd like to take the output of `pwsafe --exportdb > database.txt` and convert it to a KeePassX XML friendly format (feature request in pwsafe).
I found flat file converter but the syntax is beyond me with this example. Solutions are welcomed.
More details
Here is the pwsafe --> KeePassX XML translations. The pwsafe export is simply a txt file with 6 fields (the first field can be ignored):
Example txt file for conversion (exported from pwsafe):
Example xml in keepassx xml:
Hi,
I have a small requirement where i need to sum up a column in a text file.
Input file
66ab 000000 534385 -00000106350.00
66cd 000000 534485 -00013364511.00
66ad 000000 534485 -00000426548.00
672a 000000 534485 000000650339.82... (5 Replies)
witam
potrzebuje polecenia porownujacego koumny na podstawie n-ostatnich znakow danej linnijki tj
mam 2 koumny AiB zawierajace ciag dowolnych znakow (dlugosci w kazdej linijce mga byc rozne wiec uzycie substra odpada)
A B
ewewewabc nbgujnnabc... (3 Replies)
Hello Gurus,
I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem?
The input file example,
... (6 Replies)
Dear all,
I have a file in this format (like a matrix)
- A B C .. X
A 1 4 2 .. 2
B 2 6 4 .. 8
C 3 5 5 .. 4
. . . ... .
X . . ... .
and want to convert it into a file with this format:
A A = 1
A B = 4
A C = 2
...
A X = 2
B A = 2
B B = 6
etc (2 Replies)
I have a text file that made using text editor in Ubuntu. However the text file is not being recognized as space or tab delimited, the formatting seems to be messed up. How can I convert the text file into tab delimited format? (3 Replies)
Dear users,
I have this problem, this is the example:
123 (tab) A (tab) B (tab) C (tab) 456
where the (tab) is actually the \t delimiter. I need to replace the A B and C for D E and F, this is:
123 (tab) D (tab) E (tab) F (tab) 456
The thing is that my file is quite long and this... (2 Replies)
Hi,
I have created a tab separated file from the following input file.
ADDRESS1 CITY STATE POSTAL COUNTRY LON LAT
32 PRINZREGENTENSTRASSE ROSENHEIM BAYERN 83022 DEU 1212182 4785699
263 VIA DANTE ALIGHIERI BARI PUGLIA 70122 ITA 1686233 4112154
30 VIA MILANO ... (1 Reply)
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
In the gawk below, I am trying to output the file tab-deliminated but don't think that is the correct syntax. Thank you :).
gawk OFS='/t' '{sub(/-+/,"",$2); ar=$0}
END{n = asort(ar)
for (i = 1; i <= n; i++)
print ar}' file (2 Replies)
Hi
i have a problem in my job
i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand
cat xxx.xls > xxx.txt
Do you have eny idea?
PS: sorry for my english
Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies
LEARN ABOUT DEBIAN
docbook2gjots
DOCBOOK2GJOTS(1) General Commands Manual DOCBOOK2GJOTS(1)NAME
docbook2gjots - Convert a DOCBOOK file to gjots format (on stdout)
SYNOPSIS
docbook2gjots [ DOCBOOK-file ]
DESCRIPTION
docbook2gjots converts a DOCBOOK XML file into gjots format.
docbook2gjots uses gawk(1) to perform the conversion.
<preface>, <chapter>, <section>, <sect1>, <sect2>, <sect3> and <sect4> tags are used to define NewEntry and NewFolder boundaries. They
should definitely have <title> tags.
This is a quick and dirty hack using gawk(1) and does no formal checking of XML or SGML syntax nor does it validate against the DOCBOOK
DTD. Consequently, if the syntax of the file is broken the conversion will probably fail.
It is intended that a round-trip can be made so that gjots(1) can be used as a tool at all stages of DOCBOOK production - mainly as an out-
line processor to help the author organise and order the work. A document may well start its life in gjots(1) as the initial thoughts are
marshalled. As the document forms up, it can be converted to DOCBOOK with the following command which automatically adds tags such as
<?xml...>, <para> etc:
gjots2docbook -b file.gjots >file.xml
docbook2pdf file.xml
Or, starting with an existing DOCBOOK file:
docbook2gjots file.xml >file.gjots
In the latter case, the document will already have a lot of DOCBOOK tags so to convert back to docbook, add the -e and -p options:
gjots2docbook -b -p -e file.gjots >file.xml
docbook2pdf file.xml
AUTHOR
Written by Bob Hepple <bhepple@freeshell.org>
http://bhepple.freeshell.org/gjots
COPYRIGHT
Copyright (c) 2002 Robert Hepple
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PAR-
TICULAR PURPOSE.
SEE ALSO gjots(1), gjots2html(1), gjots2docbook(1)DOCBOOK2GJOTS(1)