Translate
Good morning to all,
even if I have actually used a Regex pattern to perform this task, I’d like to know if someone of you has a better solution.
Suppose you have a *.csv plain text file similar to this one, exported from a particular translation platform that I don’t know, and that I have not installed on my machine (El Loco - https://www.elloco.com/):
"notification_action_donate","Donate",""
"notification_action_share","Share",""
"EMAIL_SUBSCRIPTION_CREATED_HTML","<p>Hi {firstname},</p>
<p>Thank you for your monthly gift – you are helping feed children in need! Together we want to build a world with zero hunger and ensure that every child has access to nutritious food needed to thrive.</p>
<p>The first installment of your gift has been charged to your preferred payment method.<br /><br />Please do not hesitate to contact us at <a style=''color: #086488; text-decoration: none;'' href=''mailto:support@xxxxx.org'' target=''_blank''>support@xxxxx.org</a> if you have any questions or comments. Please provide the information listed below.</p>
<p>Best regards,</p>
<p>Your Xxxxxxxxxx team</p>
<p><strong>Your monthly gift:</strong><br />Subscription id: {providerId} <br />User code: {userHashLast10} <br />Date: {date} <br />Total monthly amount: {amount} {currency}</p>",""
...
and that you need a result like this one to be processed in SDL Studio 2015 using the CSV File filter:
"notification_action_donate","Donate","Donate"
"notification_action_share","Share","Share"
"EMAIL_SUBSCRIPTION_CREATED_HTML","<p>Hi {firstname},</p>
<p>Thank you for your monthly gift – you are helping feed children in need! Together we want to build a world with zero hunger and ensure that every child has access to nutritious food needed to thrive.</p>
<p>The first installment of your gift has been charged to your preferred payment method.<br /><br />Please do not hesitate to contact us at <a style=''color: #086488; text-decoration: none;'' href=''mailto:support@xxxxx.org'' target=''_blank''>support@xxxxx.org</a> if you have any questions or comments. Please provide the information listed below.</p>
<p>Best regards,</p>
<p>Your Xxxxxxxxxx team</p>
<p><strong>Your monthly gift:</strong><br />Subscription id: {providerId} <br />User code: {userHashLast10} <br />Date: {date} <br />Total monthly amount: {amount} {currency}</p>","<p>Hi {firstname},</p>
<p>Thank you for your monthly gift – you are helping feed children in need! Together we want to build a world with zero hunger and ensure that every child has access to nutritious food needed to thrive.</p>
<p>The first installment of your gift has been charged to your preferred payment method.<br /><br />Please do not hesitate to contact us at <a style=''color: #086488; text-decoration: none;'' href=''mailto:support@xxxxx.org'' target=''_blank''>support@xxxxx.org</a> if you have any questions or comments. Please provide the information listed below.</p>
<p>Best regards,</p>
<p>Your Xxxxxxxxxx team</p>
<p><strong>Your monthly gift:</strong><br />Subscription id: {providerId} <br />User code: {userHashLast10} <br />Date: {date} <br />Total monthly amount: {amount} {currency}</p>"
...
To obtain this result I have used the following Regex patterns (Notepad++ v6.9.1):
“. Matches newline” checked.
Find pattern: ^(.*?",")(.*?)(",")
Replace pattern: $1$2$3$2
When imported in SDL Studio 2015 (CSV file filter – Delimiter: Comma, Source column: 2 – Translation column: 3) it appears in the right way as:
and, when exported again as target *.csv file all works fine.
In fact, the “relative” (even if not substantial) problem is that the CSV file filter does not permit to mark inline tags as it is possible when using the common Text filter as here below:
Apart what already said by Paul Filkin in https://community.sdl.com/products-solutions/solutions/customer_experience_cloud/language/translationproductivity/f/90/t/4077 should future CSV file filter contain this feature?
Thank you.
Claudio
