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)