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?



  • 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


Log in to reply