How to resolve this need in "replace".

[ZennoFan]

Hello everyone,
I have a problem and I was wondering if you could help me.
I try to get text with Zenno on a site. The source code is line breaks and spaces like that :

I managed to remove line breaks with this help : http://zennolab.com/discussion/threads/how-to-remove-empty-lines-in-a-text-file.8100/
But for spaces, I can not. So when I get the data to Excel XLS file, the spaces in the variable problematic and shifts all my table.

Would you have a solution?
For details, this amounts to prohibit the "line break". For example, I can Use online tool but I'am sure it's possible in Zenno.

For your information, I have checked "line break" in the Regez tool but apparently it passes a new line anyway.

A thousand thank you in advance!

 

[zortexx]

Could you provide with example?
I guess sample of original text and sample of result that you want too get would be enough.

 

[ZennoFan]

Sorry, you're right.

For example , here's what my variable contains scrapped after content :

VAR "test" =
<h2 class="test title red">
lorem ipsum </h2>

And my excel file tells me in a cell : <h2 class="test title red">
And in another , much further : lorem ipsum
And in another : </h2>

All cells between these two jump . So if I make a test with just the words test1 test , etc .. in the variable in question , all my cells receive text variables without problem.

A thousand thank you for your tracks

 

[zortexx]

Sorry, you're right.

For example , here's what my variable contains scrapped after content :

VAR "test" =
<h2 class="test title red">
lorem ipsum </h2>

And my excel file tells me in a cell : <h2 class="test title red">
And in another , much further : lorem ipsum
And in another : </h2>

All cells between these two jump . So if I make a test with just the words test1 test , etc .. in the variable in question , all my cells receive text variables without problem.

A thousand thank you for your tracks

 

[KitKat21]

Посмотреть вложение 13209

Потрясающие! Только то, что мне было нужно, спасибо!