Ask Your Question

Revision history [back]

Deleting html codes in spreadsheet

I want to replace all instances of html code in a spreadsheet column (it's output of student text from Moodle). In Excel I can do that using <*>, and in the Libre Help it seems like it should work.

For example, <*> would catch the below and replace them with my desired text.


<scan...&gt;< p="">

/p by itself works, as does individual words, but anything with the symbols < or * do not.

I will keep looking. I just upgraded to 5.4.6.2 on the remote chance it would help.

Thanks for any help.

Deleting html codes in spreadsheet

I want to replace all instances of html code in a spreadsheet column (it's output of student text from Moodle). In Excel I can do that using <*>, and in the Libre Help it seems like it should work.

For example, <*> would catch the below and replace them with my desired text.


<scan...&gt;< p="">

/p by itself works, as does individual words, but anything with the symbols < or * do not.

I will keep looking. found how to use regular expressions in search and replace, but if I just upgraded to 5.4.6.2 on do a search for <.*> more cells are completely deleted than should be. For example, the remote chance it would help.following cell gets blanked out.

I think during war , because reb background like fire.

I think poor ,because this child look gaunt.

 

However, the first sentence in this one remains

I think it is in the evening because the sun is set.

I think we are in the desert because there are only two cactuses

I don't know programming well, but I don't see any unbalanced <>s.

I guess this will be obvious to those who know this stuff. Thanks for any help.

Deleting html codes in spreadsheet

I want to replace all instances of html code in a spreadsheet column (it's output of student text from Moodle).

I found how to use regular expressions in search and replace, but if I do a search for <.*> more cells are completely deleted than should be. For example, the following cell gets blanked out.

I think during war , because reb background like fire.

I think poor ,because this child look gaunt.

 

However, the first sentence in this one remains

I think it is in the evening because the sun is set.

I think we are in the desert because there are only two cactuses

I don't know programming well, but I don't see any unbalanced <>s.

I guess this will be obvious to those who know this stuff. I've tried everything I can think of.

Thanks for any help.

click to hide/show revision 4
None

updated 2018-05-14 13:24:14 +0200

Lupp gravatar image

Deleting html codes in spreadsheet

I want to replace all instances of html code in a spreadsheet column (it's output of student text from Moodle).

I found how to use regular expressions in search and replace, but if I do a search for <.*> more cells are completely deleted than should be. For example, the following cell gets blanked out.

I

<p>I think during war , because reb background like fire.

I fire.</p><p>I think poor ,because this child look gaunt.

 

gaunt.</p><p>&nbsp;</p>

However, the first sentence in this one remains

I think it is in the evening because the sun is set.

I

<p><span style="font-size: 1rem; -webkit-text-size-adjust: 100%;">I think we are in the desert because there are only two cactuses

cactuses</span></p>

I don't know programming well, but I don't see any unbalanced <>s. I guess this will be obvious to those who know this stuff. I've tried everything I can think of.of.

Thanks for any help.help.

(Slightly edited by @Lupp in the hope to get a better view of the question intended.)