+ Reply to Thread
Results 1 to 6 of 6

HTML Translation - decode

  1. #1
    Registered User
    Join Date
    03-04-2021
    Location
    ankara
    MS-Off Ver
    2019
    Posts
    3

    HTML Translation - decode

    Hi,

    I have a web site of 3000 products and ı want to translate the product details to another language. ı can use excelport to transfer the data to an excel sheet.
    but the problem is , it comes with HTML codes and sadly the translation doesnt work with those HTML Entities can you think of a way to help me ?

    sample quote :

    "<p><span style="font-family: "source sans pro", sans-serif; font-size: 16px;">Kuveyt Türk Sanal POS Modülü 3.x</span><br style="font-family: "source sans pro", sans-serif; font-size: 16px;"><span style="font-family: "source sans pro", sans-serif; font-size: 16px;">Kuveyt Türk Katılım Bankası A.Ş. FreePOS alt yapısını kullanarak ödeme alabilmenizi sağlar.</span><br style="font-family: "source sans pro", sans-serif; font-size: 16px;"><span style="font-family: "source sans pro", sans-serif; font-size: 16px;">Kolay Ayarlanabilir.</span><br style="font-family: "source sans pro", sans-serif; font-size: 16px;"><span style="font-family: "source sans pro", sans-serif; font-size: 16px;">Banka Bilgileri Admin Panelden Girilmektedir.</span><br style="font-family: "source sans pro", sans-serif; font-size: 16px;"><span style="font-family: "source sans pro", sans-serif; font-size: 16px;">Journal teması ile %100 uyumludur</span><br></p>
    "


    thank you in advance...
    regards
    T.

  2. #2
    Banned User!
    Join Date
    01-17-2021
    Location
    Omaha, NE
    MS-Off Ver
    office 2016
    Posts
    211

    Re: HTML Translation - decode

    what you want the output look like? all encodes mean different things. example this

    Please Login or Register  to view this content.
    mean this
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-04-2021
    Location
    ankara
    MS-Off Ver
    2019
    Posts
    3

    Re: HTML Translation - decode

    any of them will be fine, Omaha

  4. #4
    Banned User!
    Join Date
    01-17-2021
    Location
    Omaha, NE
    MS-Off Ver
    office 2016
    Posts
    211

    Re: HTML Translation - decode

    dont think you understood question. you need convert HTML code AND actual foreign language too. ok? you need something like this

    https://www.textfixer.com/html/html-to-text.php

    i do not have tool to do this. i bet there is nothing to do it either. you can anything to change the rest. google translate.

  5. #5
    Registered User
    Join Date
    03-04-2021
    Location
    ankara
    MS-Off Ver
    2019
    Posts
    3

    Re: HTML Translation - decode

    translation is the easiest part but ı dont think that will help me, because copy paste 3000 products can take a life time
    but thank you for the tip .

  6. #6
    Banned User!
    Join Date
    01-17-2021
    Location
    Omaha, NE
    MS-Off Ver
    office 2016
    Posts
    211

    Re: HTML Translation - decode

    then what you do? that's what you wanted!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Is there a formula to decode URL's?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 12-14-2021, 01:15 AM
  2. Decode this formula
    By tcolyer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2018, 03:39 PM
  3. Decode the Cells
    By navneetvyas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2017, 03:35 AM
  4. [SOLVED] msgpack decode in VBA
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-29-2015, 10:58 AM
  5. Need formula to decode HTML to normal text
    By papusale in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2015, 11:46 AM
  6. Replies: 4
    Last Post: 06-12-2013, 10:28 AM
  7. [SOLVED] serial number decode
    By chiuinggum in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-13-2006, 04:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1