Regular expression for Excel dropdown list Nadvädzujúci príspevok na vyvesovateľa: 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
| | | | Stepan Konev 
Ruská federácia
Local time: 05:45
angličtina -> ruština
| 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 | 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! » |
| | Pastey | Your smart companion app
Pastey is an innovative desktop application that bridges the gap between human expertise and artificial intelligence. With intuitive keyboard shortcuts, Pastey transforms your source text into AI-powered draft translations.
Find out more » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
Translation news related to SDL Trados
