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
| | | | | Project Settings | Dec 7, 2024 |
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 | Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
| | Trados Studio 2022 Freelance | The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
Translation news related to SDL Trados
