Question 11905 in Shopify Question posted in
The Shopify help center can be found here.

How do i exclude a text between <> when translating in google sheets – Shopify

I have an exported product list from Shopify. I need to translate the product description but in the exported description there are HTML codes that Have to stay intact. How do I exclude the code from my translation?

I use =googletranslate
What can i add in my function to exclude all text between <> theese

Tags:

2

Answers


  1. 0

    You can strip tags with this function

    function stripTags(body) {
  var regex = /(<([^>]+)>)/ig;
  return body.replace(regex,"");
}
    Login or Signup to reply.
  2. 0

    use:

    =REGEXREPLACE(A1; "</?S+[^<>]*>"; )

    or:

    =REGEXREPLACE(A1; "</w+>|<w+.*?>"; )
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search