This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
I need to see only segments from files in folder «2». And I don't know how to do that. I tried to use short filenames (w/o path) with «FileID» without any success. Examp... See more
Have been trying to build SQL expression to filter only segments from files in determined folder in project and NO SUCCESS
I need to see only segments from files in folder «2». And I don't know how to do that. I tried to use short filenames (w/o path) with «FileID» without any success. Examples in manual give no idea for solving this problem. Short Internet search was also unsuccessfull.
Anybody (but mainly Selcuk Akyuz as i can see) give the idea how to solve this problem and filter files in project
1. By name 2. By extension 3. By folder ▲ Collapse
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Selcuk Akyuz Türkiye Local time: 12:52 English to Turkish + ...
FileSpec
Feb 24, 2017
Unfortunately I don't know how to do it but folder names are stored in the Files table, FileSpec column.
I have tried with ID IN but that failed.
ID IN (SELECT ID FROM Pairs WHERE ID IN (Select ID FROM Files WHERE FileSpec IN ((Select FileSpec FROM Files WHERE (((Files.FileSpec LIKE) "*xxxx*"))))))
Selcuk
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Endre Both Germany Local time: 11:52 English to German
FileSpec is full path, FileExt is extension and FileName is file name
Feb 24, 2017
Try this for a folder: FileID in ( SELECT ID FROM Files WHERE (FileSpec LIKE '*/YourSubfolder/*') )
And this for an extension: FileID in ( SELECT ID FROM Files WHERE (FileExt LIKE 'yourExt') )
And this for part of a filename: FileID in ( SELECT ID FROM Files WHERE (FileName LIKE '*partOfName*') )
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
mikhailo Local time: 12:52 English to Russian + ...
TOPIC STARTER
re
Feb 24, 2017
Endre Both wrote:
Try this for a folder: FileID in ( SELECT ID FROM Files WHERE (FileSpec LIKE '*/YourSubfolder/*') )
And this for an extension: FileID in ( SELECT ID FROM Files WHERE (FileExt LIKE 'yourExt') )
And this for part of a filename: FileID in ( SELECT ID FROM Files WHERE (FileName LIKE '*partOfName*') )
Thanks Endre. It works.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
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
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.