Need help withTranspose column to row

Ángela Rojas

Hello,
I have this:

Wavelength LFH00300002.asd
350 0.34586981
351 0.34210269
352 0.35421594
353 0.34231914
Wavelength LFH00300003.asd
350 0.34586981
351 0.34210269
352 0.35421594

and i need this:

LFH00300002.asd 0.34586981 0.34210269 0.35421594 0.34231914
LFH00300003.asd 0.34586981 0.34210269 0.35421594

Can someone help me with this? Thank you.

guy038

Hello, @ángela-rojas,

Not very difficult with a regular expression, indeed !

Assuming that :

The word Wavelength, with that exact case, begins a line and is followed by, at least, one space character
The different numbers, beginning the following lines, are followed by a single space character

Just follow the few steps, below :

Move back to the very beginning of your file ( Ctrl + Origin )
Open the Replace dialog ( Ctrl + H )
Type (?-i)^Wavelength +|\R\d+ , in the Find what: box
Leave the Replace with: box EMPTY
Click on the Replace All button

Et voilà !

Notes :

The regex search looks, either, for :
- The string Wavelength, with that exact case, followed by, at least, one space character ( + )
- Some End of Line characters (\R ), immediately followed by, at least, one digit ( \d+ )
Whatever the case found, the overall match is deleted, due to the empty replacement regex

Best Regards

guy038

P.S. :

In case the numbers, beginning the line, are followed by several space characters, prefer the regex S/R, below :

SEARCH (?-i)^Wavelength +|\R(\d+) +

REPLACE ?1\x20

If the search must not be sensitive to case, just change the (?-i) part by the (?i) syntax