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

Elena Ghetti  Identity Verified
Italy
Local time: 03:18
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)


Direct link Reply with quote
 

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]


Direct link Reply with quote
 


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






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



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