Technical forums » General technical issues »
Bold/normal text -> .csv (How to transform formatted bilingual data into reusable .csv text.)
Thread poster: Michael Beijer
Michael Beijer
Michael Beijer  Identity Verified
United Kingdom
Local time: 17:43
Member (2009)
Dutch to English
+ ...
Jun 16, 2010

DUTCH ENGLISH
voedselveiligheids systeem food safety system
voetenzak footmuff
voetgangersplatform pedestrian platform

DUTCH,ENGLISH
voedselveiligheidssysteem,food safety system
voetenzak,footmuff
voetgangersplatform,pedestrian platform

Can someone come up with a clever trick to separate two different areas of a text (bold text and normal text) in order to be able to convert it into a comma- and/or t... See more
DUTCH ENGLISH
voedselveiligheids systeem food safety system
voetenzak footmuff
voetgangersplatform pedestrian platform

DUTCH,ENGLISH
voedselveiligheidssysteem,food safety system
voetenzak,footmuff
voetgangersplatform,pedestrian platform

Can someone come up with a clever trick to separate two different areas of a text (bold text and normal text) in order to be able to convert it into a comma- and/or tab-delimited text file?

Alvast bedankt! ▲ Collapse
 
Adam Łobatiuk
Adam Łobatiuk  Identity Verified
Poland
Local time: 18:43
Member (2009)
English to Polish
+ ...
Find all in Word Jun 16, 2010

In Word, use Find with Select all (the actual option names might be different), and search for bold font (More - Format - Font - Bold). Once all the bold text is selected, copy it and paste to another Word file. Do the same with the non-bold text, adjusting your criteria in the Font dialog. You should have 2 Word files with columns of bold and non bold text respectively. Copy them to separate columns in an Excel file. Hope that works.
 
Jaroslaw Michalak
Jaroslaw Michalak  Identity Verified
Poland
Local time: 18:43
Member (2004)
English to Polish
SITE LOCALIZER
Simple trick Jun 16, 2010

Simple search and replace:

1. Select bold formatting in the find field
2. Put ^&, in the replace field
3. Then, to get rid of the extra space, you can replace all commas followed by a space with just a comma.
 
Michael Beijer
Michael Beijer  Identity Verified
United Kingdom
Local time: 17:43
Member (2009)
Dutch to English
+ ...
TOPIC STARTER
Thanks guys! Jun 16, 2010

I was so busy looking for a way to solve this in Notepad++, that I forgot to try Word! It worked!

[Edited at 2010-06-16 14:44 GMT]
 


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

Moderator(s) of this forum
Laureana Pavon[Call to this topic]

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

Bold/normal text -> .csv (How to transform formatted bilingual data into reusable .csv text.)






Anycount & Translation Office 3000
Translation Office 3000

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.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »