Resolved Remove all the html and particular chars

Hello Davide,

I'm using the replace rule: /<[\/\!]*?[^<>]*?>/i

But everything is ok.

I guess you are trying to say everything is not Ok?

What is the output you get with this rule? Can you post an example of what you expect and what is in your product?

Hi Tharuna,

sorry, it was a mistake!

The field is the product description, I need to see just the text.
But now I find something strange like:   &nbs and so on.


Thanks.
Davide

Hello Davide,
You may need to create two more Find and Replace rule to get the text from product description. The below regex will get you only the text leaving behind any special characters.

/[a-zA-Z]+/

Since nbs is text this will not be filtered in with above regex, you need to create another Find and Replace operation to find nbsp and replace empty.

Let me know if that helps.

Hi Tharuna,

I'm sorry, but it's not working.
In attachment the result.


Thanks.
Davide

Hello Davide,
Can you paste the actual content of product description? The screenshot does not tell me anything on what the product description was before and what has been replaced.

Hi Tharuna,

sure, you find the description in the Site details.


Thanks.
Davide

Hello Davide,
Thank you for posting the content. I have modified the regex a bit and posted it here. Try with the modified regex and check the export. This regex will filter out alphabets, numbers and also space. If you want to let any characters to be left out from replacing you can add the character inside [] like [^a-zA-Z0-9$@ ] for letting $ and @ characters.

/[^a-zA-Z0-9  ]+/

Hi Tharuna,

thank, we are on the right way, but not perfect yet!

This is the output:
pValigia portattrezzi con vasta gamma di utensili per manutenzioni di qulasiasi tipoppCostruita in profilato di alluminio per resistere agli urti e rinforzata con metallo La maniglia telescopica protetta da materiale in plastica

The P in strong I imagine that are the <p> tag in html?
How to remove them?

Probably letteres like that are deleted: è,à,ì


Thanks.
Davide

Hello Davide,
Did you remove the Find and Replace rule for HTML tags? You need two Find and replace rule operation with two regex. First one is to remove the HTML tags and the second one is to remove special characters. See the attached screenshot.

Hi Tharuna,

yes, I deleted it, sorry.
Now, this is the result:
Valigia portattrezzi con vasta gamma di utensili per manutenzioni di qulasiasi tipoHERE IS MISSING THE FULL STOPCostruita in profilato di alluminio per resistere agli urti e rinforzata con metallo La maniglia telescopica protetta da materiale in plastica.

Letters like that are deleted: è,à,ì


Thanks.
Davide

Hello Davide,
As i mentioned earlier you need to add characters you need to not replace in your rule. Here you need a full stop so you need to modify your regex to

/[^a-zA-Z0-9.  ]+/

Let me know if that works.

Hi Tharuna,

thanks, I did it.
Now I tested to add this symbols: ",' and / but when I add them the description will became empty.


Thanks.


Rregards.
Davide

Hi Tharuna,

thank you very much, now it's perfect.


Regards,
Davide