Mobile menu

Question for SQL gurus: separating codes from remaining text
Thread poster: Olaf Reibedanz

Olaf Reibedanz  Identity Verified
Colombia
Local time: 20:13
Member (2003)
English to German
+ ...
Mar 31, 2008

Dear colleagues,

Does anybody know an SQL command that allows me to separate all the codes that are located either at the very begining or at the very end of segments from the rest of their segments? Here is an example of what the segments look like before executing that SQL command:

SEGMENT 1: {3310}Except as provided in subclauses {3311} and clause {3312} below, no Shareholder shall be entitled to transfer or otherwise dispose of its Shares without first offering them for transfer to the other Shareholders.{3949}{3313}
SEGMENT 2: {3307}The restrictions on transfer contained in this clause shall apply to all transfers operating by law or otherwise{3308} but only until all P Shares have been either converted or redeemed, after which the restrictions set out in this clause do no longer apply{3309}.{3310}


This is what this section should look like after executing the SQL command:

SEGMENT 1: {3310}
SEGMENT 2: Except as provided in subclauses {3311} and clause {3312} below, no Shareholder shall be entitled to transfer or otherwise dispose of its Shares without first offering them for transfer to the other Shareholders.
SEGMENT 3: {3949}{3313}
SEGMENT 4: {3307}
SEGMENT 5: The restrictions on transfer contained in this clause shall apply to all transfers operating by law or otherwise{3308} but only until all P Shares have been either converted or redeemed, after which the restrictions set out in this clause do no longer apply{3309}.
SEGMENT 6: {3310}


So there should now be six segments where before there were only two. I would like to know an SQL command that will do this automatically for me in the entire project.

Thanks a lot for your help!

Best,

Olaf


Direct link Reply with quote
 

Endre Both  Identity Verified
Germany
Local time: 03:13
Member (2002)
English to German
Not possible Apr 1, 2008

Hello Olaf,

As far as I am familiar with SQL and the structure of a DVX project, segment splitting (or joining) is not possibly via a single SQL command (and is rather complex, if possible at all, via several SQL commands), because you have to assign new segment IDs, which is not a trivial matter (and there might be other complications I'm overlooking right now).

I have a manual solution (as an Autohotkey macro) for doing that from within DVX in a single segment. You press a keyboard shortcut, and leading and trailing codes (and some other usually superfluous characters such as asterisks) are separated into new segments. But you have to do this with every single segment.

I can send you the macro (I might even be able to compile it to a small executable file) in a few hours if you want to give it a try.

Kind regards,
Endre


Direct link Reply with quote
 

Olaf Reibedanz  Identity Verified
Colombia
Local time: 20:13
Member (2003)
English to German
+ ...
TOPIC STARTER
Hi Endre! Apr 1, 2008

Yes, that would be great! Thanks a lot

Direct link Reply with quote
 
David Turner  Identity Verified
Local time: 03:13
French to English
+ ...
Cleanup some codes by pre-processing? Apr 4, 2008

If such codes come from Word files, you might be able to get rid of some of them by pre-processing with the cleanup macro and the hide auto para numbers and bullets macro available either on the Atril Community site or in the files section of the yahoo dejavu list.

David Turner


Direct link Reply with quote
 


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 »

Question for SQL gurus: separating codes from remaining text

Advanced search






Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs