Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    I want to make a certain range one line

    Help wanted · · · – – – · · ·
    2
    2
    36
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • 김성찬
      김성찬 last edited by

      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?

      1 Reply Last reply Reply Quote 0
      • guy038
        guy038 last edited by 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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post
        Copyright © 2014 NodeBB Forums | Contributors