Community
    • Login

    How to randomize lines on repeat order

    Scheduled Pinned Locked Moved General Discussion
    19 Posts 8 Posters 2.9k Views
    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.
    • PeterJonesP
      PeterJones @Benhur Marxs
      last edited by

      @Benhur-Marxs ,

      Because your data isn’t very precise, and because English appears to not be your first language, people are having a hard time understand what you actually want.

      I am hoping that @Terry-R’s most recent reply will work for you. But if it does not work for you, the please follow the instructions below:

      Instructions:

      It might help if you gave better example data that actually has the multiple rows. But, instead of using 10/25/15/50, just use smaller numbers of rows, like 2/4/3/5. But show all the rows.

      • Hit reply on this post.
      • type **BEFORE:** and ENTER.
      • Hit the </> button.
      • Replace code_text with better example data of what your data is starting like.
      • Go to the end of the reply.
      • Hit ENTER a couple of times.
      • type **AFTER:** and ENTER.
      • Hit the </> button.
      • Replace code_text with the “after” data that you want it to transform into.
      Benhur MarxsB 1 Reply Last reply Reply Quote 2
      • Benhur MarxsB
        Benhur Marxs @PeterJones
        last edited by Benhur Marxs

        @PeterJones ok sorry is very clear now : i tried to reply as you suggest but the system blocking my reply as spam ! maybe need a point of reputation !
        maybe must download from here link text

        PeterJonesP 1 Reply Last reply Reply Quote 0
        • PeterJonesP
          PeterJones @Benhur Marxs
          last edited by PeterJones

          @Benhur-Marxs ,

          Probably akismet thinks the random nonsense in that text is spam, which repuation wouldn’t help you with (and you already have reputation).

          Looking at the paste bin, I don’t actually think you want randomization of the order. You just seem to want each group of identical lines to be re-ordered, so that the group of 1 identical line goes first, the group of 2 identical lines goes second, etc – so sorting by number of identical lines that happen in a row.

          If so, then have you tried @Terry-R 's most recent solution – because his description of that solution (sorting by frequency) seems to be exactly what your paste-bin implies.

          ----

          Let’s see if I can include the stuff from your “paste bin” to help those who won’t click on paste-bin links, and if so, people can test their solutions against your before/after.

          BEFORE:

          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F    <-- 10 times
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5 < -- 11 times
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF <-- 4 times
          CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
          CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
          CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
          8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC <--3 times
          8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
          8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08 <-- 9times
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4 <-- 8 times
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D <-- 7 times
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4 <-- 2 times
          4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB <-- 6 times
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3421998C74C264C6475C598F164AD6868FCF4C9CBB702B4E4C27BCA8ABCA5A63B4C0968247B571AEE01FB4FD128D91E051119BDE0C <- 1 time
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0 <-- 5 times 
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
          

          AFTER:

          3421998C74C264C6475C598F164AD6868FCF4C9CBB702B4E4C27BCA8ABCA5A63B4C0968247B571AEE01FB4FD128D91E051119BDE0C <-- 1  time 
          4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4 <--  2 times
          4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
          8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC <--  3 times
          8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
          8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
          CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF <--  4 times
          CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
          CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
          CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0 <--  5 times
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
          0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB <--  6 times
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D <--  7 times
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4 <--  8 times
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08 <--  9 times
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F <--  10 times
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5 <--  11 times
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
          
          Benhur MarxsB 1 Reply Last reply Reply Quote 1
          • Benhur MarxsB
            Benhur Marxs @PeterJones
            last edited by

            @PeterJones … no luck ::: is still not sorted as i asked !! still casual random !
            But no problem friend , thank you for your answer !

            PeterJonesP CoisesC 2 Replies Last reply Reply Quote 0
            • PeterJonesP
              PeterJones @Benhur Marxs
              last edited by

              @Benhur-Marxs said in How to randomize lines on repeat order:

              no luck ::: is still not sorted as i asked !! still casual random !

              If the data really has the <-- 3 times and similar, then @Terry-R’s procedure won’t work. If your data does not have the extra information at the end, it works exactly as described, as I show below.

              So, from the data I showed in my post, if I remove the <-- #... from the end of those lines (so that there are no spaces or other characters beyond the end of the main line), and then follow the procedure, and I get:

              1. Original
                98fcd4b1-e7a3-479d-abb0-e724f7ad9b3d-image.png
              2. Mark sections with BEL
                930de5dc-968b-4348-b65e-26635057070a-image.png
              3. newline to SOH
                af95a360-0a66-44dc-a69c-c2cb960be6c0-image.png
              4. initial SOH
                d34d3726-88a6-4133-bd11-8717e6b719f2-image.png
              5. add # repeatedly until no more are added:
                abfba83f-7c3e-4bf5-8feb-1896b064174a-image.png
              6. standardize EOL (not show, no change)
              7. sort
                32bc90f6-48be-443c-b8c4-6b518972e07d-image.png
              8. BEL to CRLF
                2b9cd7a9-44de-454c-9772-6e624050c3eb-image.png
              9. removes # lines
                b74ae008-6ad4-4be8-bcad-b15ec283870a-image.png
              10. Removes empty lines
                e520b624-4b07-4fbb-9e5b-61eff74e7066-image.png

              And done.

              1 Reply Last reply Reply Quote 2
              • CoisesC
                Coises @Benhur Marxs
                last edited by

                @Benhur-Marxs

                Try this. All Find what / Replace with below are entered in the dialog that comes up when you select Search | Replace from the main menu; in addition to entering the find and replace strings, you must have Search Mode: Regular expression set and Wrap around checked.

                Find what : ^
                Replace with : @#
                Click Replace All.

                Find what : ^(@++)([^\r\n]++)\R(@++)\2$
                Replace with : \1\3\2
                Click Replace All repeatedly until the message at the bottom says no more replacements were made.

                Edit | Line Operations | Sort Lines Lexicographically Ascending

                Find what : ^(@+?)(\1@?)(#[^\r\n]*+)$
                Replace with : \1\3\r\n\2\3
                Click Replace All repeatedly until the message at the bottom says no more replacements were made.

                Find what : ^@#
                Replace with : (empty)
                Click Replace All.

                Benhur MarxsB 1 Reply Last reply Reply Quote 2
                • Benhur MarxsB
                  Benhur Marxs @Coises
                  last edited by

                  @Coises thankyou !

                  1 Reply Last reply Reply Quote 0
                  • guy038G
                    guy038
                    last edited by

                    Hello, @benhur-marxs, @terry-r, @mkupper, @peterjones,@coises and All,

                    Here is an alternate solution :

                    • From the original INPUT text, below :
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                    CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                    CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                    CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                    8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                    8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                    8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
                    4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3421998C74C264C6475C598F164AD6868FCF4C9CBB702B4E4C27BCA8ABCA5A63B4C0968247B571AEE01FB4FD128D91E051119BDE0C
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    
                    • With this first regex S/R :

                      • SEARCH ^(?-is)(.+\R)\1*

                      • REPLACE ~$0

                      • And a single click on the Replace All button, we add a ~ character at beginning of the first line of each block and obtain :

                    ~E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                    ~E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                    ~CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                    CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                    CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                    CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                    ~8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                    8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                    8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                    ~89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                    ~7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                    ~5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                    ~4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
                    4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
                    ~3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                    ~3421998C74C264C6475C598F164AD6868FCF4C9CBB702B4E4C27BCA8ABCA5A63B4C0968247B571AEE01FB4FD128D91E051119BDE0C
                    ~0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                    

                    Continuation on next post !

                    1 Reply Last reply Reply Quote 0
                    • guy038G
                      guy038
                      last edited by

                      • Now, with this second regex S/R :

                        • SEARCH (?-is)^(~+(?:.+/)?(.+))\R(?=\2)

                        • REPLACE ~\1/

                        • And consecutive hits on the Replace All button, till the message ... 0 occurrence ..., we add a ~ character at the very beginning of a line and join two identical lines with the / separator

                      So, we get the following text :

                      ~~~~~~~~~~E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                      ~~~~~~~~~~~E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                      ~~~~CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF/CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF/CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF/CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                      ~~~8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC/8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC/8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                      ~~~~~~~~~89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                      ~~~~~~~~7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                      ~~~~~~~5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                      ~~4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4/4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
                      ~~~~~~3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                      ~3421998C74C264C6475C598F164AD6868FCF4C9CBB702B4E4C27BCA8ABCA5A63B4C0968247B571AEE01FB4FD128D91E051119BDE0C
                      ~~~~~0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0/0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0/0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0/0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0/0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                      
                      • Then, run the sort command Edit > Line Operations > Sort Lines Lexicographically Ascending

                      => Our text becomes :

                      ~3421998C74C264C6475C598F164AD6868FCF4C9CBB702B4E4C27BCA8ABCA5A63B4C0968247B571AEE01FB4FD128D91E051119BDE0C
                      ~~4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4/4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
                      ~~~8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC/8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC/8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                      ~~~~CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF/CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF/CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF/CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                      ~~~~~0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0/0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0/0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0/0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0/0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                      ~~~~~~3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB/3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                      ~~~~~~~5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D/5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                      ~~~~~~~~7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4/7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                      ~~~~~~~~~89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08/89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                      ~~~~~~~~~~E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F/E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                      ~~~~~~~~~~~E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5/E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                      

                      Continuation on next post

                      1 Reply Last reply Reply Quote 0
                      • guy038G
                        guy038
                        last edited by

                        • Finally, with this third regex S/R, below :

                          • SEARCH ^~+|(/)|(\R)

                          • REPLACE (?1\r\n)?2\2\2

                          • And a single click on the Replace button, you should get the expected OUTPUT text :

                        3421998C74C264C6475C598F164AD6868FCF4C9CBB702B4E4C27BCA8ABCA5A63B4C0968247B571AEE01FB4FD128D91E051119BDE0C
                        
                        4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
                        4E6B5083D6D4C3544B493A0B70155F1E67C7A21996EFE7B214F899DEE5913DE933439A05EABA152AB4CE0AE70505D9FC5C70E752D4
                        
                        8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                        8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                        8DA0B77B6EE18D3829EA1E4232969C86B475D22DB575BC0B302EEA70793E1245B2F999A7415CA75D780888C8A9BC16E878505F0DEC
                        
                        CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                        CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                        CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                        CC02888C8C4626E956D8ADEA384807045527B8F65334D9C5EF6FF023A875EF55690B29FE00AF0F4FE32D39A50382A01E8C99176DCF
                        
                        0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                        0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                        0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                        0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                        0B45821F59A2E7FD7AE1B727C3C0101508E1917A08498C477971FC718545CD1A053C64D961C5F530D0111EDE35AC4BCD4A5B13A8B0
                        
                        3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                        3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                        3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                        3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                        3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                        3FDE5EB1251D1E3C0C11A94CD14BAFA725955CB9EA7D33AB5801CF761CF56D6B946E8882AAB7E54EBB42E660FAD7F31AC99413E9FB
                        
                        5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                        5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                        5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                        5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                        5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                        5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                        5DB580A75A8FA528CA0D3E6D06685F03FBA0BE71D36017D738F89C2EFCD9A806AEB5C8C7BA7171EAB908B3694FC31BA69A0CDFB27D
                        
                        7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                        7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                        7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                        7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                        7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                        7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                        7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                        7A6C9A03F3CD09E1B084D30EA68E378D77C0333B33EEC902AEA538B6309F1D5C9C73C67B277D96D11DD455C335CE2AD245A0349EA4
                        
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        89322A86A9F9A6B0D766B7C7FAA7A46E3DE3E3EAB02836420D50357471E18CD724C86B5C7A5A8BE31A24CC43B685EDACC9F8D93C08
                        
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        E7BFC47C3A067CDF6E3C53CBA27AE0B2ECDE4486D97630C3B01DCFCA6DBA2CC16D7855BAFA34877E386AADE78C94993BF12F33346F
                        
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        E67753DC737A97F917155F1CCCB4B94E29B3E9494385EA3CD5B4DBD42C69428DE44258C01E5FBEE7F0528CEFC86CD472D9144A12D5
                        

                        Voila !

                        Best Regards,

                        guy038

                        Benhur MarxsB 1 Reply Last reply Reply Quote 0
                        • Benhur MarxsB
                          Benhur Marxs @guy038
                          last edited by

                          Thank you ALL !
                          I resolved with your help ( all you ) !!
                          That’s all I asked !!

                          Benhur MarxsB 1 Reply Last reply Reply Quote 0
                          • Benhur MarxsB
                            Benhur Marxs @Benhur Marxs
                            last edited by

                            I renew my thanks to all you : my last request !
                            My file at the end seem like this ;
                            ( usually is 10 or 11 rows total ,and I want to save only the 8th row from the end )
                            before

                            @@4E6B5083D6D4C3544B
                            @@8DA0B77B6EE18D3829
                            @@F869AD9ED3CBB6DB3C
                            @@@@@@@@0749C1720F5BD082D8
                            @@@@@@@@@@@@@@3FDE5EB1251D1E3C50
                            @@@@@@@@@@@@@@7A6C9A03F3CD09E1E3
                            @@@@@@@@@@@@@@@@0B45821F59A2E7FD7A
                            @@@@@@@@@@@@@@@@5DB580A75A8FA52876
                            @@@@@@@@@@@@@@@@89322A86A9F9A6B04C
                            @@@@@@@@@@@@@@@@E67753DC737A97F917
                            @@@@@@@@@@@@@@@@E7BFC47C3A067CDFC5
                            

                            after
                            0749C1720F5BD082D8

                            thank you

                            1 Reply Last reply Reply Quote 0
                            • First post
                              Last post
                            The Community of users of the Notepad++ text editor.
                            Powered by NodeBB | Contributors