need to add text cells in Access/Excel
Thread poster: Elena Ghetti

Elena Ghetti  Identity Verified
Italy
Local time: 06:55
Member (2003)
English to Italian
+ ...
May 19, 2004

I have a large personal glossary in Access and I need to add the contents of two or more cells into a new one that includes both texts i.e.

this is what I have now
column a/column b/column c
door/sportello/source A
door/porta/source A
door/sportello/source B

this is what I want to have:
column a/column b/column c
door/sportello/source A + source B
door/porta/source A

cannot do it manually as it is 100.000 plus lines to go through

thanks for any idea
PS (I have Office 2000 + XP)


 

Harry Bornemann  Identity Verified
Mexico
English to German
+ ...
TShrink May 20, 2004

TShrink does exactly what you described.

It takes a tab-separated table and adds the contents of the respective fields, and it even uses the + symbol for concatenation.

Then it writes the resulting table into a tab-separated text file, a Trados TM import file and a MultiTerm import file.

It processes 100000 lines in 10 seconds.

If you contact me via my profile I can send you a free trial version.

Harry

Elena Ghetti wrote:

I have a large personal glossary in Access and I need to add the contents of two or more cells into a new one that includes both texts i.e.

this is what I have now
column a/column b/column c
door/sportello/source A
door/porta/source A
door/sportello/source B

this is what I want to have:
column a/column b/column c
door/sportello/source A + source B
door/porta/source A
...


[Edited at 2004-05-20 19:35]


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

need to add text cells in Access/Excel

Advanced search






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search