Reformatting(?) some text Iniziatore argomento: Lincoln Hui
| Lincoln Hui Hong Kong Local time: 16:53 Membro Da Cinese a Inglese + ...
I'm trying to find a way to reformat text that looks like this: a blah blah blah blah blah blah blah into this: a blah a blah a blah a blah a blah a blah a blah This has to do with a couple of files that are needed for my input method as below. Basically, I'm trying to reformat file a as below:... See more I'm trying to find a way to reformat text that looks like this: a blah blah blah blah blah blah blah into this: a blah a blah a blah a blah a blah a blah a blah This has to do with a couple of files that are needed for my input method as below. Basically, I'm trying to reformat file a as below: https://drive.google.com/file/d/0B5IIMsUNTTAFUUpQNkpEcW93VmM/view?usp=sharing so that it looks like file b as below (open in Wordpad/Notepad++): https://drive.google.com/file/d/0B5IIMsUNTTAFVDJHSjVUakdoR3M/view?usp=sharing Thanks.
[Edited at 2015-02-10 22:23 GMT] ▲ Collapse | | | Tony M Francia Local time: 10:53 Membro Da Francese a Inglese + ... 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. I don't quite know where to go from there... Unles... See more 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 | | | Lincoln Hui Hong Kong Local time: 16:53 Membro Da Cinese a Inglese + ... AVVIO ARGOMENTO 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! | | | Dan Lucas Regno Unito Local time: 09:53 Membro (2014) Da Giapponese a Inglese
|
|
Lincoln Hui Hong Kong Local time: 16:53 Membro Da Cinese a Inglese + ... AVVIO ARGOMENTO
Thanks Tony and Dan - the pivot table's exactly what I needed. This is what you get when you've never bothered to learn the finer points of MS Office.
[Edited at 2015-02-10 23:29 GMT] | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Reformatting(?) some text Protemos translation business management system | 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.
More info » |
| CafeTran Espresso | You've never met a CAT tool this clever!
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
Buy now! » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |