This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
I have an ongoing translation project that often involves conversion of measurements scattered throughout the text file from metric to US customary. I have a system for handling it, but it's still pretty laborious.
So I'm wondering if there's a program that does this automatically. I haven't been able to find anything so far.
Assuming there's not something that automatically can convert directly from the text, there seems to be an Excel function that wi... See more
Hi,
I have an ongoing translation project that often involves conversion of measurements scattered throughout the text file from metric to US customary. I have a system for handling it, but it's still pretty laborious.
So I'm wondering if there's a program that does this automatically. I haven't been able to find anything so far.
Assuming there's not something that automatically can convert directly from the text, there seems to be an Excel function that will do it when values are entered in individual cells.
So what I'm wondering is:
1. Is there a smooth way to extract all numerical data from text? Erasing all the non-numeric data would of course work, too. I spent a while looking for online options and didn't find anything that worked well enough for my needs.
2. Then, is there a way to get that string of numbers into so many cells in Excel? For example, if I have a string of 100 numbers in a text file, is there a way to smoothly convert them to 100 cells in Excel (without cutting and pasting each one)?
It could be possible there's another approach / solution too that I haven't considered.
Any thoughts or ideas will be greatly appreciated!
For the mathematical conversion of the numbers you need a Word or Excel macro.
But in many senarios a mathematically exact conversion might be not suitable: Often you'll need round up/down and/or use more or less digits, depending on the context. E. g. if a person's height is meant, you should make 189 cm to 6.2 feet (instead of 6.201 feet).
José Henrique Lamensdorf
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Adam Warren فرنسا Local time: 02:48 عضو (2005) فرنسي إلى أنجليزي
Working via Word
Jul 10, 2018
If the numerical data can be isolated as you describe, you can align the numbers in a column, each followed, after a tab, by its unit, ending each row by a "carriage return". From this array, and using those punctuation marks as parameters, form a 2-column table in Word, which then transpose into Excel for processing as you require. I hope I'm not stating the obvious.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.