How to parser these files in Studio 2014?

Hi,

How to parser these TXT files in one single project in Studio 2014 to extract the translatable content?

File #1:

IDT_EVENTNAME16                               "Error, Guest card overridden"
IDT_EVENTNAME17                               "Error, Guest card overridden"
IDT_EVENTNAME18                               "Error, Card not valid yet"

> The translatable content is between the quotes. So the flooding regex should work in the TXT filter configuration, right?

- Opening pattern: ^.*?(")

- Closing pattern: (")$

Files #2:

       12000 "Guest" // "Guest"
       12001 "Staff" // "Staff"
       12002 "Emergency" // "Emergency"

> The translatable content is the one between the first quotes. All other content is comments, etc.

File #3:

IDS_ACCOUNT_CONFIRM=Confirm password:
IDS_ACCOUNT_TITLE=Select Account
IDS_ACCOUNT_MESSAGE=Please enter the account name and password for the components.

> The translatable content is the one after the equal symbol.

File #4:

DESCRIPTION_CLIENT Client program files
DESCRIPTION_DATABASE Database
DESCRIPTION_SERVER Server program files

> The translatable content here is the one after the tab space. It's a tab separated file.

Thank you in advance for your help on this!

Best regards,

Carla

Translate

Rate translation

Suggest better translation

Moderator UI

Thread Subject & Description
How to parser these files in Studio 2014? Hi, How to parser these TXT files in one single project in Studio 2014 to extract the translatable content? File #1: IDT_EVENTNAME16 "Error, Guest card overridden" IDT_EVENTNAME17 "Error, Guest card overridden" IDT_EVENTNAME18 "Error, Card not valid yet" > The translatable content is between the quotes. So the flooding regex should work in the TXT filter configuration, right? - Opening pattern: ^.*?(") - Closing pattern: (")$ Files #2: 12000 "Guest" // "Guest" 12001 "Staff" // "Staff" 12002 "Emergency" // "Emergency" > The translatable content is the one between the first quotes. All other content is comments, etc. File #3: IDS_ACCOUNT_CONFIRM=Confirm password: IDS_ACCOUNT_TITLE=Select Account IDS_ACCOUNT_MESSAGE=Please enter the account name and password for the components. > The translatable content is the one after the equal symbol. File #4: DESCRIPTION_CLIENT Client program files DESCRIPTION_DATABASE Database DESCRIPTION_SERVER Server program files > The translatable content here is the one after the tab space. It's a tab separated file. Thank you in advance for your help on this! Best regards, Carla
Get AI Suggestion

AI Reply

Accept answer Reject Answer

Parents

0 Paul over 8 years ago

Hi Carla,

Try these...

File #1
^.*?"
"$

File #2
^.*?"
"\s//.*

File#3
^.*=
$

File#4
^.*?\t
$

I think these would do it. Make sure you keep the filetype you create above the rest, especially for the last one as this will be confused with the tab delimited otherwise.

Regards

Paul

Paul Filkin | RWS Group

________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Carla Galvao over 8 years ago in reply to Paul

Thanks Paul but I got an error message after clicking on the Prepare batch tasks: Problem during processing opening tags! Check the definitions of your opening tags.

I created one Regular Expression Delimited Text file type for each regex you mentioned above, moved them at the top of the File Types list, created a project with the 4 source files and run the Prepare batch tasks... Then I got this error message.

Any idea why?

Thanks!

Regards,

Carla
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Carla Galvao over 8 years ago in reply to Carla Galvao

Paul,

Don't take into account my last reply, I just deleted the default regex that was already on each file type and Studio could process the batch task Prepare. Now, my problem is the content extraction:

File #1: all the content is not extracted, only few of the strings

File #2: all the content in quotes is extracted, even the comments. It appears as follow in the Editor view:
Guest" // "Guest
Staff" // "Staff
Emergency" // "Emergency

For the strings like this one, it's split into two segments in Studio:
10002 "User group:" // Label "User group:"
User group:"
// Label "User group:

File #3: all content is extracted properly! :-)

File #4: all the content is not extracted, only two sentences.

Thanks!

Carla
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Paul over 8 years ago in reply to Carla Galvao

Try them one at a time. You can't use these four filetypes in the same project unless you have some means of telling Studio which filetype to use for which file. Tricky when they are all txt files. So if you were able to group the files together and rename the extension then you could do it that way, otherwise you need to group the source files that are formatted the same way and prepare them with the appropriate filetype only.

So you need four projects.

Regards

Paul

Paul Filkin | RWS Group

________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Carla Galvao over 8 years ago in reply to Paul

Oki, I created the four projects and now I'm facing the following issues :-( (sorry about that):

File #1: Only a small block of content (located in the middle of the file) was extracted :-(

File #2: Studio extracted the content between the first pair of quotes and the one on the second pair of quotes. I only need the one on the first pair of quotes.

File #3: All content was extracted properly! :-)

File #4: All content was extracted properly!

Thanks again for your help on this!

Carla
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Paul over 8 years ago in reply to Carla Galvao

Hi Carla,

ok. I checked the whole files and created settings files as I had not done this before... just worked out the regex. Files #2, #3, #4 worked perfectly for me. File #1 needed a little change because I didn't notice the tabs at the end of each line so I added a \t in there to make it work.

I checked all four of these and they all extract the correct text and all of the text for me. Settings files are here:

Carla GALVAO.zip

Regards

Paul

Paul Filkin | RWS Group

________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Carla Galvao over 8 years ago in reply to Paul

Hi Paul,

Thanks! I uploaded your File Types Settings but still the content of File #1 and File #2 aren't extracted properly on my side. Seems that I can't send you screenshots or the SDLXLIFF files to show you :-(.

Can't understand why... Maybe I should ask the requester to double-check the structure of the whole document? Maybe there're some variations that I didn't notice and the regex can't process everything?

Regards,

Carla
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Paul over 8 years ago in reply to Carla Galvao

I dropped you an email... going to be better to look at this over Skype. Either this is a bug in 2014, or you are perhaps having an issue with project templates and are not actually using what you think you are.

Regards

Paul Filkin | RWS Group

________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Cancel
Vote Up 0 Vote Down

Sign in to reply

Reject Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate
0 Carla Galvao over 8 years ago in reply to Paul

Hi Paul,

So, I corrected the regex for the first file and I created one project for each file while making sure that I "activated" the corresponding File Type in Studio. So, File Type #1 box checked when creating the new project for File #1, File Type #2 box checked for File #2 new Studio project and so on...

File #1
^.*?"
"$|"\t$

All the content of the four files are now properly extracted!

Thank you again for your help Paul!

Regards,

Carla
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate

Reply

0 Carla Galvao over 8 years ago in reply to Paul

Hi Paul,

So, I corrected the regex for the first file and I created one project for each file while making sure that I "activated" the corresponding File Type in Studio. So, File Type #1 box checked when creating the new project for File #1, File Type #2 box checked for File #2 new Studio project and so on...

File #1
^.*?"
"$|"\t$

All the content of the four files are now properly extracted!

Thank you again for your help Paul!

Regards,

Carla
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Share
Documentation Survey: help us offer you better documentation! Translate

Children

No Data

Trados Studio > 5. Regex and XPath

How to parser these files in Studio 2014?