I'm new of UNIX shell scripting. I'm recently generating a excel report in UNIX(file with delimiter is fine). How should I make a script to do it?
1 file to join comes from output of one UNIX command, the second from another UNIX command, and third from a database query. The key columes of all... (7 Replies)
Hi All,
I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations:
1. I am restrained to 2 input files only.
2. Only the "matched" fields are written out to the "matched" output file and... (1 Reply)
Hi guys,
I need to use awk to join 2 files
file_1
A 001
B 002
C 003
file_2
A XX1
B XX2
output desired
A 001 XX1
B 002 missing
C 003 XX2
thank you! (2 Replies)
Hi guys,
I need AWK to merge the following 2 files:
file1
1 a 1 1
2 b 2 2
3 c 3 3
4 d 4 4
file2
a a/a c/c a/c c/c a/a c/t
c c/t c/c a/t g/g c/c c/t
desired output:
1 a 1 1 a/a c/c a/c c/c a/a c/t
2 b 2 2 x x x x x x
3 c 3 3 c/t c/c a/t g/g c/c c/t
4 d 4 4 x x x x x x (2 Replies)
Hi,
I have a file pk.txt which has pk data in following format
TableName | PK
Employee | id
Contact|name,country
My Output should be
Employee | t1.id=s.id
Contact| t1.name=s.name AND t1.country=s.country
I started of like this:
for LIST in `cat pk.txt` do... (5 Replies)
Hello,
I have 2 csv as follows:
a.csv:
name,phone,adress,car
xy,1234,asbd
yz,2134,asbdf
tc,6789,salkdur
b.csv:
telphone,vehicle
2134,toyota
6789,bmw
1234,honda
What is need is this:
output.csv:
name,phone,adres,car
xy,1234,asbd,honda
yz,2134,asbdf,toyota (7 Replies)
Hello,
This post is already here but want to do this with another way
Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv:
1|123|jojo
1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies
LEARN ABOUT DEBIAN
tmx2tmx
TMX2TMX(1p) User Contributed Perl Documentation TMX2TMX(1p)NAME
tmx2tmx - utility to convert and filter TMX files
SYNOPSYS
tmx2tmx -cat file1.tmx ... filen.tmx > file.tmx
tmx2tmx -toTrados file1.tmx > file2.tmx
tmx2tmx -clean file1.tmx > file2.tmx
tmx2tmx -select=PT,EN multilingual.tmx > pt-en.tmx
DESCRIPTION
This utility processes TMX documents and return TMX documents. Tasks done with this utility include conversion between TMX versions and TMX
cleaning.
TRADOS conversion
As you maybe know, TRADOS is a company producing computer software for translators. It includes WorkBench which imports TMX files.
Unfortunately, the version I used do not import TMX version 1.4.
This process is done using the switch "-toTrados":
tmx2tmx -toTrados file.tmx > trados.tmx
TMX Cleaning
Specially when translation memories are created from anotated text, or extracted directly from the Internet using any automatic method.
This switch is used to remove junk in translation units.
This option tries to remove junk from TMX files, like empty pairs where one of the sides is empty, or removing other junk type.
Use it this way:
tmx2tmx -clean file.tmx > file2.tmx
Concatenating TMX
tmx2tmx -cat file1.tmx ... filen.tmx > file.tmx
ls | grep '.tmx$' | tmx2tmx -cat > file.tmx
Select languages
Select a bunch of languages:
tmx2tmx -select=PT,EN,FR huge.tmx > pt-en-fr.tmx
SEE ALSO
tmx2html, po2tmx, XML::TMX
AUTHOR
Alberto Simo~es, <albie@alfarrabio.di.uminho.pt>
COPYRIGHT AND LICENSE
Copyright 2004 by Projecto Natura
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-06-05 TMX2TMX(1p)