Technical forums » Déjà Vu support »
Filter text when exporting from MDB
Thread poster: Vitali Chasnovski
Vitali Chasnovski
Vitali Chasnovski  Identity Verified
Ukraine
Local time: 14:07
German to Russian
+ ...
Aug 16, 2006

Hi all,
I am not very good in SQL-language and have some problem in writing of filtering scripts.
To export from MDB I need to filter translations in Subject AND time period (DateStamp from - to).
What text may I write?
Thanks in advance.
 
Terry Richards
Terry Richards
France
Local time: 13:07
French to English
+ ...
An easier way Aug 16, 2006

If this is an MDB, the easiest way is to create a query in Access and then export that query. To export a query, select it in the Access main window and then choose File | Export.

If you realy want to do it in SQL, you will need something like this:

SELECT Field1, Field2...
FROM Table
WHERE DateField > #12/1/2006# AND DateField < #1/1/2007# AND Subject = 'Whatever';

Note that the dates should be in US format (m/d/y) and surrounded by #'s regardl... See more
If this is an MDB, the easiest way is to create a query in Access and then export that query. To export a query, select it in the Access main window and then choose File | Export.

If you realy want to do it in SQL, you will need something like this:

SELECT Field1, Field2...
FROM Table
WHERE DateField > #12/1/2006# AND DateField < #1/1/2007# AND Subject = 'Whatever';

Note that the dates should be in US format (m/d/y) and surrounded by #'s regardless of your local settings.

T. ▲ Collapse
 
Vitali Chasnovski
Vitali Chasnovski  Identity Verified
Ukraine
Local time: 14:07
German to Russian
+ ...
TOPIC STARTER
export to Trados Aug 16, 2006

Yes, it works.
I have exported MDB records to Trados Workbench using this filter:

DateStamp >= #04/04/2001# AND DateStamp < #04/30/2001# AND Subject = '537'

Thank You very much, Terry.
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Pavel Tsvetkov[Call to this topic]

You can also contact site staff by submitting a support request »

Filter text when exporting from MDB






CafeTran Espresso
You've never met a CAT tool this clever!

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

Buy now! »
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 »