Community
    • Login

    Extract columns with notepad ++

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    8 Posts 2 Posters 1.6k 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.
    • frank kisF Offline
      frank kis
      last edited by

      I have searched several websites, a solution in notepad but does not work, the previous solution of (? -s) ^. + ?: (. + ?:) (. + ?:) {2} (. +?) (: . *)? (? = \ R | \ z), it didn’t work, I’m not a specialist, I’m learning recently, can you help me?
      My text is like this:

      brian:Ryan@me.com:happy:2345:634fcc0a1193258a10867f671612386f:varchar(100)
      michael:Kimberley@me.com:096cd42539bc9d5dae70eb76275052e0:PRIMARY_KEY
      jason:Osian@yahoo.com:date:096cd42539bc9d5dae70eb76275052e0:

      and I need the following result

      Ryan@me.com:2345:634fcc0a1193258a10867f671612386f
      Kimberley@me.com:096cd42539bc9d5dae70eb76275052e0
      Osian@yahoo.com:096cd42539bc9d5dae70eb76275052e0

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

        Hello, @frank-kis,

        (? -s) ^. + ?: (. + ?:) (. + ?:) {2} (. +?) (: . *)? (? = \ R | \ z)

        Quite weird ! As I immediately recognized the regex I gave in @toti-chalo’s post, some hours ago ! Are you the same person ?

        https://community.notepad-plus-plus.org/post/49469

        In that post, it is said

        this is my example, but I always need the second and fifth column

        Now, considering your very short present example, I tried to find out a general rule to build a correct regex, without any result :-((

        If we suppose that we have a colon-delimited file, seemingly, you need, after replacement :

        • To get rid of the first field

        • To get rid of all fields after the MD5 field, with their 32 hexadecimal digits

        • To keep the second field

        If we assume these first conditions, your text becomes :

        Ryan@me.com:happy:2345:634fcc0a1193258a10867f671612386f
Kimberley@me.com:096cd42539bc9d5dae70eb76275052e0
Osian@yahoo.com:date:096cd42539bc9d5dae70eb76275052e0

        But, which additional rule must I apply to get the text, below, what you expect to ?

        Ryan@me.com:2345:634fcc0a1193258a10867f671612386f
Kimberley@me.com:096cd42539bc9d5dae70eb76275052e0
Osian@yahoo.com:096cd42539bc9d5dae70eb76275052e0

        Could you, please, give us some more lines of text to study ?

        See you later,

        Best Regards

        guy038

        frank kisF 2 Replies Last reply Reply Quote 0
        • frank kisF Offline
          frank kis @guy038
          last edited by frank kis

          @guy038
          the text is

          jason:Osian @ yahoo. com:date:096cd42539bc9d5dae70eb76275052e0:
          1:sull @ insanelyi. com:1265737895:…:4:c806318233764c2da90b4930b0c6a591:'-9}
          brian:Ryan @ me. com:happy:2345:634fcc0a1193258a10867f671612386f:varchar(100)
          michael:berley @ me.com:096cd42539bc9d5dae70eb76275052e0:PRIMARY_KEY
          3:mars @ hotmail. com:1265768566:3:470df90857bf8d00e0c157d88468f743:A2R3v
          4:alex.s @ me. com:1265769583:Member:3:62d43f2f05ec755023b2ee1f371610d5:3f7;
          77:carters @ hotmail. com:1265772833:Pira:14:b9a4d56584e3a72c8a5a2018d2d5b6a9:–rI3
          56:hayden @ hotmail. com:1265778966:AppleAddict:14:17c185b1bdd907c9acf65ab8416b47e3:j^D5b

          to

          Osian @ yahoo. com:096cd42539bc9d5dae70eb76275052e0:
          sull @ insanelyi. comc806318233764c2da90b4930b0c6a591
          Ryan @ me. com:happy634fcc0a1193258a10867f671612386f
          berley @ me.com:096cd42539bc9d5dae70eb76275052e0
          mars @ hotmail. com:470df90857bf8d00e0c157d88468f743
          alex.s @ me. com 62d43f2f05ec755023b2ee1f371610d5
          carters @ hotmail. com b9a4d56584e3a72c8a5a2018d2d5b6a9
          hayden @ hotmail. com:17c185b1bdd907c9acf65ab8416b47e3

          1 Reply Last reply Reply Quote 1
          • frank kisF Offline
            frank kis @guy038
            last edited by

            @guy038

            excuse me, the emails are together, I put them apart because they didn’t allow me to reply,
            mail: hash
            thanks

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

              Hi, @frank-kis, and All,

              Personally, I did receive the input and output text in the same post !

              Regarding the text you’re expecting, after replacement, sorry, but I’m still confused !

              • Why the 2nd, 6th and 7th lines do not contain any colon ?

                • In the 2nd line, the colon, before the MD5 zone, is simply deleted

                • In the 6th line, the colon, before the MD5 zone, is replaced with a space char

                • In the 7th line, the colon, before the MD5 zone, is replaced with a space char

              To my mind, if we add these missing colon : characters, the expected text would be more coherent :

              Osian @ yahoo. com:096cd42539bc9d5dae70eb76275052e0:
sull @ insanelyi. com:c806318233764c2da90b4930b0c6a591
Ryan @ me. com:happy634fcc0a1193258a10867f671612386f
berley @ me.com:096cd42539bc9d5dae70eb76275052e0
mars @ hotmail. com:470df90857bf8d00e0c157d88468f743
alex.s @ me. com:62d43f2f05ec755023b2ee1f371610d5
carters @ hotmail. com:b9a4d56584e3a72c8a5a2018d2d5b6a9
hayden @ hotmail. com:17c185b1bdd907c9acf65ab8416b47e3

              However, there’s still a problem. In the 3rd line, you want to keep the string happy. That is not logical, regarding all the other lines !?

              So, can you shed some light on these points… Thanks !

              Once we’ll get a coherent output text, build the appropriate regex, to move from input text to output text, is rather easy ;-))

              BR

              guy038

              frank kisF 1 Reply Last reply Reply Quote 0
              • frank kisF Offline
                frank kis @guy038
                last edited by

                @guy038

                Ok my friend, I just wanted the email and the hash

                2:alex.grig2@me.com:1283313747:2e0d7e0fcd9576ca19b17741c2ebc1bb:?G-N:ip
                29:vs1ck@me.com:1283315003:e339e33ef20d66617d7d15418bd6526d:^v+[a:host
                292:firspiderman@me.com:1283315546:9e6752c212d376b4293c40cfc0b3cbc5:+                ;kH
                29:anthonym24@yahoo.com:1283316357:15710b20a3d5721c72ac036f5c5a84dd:tiNDi
                222:ancientus@yahoo.com:1283317401:8cdc44024ee3bd4a73b2d01a49bfc8fe:0|7Eb
                923:exp1iitc0nt3nt@me.com:1283318508:14:3498a32f4b749715570ad476604de347:.=@UK
                24:alexobritsch@yahoo.com:1283318682:506c25f62848b25b256790b6855a57e8:oP&BG
                29:akag205@yahoo.com:1283319044:9bf0cdb097138f8cab09a1d5264d9581:K&Gw+:89
                296:miel1329@me.com:1283326032:3864f64adcd4525a4cdeb9bacb01562f:VbU84
                27:lovk27@me.com:1283328454:2015214ea772a41d35e1d95a19af99f2:y16Oy
                1928:jshver05@yahoo.com:1283330308:5236800df4ec5a3618f099ebbde1bd02:{x}l9
                3929:beedy@yahoo.com:1283333359:117ab3567f6c4e41465ca3fb62fa8539:iB,)]
                493:shihi@yahoo.com:1283333632:f7ccc1bb6ed6e2cbca6b59712754fdfb:NIZkC
                293:yazaq@me.com:1283351855:ed92b485f1b9538de2fadb10ef2bb364:>U#m$
                2942:lavarrell@me.com:1283352547:a47bd0cca19731fb8e8b520f7785726c:@^@$&
                23:mm34@yahoo.com:1283377639:f049c0a3bf8ee64aae6f09c98bf5f3e0:]A%]}:dominio
                293:mr_grumpy209@me.com:1283388146:29e253a3c746a51b80e3a4e08d18defb:G/V$|

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

                  Hi, @frank-kis, and All,

                  Apparently, you just gave me the input text without saying which text you expect to ! As you do not seem to make some efforts, on your own, to solve your problem, quickly, my reply will be the last one. Sorry ! I’m giving you a solution based upon my guess of what you need. Good luck for adapting my regex solution to your real needs !

                  So, assuming your last input text, below, opened in a Notepad++ tab :

                  2:alex.grig2@me.com:1283313747:2e0d7e0fcd9576ca19b17741c2ebc1bb:?G-N:ip
29:vs1ck@me.com:1283315003:e339e33ef20d66617d7d15418bd6526d:^v+[a:host
292:firspiderman@me.com:1283315546:9e6752c212d376b4293c40cfc0b3cbc5:+;kH
29:anthonym24@yahoo.com:1283316357:15710b20a3d5721c72ac036f5c5a84dd:tiNDi
222:ancientus@yahoo.com:1283317401:8cdc44024ee3bd4a73b2d01a49bfc8fe:0|7Eb
923:exp1iitc0nt3nt@me.com:1283318508:14:3498a32f4b749715570ad476604de347:.=@UK
24:alexobritsch@yahoo.com:1283318682:506c25f62848b25b256790b6855a57e8:oP&BG
29:akag205@yahoo.com:1283319044:9bf0cdb097138f8cab09a1d5264d9581:K&Gw+:89
296:miel1329@me.com:1283326032:3864f64adcd4525a4cdeb9bacb01562f:VbU84
27:lovk27@me.com:1283328454:2015214ea772a41d35e1d95a19af99f2:y16Oy
1928:jshver05@yahoo.com:1283330308:5236800df4ec5a3618f099ebbde1bd02:{x}l9
3929:beedy@yahoo.com:1283333359:117ab3567f6c4e41465ca3fb62fa8539:iB,)]
493:shihi@yahoo.com:1283333632:f7ccc1bb6ed6e2cbca6b59712754fdfb:NIZkC
293:yazaq@me.com:1283351855:ed92b485f1b9538de2fadb10ef2bb364:>U#m$
2942:lavarrell@me.com:1283352547:a47bd0cca19731fb8e8b520f7785726c:@^@$&
23:mm34@yahoo.com:1283377639:f049c0a3bf8ee64aae6f09c98bf5f3e0:]A%]}:dominio
293:mr_grumpy209@me.com:1283388146:29e253a3c746a51b80e3a4e08d18defb:G/V$|

                  • Open the Replace dialoag ( Ctrl + H )

                  • SEARCH (?-s)^.+?:(.+?:).*([[:xdigit:]]{32}).+

                  • REPLACE \1\2

                  • Tick the Wrap around option

                  • Select the Regular expression search mode

                  • Click once on the Replace All button

                  You should get, immediately, the text :

                  alex.grig2@me.com:2e0d7e0fcd9576ca19b17741c2ebc1bb
vs1ck@me.com:e339e33ef20d66617d7d15418bd6526d
firspiderman@me.com:9e6752c212d376b4293c40cfc0b3cbc5
anthonym24@yahoo.com:15710b20a3d5721c72ac036f5c5a84dd
ancientus@yahoo.com:8cdc44024ee3bd4a73b2d01a49bfc8fe
exp1iitc0nt3nt@me.com:3498a32f4b749715570ad476604de347
alexobritsch@yahoo.com:506c25f62848b25b256790b6855a57e8
akag205@yahoo.com:9bf0cdb097138f8cab09a1d5264d9581
miel1329@me.com:3864f64adcd4525a4cdeb9bacb01562f
lovk27@me.com:2015214ea772a41d35e1d95a19af99f2
jshver05@yahoo.com:5236800df4ec5a3618f099ebbde1bd02
beedy@yahoo.com:117ab3567f6c4e41465ca3fb62fa8539
shihi@yahoo.com:f7ccc1bb6ed6e2cbca6b59712754fdfb
yazaq@me.com:ed92b485f1b9538de2fadb10ef2bb364
lavarrell@me.com:a47bd0cca19731fb8e8b520f7785726c
mm34@yahoo.com:f049c0a3bf8ee64aae6f09c98bf5f3e0
mr_grumpy209@me.com:29e253a3c746a51b80e3a4e08d18defb

                  BR

                  guy038

                  frank kisF 1 Reply Last reply Reply Quote 2
                  • frank kisF Offline
                    frank kis @guy038
                    last edited by

                    @guy038

                    I’m sorry for my English, I’m from Chile, I thank you very much for your help, for you what I needed was solved
                    You are a great person and teacher in notepad.
                    regards
                    Happy new year 2020

                    1 Reply Last reply Reply Quote 1

                    Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                    Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                    With your input, this post could be even better 💗

                    Register Login
                    • First post
                      Last post
                    The Community of users of the Notepad++ text editor.
                    Powered by NodeBB | Contributors