cross tabulation

[user]

hello!

I think this is called cross tabulation:

in a text line this:
[anything but tab][tab][anything but tab][tab][anything but tab]
[anything but tab][tab][anything but tab][tab][anything but tab]
[anything but tab][tab][anything but tab][tab][anything but tab]
[anything but tab][tab][anything but tab][tab][anything but tab]
etc

all the lines that start with the same:
[anything but tab][tab][anything but tab][tab]
I want to delete them and leave only the first occurence, and at the end of it, append all the last [anything but tab] of each of the deleted lines, seperated by –

how can I do this?

thanks!

[user]

anyone???

[user]

???????????????????????

[JohnQSmith]

Since you’re keeping the first one and then appending the others separated by “-“, just replace all “t” with “-“.

[user]

I dont think we are talking about the same thing

I want this text:

a x1 x2 x3
b x4 x5
a x6 x7
b x8 x9 x10 x11
b x12

to become like this:

a x1 x2 x3 x6 x7
b x4 x5 x8 x9 x10 x11 x12

(each of a, b, c, x1, x2, etc are whole text strings)

[Author]

Posts