Trying to find proper regex to tag the enclosed Excel files in Multilingual Excel

Question

file type settings.zip 
 Defining proper settings to process the file in Multilingual Excel in the languages part is simple. I then add HTML5 to process all the tags there. But a huge number of expressions like this ${globalvar.emailheader} or #if(${causedByUseradmin}) or #foreach(${shoppingCartItem} in ${order.shoppingCartItemCollection}) #if(${shoppingCartItem.product_id.startsWith("mah")} || ${shoppingCartItem.product_id.startsWith("porto")}) 
 I have tried: 
 \${[^}]*?} #{[^}]*?} 
 But these won't convert the file. 
 I also tried to add the elements like \${globalvar.emailheader} or \${globalvar.anrede} one by one, but also to no avail. Now I have no clue what to do. Of course the files can be translated as is, but it would be very elegant to have such elements hidden as tags. However, my feeling tells me, that the files are to irregular to be able to achieve what I want. 
 I also include my settings file, which creates a nice preview, but causes errors in file conversions. source files.zip

Jesús Prieto · Answer

Jerzy Czopik 
 I don&rsquo;t know if Paul&rsquo;s comment in this post has anything to do with your issue ( Segmenting on the soft return won't work with the Multilingual Excel , so it seems that it can&rsquo;t deal with a simple regex such as 
 ). I haven&rsquo;t tried regexes with the default Excel file type, biut I believe it should work. 
 https://community.rws.com/product-groups/trados-portfolio/trados-studio/f/studio/50566/improve-segmentation-with-embedded-content-tags-in-bilingual-xlsx 
 Also: 
 
 I think this regex would be better: #[^)]*?\) 
 I&rsquo;m not sure if the order of the 2 regex rules matters (because there are ${XXX} strings inside #XXX strings). 
 
 If you post a sample file, I can try myself.

Trados Studio > 6. Regex and XPath

Trying to find proper regex to tag the enclosed Excel files in Multilingual Excel

Top Replies