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.
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Tony M France Local time: 09:33 Member French to English + ...
SITE LOCALIZER
To start with...
Feb 10, 2015
After your aai etc, is there a tab character? And are those simple spaces between the Chinese characters?
If so, I'd start by replacing the tabs with some other unique character combination, and then the spaces with tabs, which would then let you convert the text to a table, with each Chinese character on a separate line, and the EN 'source text' in the first cell of each section of the first column.
After your aai etc, is there a tab character? And are those simple spaces between the Chinese characters?
If so, I'd start by replacing the tabs with some other unique character combination, and then the spaces with tabs, which would then let you convert the text to a table, with each Chinese character on a separate line, and the EN 'source text' in the first cell of each section of the first column.
I don't quite know where to go from there...
Unless you could do the opposite, and start by inserting 'source text TAB' to replace each space; but I think you might need a little macro or script to automate that.
Or copy the table across into Excel so you can use 'fill down' in some way? Is there a 'fill down until not empty' command?! ▲ Collapse
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Lincoln Hui Hong Kong Local time: 15:33 Member Chinese to English + ...
TOPIC STARTER
You're a life-saver
Feb 10, 2015
Those were actually multiple simple spaces rather than tabs, but a few search and replace still got things done.
Now I've got things in a table and I can do the rest by hand by transposing rows to columns in Excel. Still a lot of work but it's at least feasible now!
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Dan Lucas United Kingdom Local time: 08:33 Member (2014) Japanese to English
Try a different tool
Feb 10, 2015
Lincoln Hui wrote: Still a lot of work but it's at least feasible now!
Lincoln, don't do this manually. What you're trying to do is a common transform operation in data wrangling that goes by a number of names, but usually something like reshaping from "wide to long" or "wide to tall". Once you've got the data into Excel the rest should be easy. Tableau's Excel add-on for reshaping data is useful for this - download it here: http://kb.tableau.com/articles/knowledgebase/addin-reshaping-data-excel
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
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.