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.

I want to make it like this
…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