I want to make a certain range one line

김성찬

i’m watching and collect tcp Packet Data
i use wireshark export .txt file function
and export as follows Ascii Data txt file
…3.).|*1;…E.
.)…@…4…4T
.!.'…C…P.
…;…

|*1;…3.)…E.
.4…@…4T.!..
…'C…
…R…
…

…3.).|*1;…E.
.).A@…Q…"_
|…)…P.
…u…

…3.).|*1;…E.
.)…@…i…#.
…(…y…$…P.
…W…

|*1;…3.)…E.
.4Q…x.GG"_|…
…)…
…f…)…).
…

…3.).|1;…E.
.)…@…g.
b……<P.
…

|*1;…3.)…E.
.4.e…x.q.#…
…($…y…
.K!..y…y.
…

|1;…3.)…E.
.(m.@…G.g.b…
……<…P.
1…

…3.).|*1;…E.
.)…@…x…
…j…ZP.
…$…

|*1;…3.)…E.
.4Pg…x.!..
…Z…j…
…l…j…
j.

because i’m insert oracle Database this data
and Oracle import function needed OneLine type
What should i do?

guy038

Hello, @김성찬 and All,

Here is a method, using regular expression syntax :

Open the Replace dialog ( Ctrl + F )
SEARCH ^\R|(\R)(?!\R)
REPLACE ?1\x20
Tick the Wrap around option, if necessary
Select the Regular expression search mode
Click on the Replace All button

Voila !

Notes :

The search regex tries to match, either :
- True empty lines ( part ^\R ), which are deleted during replacement
- EOL char(s), stored in group 1 ( as embedded in parentheses ) ONLY IF not followed with others EOL character(s) ( part (\R)(?!\R) )
In replacement, when group1 exists ( second alternative ) we replace the line-break with a space char

Best Regards

guy038