Rita 

Does this only happen when you have the embedded content setup?  If so the problem could be related to the rules you created.  Perhaps you can share a small sample of the excel and also the rules you created?

Hi Paul,

This is the type of content that is giving me an error message:

<tbody>
<tr>
<th colspan="2">Características principales</th>
</tr>
<tr>
<th>Talla:</th>
<td>43,47,51</td>
</tr>
<tr>
<th>Horquilla:</th>
<td>Bianchi Steel, 1.1/8"</td>
</tr>
<tr>
<th>Cuadro:</th>
<td>Spillo Alloy 6061, 1.1/8" HT, OLD 135mm</td>
</tr>
</tbody>

Also this:

Se incluye el accesorio Kevlar Core.&nbsp;<br><br><span style="font-weight: bold;">Especificaciones:</span></p><ul><li>Peso: 170 g</li><li>Materiales:&nbsp;Alu 7075, POM, acero inoxidable</li><li>DIN: 5-10</li><li>Modos de marcha:&nbsp;Plano / +45 mm&nbsp; / +60 mm</li><li>Rango de ajuste de longitud: 30 mm</li><li>Recorrido elástico el talón: No</li><li>Freno de esquí: Único</li><li>Sistema de freno: No</li><li>Ideales para:&nbsp;Anchura esquís: 60 - 95 mm /&nbsp;Peso de los esquís: 800 - 1500 g /&nbsp;Peso del esquiador: 50 - 85 kg</li></ul><p><br><span style="font-weight: bold;">Tecnologías:</span></p><ul><li>CAM Release System</li></ul><p>

And I have these codes configured. How should they appear?

</?[\p{Ll}\p{Lu}]\w*[^<>]*>

<[a-z][a-z0-9][^<>]>

</[a-z][a-z0-9][^<>]>

Thanks.

 Rita 

So, the first rule is the default.  This one will simply turn all tags into placeholders, like this:

The other two you have created do nothing for the sample text you provided since they don't recognise anything in there.

So, you either work with the placeholder and create additional placeholders for anything not picked up, or you get a little smarter.  You could use a tag pair like this and remove the default rule completely (partially the reason for your error I think as you have potentially overlapping rules):

Start tag:
<[^/>]+?>

End tag:
</[^>]+?>

Set the Advanced to "Exclude".  Also add a placeholder for the non-breaking space:

&nbsp;

And then you get something like this:

Maybe that will help you?

 Rita 

So, the first rule is the default.  This one will simply turn all tags into placeholders, like this:

The other two you have created do nothing for the sample text you provided since they don't recognise anything in there.

So, you either work with the placeholder and create additional placeholders for anything not picked up, or you get a little smarter.  You could use a tag pair like this and remove the default rule completely (partially the reason for your error I think as you have potentially overlapping rules):

Start tag:
<[^/>]+?>

End tag:
</[^>]+?>

Set the Advanced to "Exclude".  Also add a placeholder for the non-breaking space:

&nbsp;

And then you get something like this:

Maybe that will help you?

Thanks for your help, but it didn't work. The same error keeps appearing when I upload a file and I can't understand where the problem is and why it won't let me upload the file. Is it a code problem? Or is the problem something else?

Rita 

Can you share the source Excel file with me?  Could be a problem with the file itself.  I'd be happy to check that for you on the basis you have done everything discussed here already before we waste time investigating something else?  If that's ok yo can send it to pfilkin at sdl dotcom.

Thank you very much Paul.
I have just sent you an email.

Rita 

Thanks for sending me the file... I also note your updated state in that you can now open the file but you want to deal with soft returns in a cell.

The easiest way is still to use the filetype settings and just create a new placeholder tag, set to exclude, and based on this catchall regex:

(\r\n|\n|\r)

So now the rules are only these:

In case it helps, these were my settings and they open the file and segment the text as you wanted: rita.zip

It works.

Thank you very much, Paul. :)