Divide data

[miso.dca]

Hello guys,
I have this kind of data :

Please Login or Register  to view this content.

and I need to separate it like this :

Please Login or Register  to view this content.

that means, first I need to be time (5.30, 1.00, etc) and then text, but this text has sometimes one word, sometimes two, sometimes even more ... how could I do it please? thank you for any help !

[TKCZBW]

If you separate each item with a comma, then you could do the following:

Please Login or Register  to view this content.

Hope this helps.

[miso.dca]

this data can be modified, I can replace (by macro) , instead of ., but this I dont understand :

Please Login or Register  to view this content.

I've got error there

[TKCZBW]

You need to direct TText to represent the total data that you have.

[Miroslav R.]

Please Login or Register  to view this content.

[miso.dca]

TKCZBW - sorry, dont understand at all
Miro - dikes / thanks but here

Please Login or Register  to view this content.

- I've got error as well but first row was divided ...

I thought this would be much more easier

[TKCZBW]

In your original post, what you refer to as 'this kind of data', I assume that's all in one string? Make that string TText once you have inserted a comma between each item that you want on a new line.

[Miroslav R.]

Sorry for that error, but it was done in 6mins on the sample size you uploaded.
When getting the error, have a look at variables 'r', 'a', 'b' value.
Definitely it needs a little bit of cleanup, but now you have the direction...

[miso.dca]

TKCZBW - eh, now I understant little bit more thanks
Miroslav - 6 mins? great ok, I will check it, thanks !

[TKCZBW]

No worries, hope it helps!