Regular expression for Excel dropdown list Αποστολέας σε συζήτηση: Beñat Landa
|
|---|
Hi all!
I have a couple of dropdown lists in an excel to translate, but options of that list don't appear in Trados Studio... I'm trying to figure out different ways, and found out that through the settings (Microsoft Excel 2007-2019 > Embedded content processors) and using regular expressions, this problem can be solved. Does anyone know how to add regular expressions, and which one to add?
Thanks!
| | | | | |
What are you trying to convert with regex? I'm guessing single words from a drop down list?
If so you can do that without regex. For example, the case with the % from the video above, can be easily converted without regex.
I've never seen % alone. So, always there is a digit before %. And that's why you can add blank space without regex.
Just simple
Find=%
Replace= % [with blank space in front]
Another example from the video with regex wou... See more What are you trying to convert with regex? I'm guessing single words from a drop down list?
If so you can do that without regex. For example, the case with the % from the video above, can be easily converted without regex.
I've never seen % alone. So, always there is a digit before %. And that's why you can add blank space without regex.
Just simple
Find=%
Replace= % [with blank space in front]
Another example from the video with regex would be:
Find=^Costs [match case √]
Replace=Los costos
This regex will change the word costs when is at the start of a string. That's why you put ^
And furthermore:
Find=went up\b [match case √]
Replace=aumentaron
This regex will change "went up" into "aumentaron", and you close that with \b so only "went up" to convert into "aumentaron". So if it's went, than no conversion... In this way the regex reads "went up" as one word
And I don't know about trados, but in Word, if you insert this regex once, than you record them with Macro to not insert them again. On the next task you just run the macro, and it converts.
[Edited at 2024-12-07 11:11 GMT]
[Edited at 2024-12-07 11:24 GMT]
[Edited at 2024-12-07 11:27 GMT] ▲ Collapse
| | | |
Lists can't exist in Excel on their own. If there is a dropdown list nested in your Excel file, there must be the same list options elsewhere in the file, probably another worksheet.
Select/click the cell with the dropdown menu in Excel, go to Data tab, find and click Data Validation there. A window will open showing the source cells of your ... See more Lists can't exist in Excel on their own. If there is a dropdown list nested in your Excel file, there must be the same list options elsewhere in the file, probably another worksheet.
Select/click the cell with the dropdown menu in Excel, go to Data tab, find and click Data Validation there. A window will open showing the source cells of your list.
If you can't find them in the Trados editor, probably you have some worksheets hidden that contain that special information with menu options, etc.
The Embedded content feature only allows converting of plain text into tags or placeholders. It won't show up anything.
Go to Project Settings, File Types, MS Excel 2007-2019, Common, try checking the Hidden content or other options. Use the Preview button to see if checking different options would change anything.
Also, try asking that question at the RWS Community: https://community.rws.com/product-groups/trados-portfolio/trados-studio/f/studio
[Edited at 2024-12-07 11:45 GMT] ▲ Collapse
| | |
|
|
|
Okay, I probably misunderstood about what do you want to do. You want to convert those excel drop down list into Trados format. I think that regex can't help you with this.
You could try this https://www.nikse.dk/xmlcontenttranslator
A free XML content translator via Google Translate.
You can export your data from Excel into XML file, but you need to do XML scheme... See more Okay, I probably misunderstood about what do you want to do. You want to convert those excel drop down list into Trados format. I think that regex can't help you with this.
You could try this https://www.nikse.dk/xmlcontenttranslator
A free XML content translator via Google Translate.
You can export your data from Excel into XML file, but you need to do XML scheme, mapping or whatever. ▲ Collapse
| | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » Regular expression for Excel dropdown list | TM-Town | 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.
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... | | | | | |
Login to reply/comment 
Translation news related to SDL Trados
