Sql – Lookup – Insert

Sql – Lookup – Insert
I have a SQL database for products.

In one of the coloumns there are product names and another there are product descriptions in english language.

And in another coloumn there is a dictionary with one word or word pair per row with a bolded word or word pair for English and nonbolded words with a , seperator for the other language.

So what I need is a result in the same source cell for the english product name or product description with the following logic to add under the English text:

1. word by word (with a regular heading text which is always the same – word by word translation in that language) first only in the other language under the original english text

like this one:

word translated – word translated – word translated etc.

and under that the following also in the same cell:

2. word by word (with a regular heading text which is always the same – word by word translation in that language with the english words) with the english words + translated words

like this one:

english word – translated word * english word – translated word * english word – translated word * englisch word – translated word *

The whole work should be made for online working – where I have a mask and type the starting row number and ending row number.

It should also tell me if there was any errors in the process and let me choose to try the cells again automatically with the error rows included.

Example:

http://www.portal-usluga.hr/shop2/rca-rp5605-clock-radio—led/9127/kuca-vrt-slobodno-vrijeme-23

this is a product only in english name and description
above the picture is the name
and below the description
both only in english

so the example result would be for product name:
RCA RP5605 Clock Radio – LED * RCA – RP5605 – sat – radio – LED

and for the description

RCA RP5605 CD Clock Radio with AM/FM

Prijevod na hrvatski riječ po riječ:

RCA – RP5605 – CD – sat – radio – s – AM/FM

Prijevod na hrvatski riječ po riječ s engleskim riječima:

RCA – RCA * RP5605 – RP 5605 * CD – CD * Clock – sat * Radio – radio
* with – s * AM /FM – AM/FM

Leave a Reply

Your email address will not be published.