Community

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

    how to delete rows out of multiple files

    Help wanted · · · – – – · · ·
    3
    10
    184
    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.
    • holczmann raul
      holczmann raul last edited by

      I need to delete all the selected text
      9d9efb7e-1e24-4539-8b5d-b35aa23c4b99-image.png
      fde93e03-f18e-47b6-bb94-bd645bc6884d-image.png
      fbcbcce0-eca1-4147-b8f6-104cc317c1e6-image.png
      the only thing that should remain is from text UNA:+.? until the end line 1+765’

      Can anyone help me with this please it really bothers me.

      Thank you

      Alan Kilborn 1 Reply Last reply Reply Quote 0
      • Alan Kilborn
        Alan Kilborn @holczmann raul last edited by Alan Kilborn

        @holczmann-raul

        Your request is confusing.
        Follow instructions HERE.

        holczmann raul 1 Reply Last reply Reply Quote 0
        • guy038
          guy038 last edited by guy038

          Hello, @holczmann-raul, @alan-kilborn and All,

          Although @alan-kilborn is right about the lack of information, I think I’ve guessed what you want !

          So, could you try the following regex S/R against your file ?

          SEARCH (?xs-i) <Ticket\x20 .+? <!\x5B CDATA \x5B ( .+? ) \x5D\x5D> </Content> \R </Ticket> \R?

          REPLACE $1\r\n     or     $1\n with Unix files

          Use, either, the Replace or Replace All button

          See you later !

          Best Regards,

          guy038

          BTW, you said :

          Can anyone help me with this please

          And add :

          it really bothers me

          Well, I suppose it’s the same thing for every of us : we all want to find a way to get the job done !!

          1 Reply Last reply Reply Quote 0
          • holczmann raul
            holczmann raul @Alan Kilborn last edited by

            @Alan-Kilborn Thank you for investing your time in my problem.
            Unfortunately it deletes every this except the first line, like this.
            e2ea7c79-e0d9-4beb-aa66-a29601569e33-image.png

            And i need the selected orange text to remain.
            5cd62f4d-51f3-4d3b-a851-fa9c971ec48d-image.png From ‘UNA:+? to 1+788’ has to remain

            Thank you

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

              Hello, @holczmann-raul, @alan-kilborn and All,

              @holczmann-raul :

              First of all, it’s not @alan-kilborn which is trying to find out a solution to your problem but @guy038 !!


              Now, how do you expect me to modifiy the different pictures that you pasted, with some regexes ?

              So, please, when replying in this forum, paste your file contents as text, by clicking on the red icon, below :

              85813c97-5fa8-4fc7-96cc-3e782f7ff07a-Capture d’écran 2022-03-07 123711 (2).png

              Thanks for your cooperation !

              See you later !

              guy038

              Alan Kilborn holczmann raul 2 Replies Last reply Reply Quote 1
              • Alan Kilborn
                Alan Kilborn @guy038 last edited by

                @guy038

                The moral of the story is, take a glance at the problem that is not presented well, and if there is any aspect that is unclear, do not try to answer, simply refer poster to the FAQ area for how to ask their question properly.

                1 Reply Last reply Reply Quote 1
                • holczmann raul
                  holczmann raul @guy038 last edited by

                  Hello @guy038 ,

                  I replied to the wrong person, sorry. Thank you for taking your time with this problem.

                  I am trying to wright my problem as clear as I can but my English is not that good.

                  This is the text I have problems with.

                  <?xml version="1.0" encoding="utf-8"?>
                  <Ticket xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
                      <TransportType>SFTP</TransportType>
                      <CodePage>28591</CodePage>
                      <Host>ebibkom.deutschepost.de</Host>
                      <User>pep04991</User>
                      <Password>N3pXJ8LDSYVEf4Z#</Password>
                      <RemotePath>/prod/in/5022756492_27_01_786_20220911.dat</RemotePath>
                      <HttpImplicitAuthentification>false</HttpImplicitAuthentification>
                      <HttpAccept>text/xml</HttpAccept>
                      <HttpMethod>POST</HttpMethod>
                      <HttpContentType>multipart/mixed; boundary=BOUNDARY</HttpContentType>
                      <HttpHeaders />
                      <LastSendTime>2022-09-22T10:58:48.3659602+02:00</LastSendTime>
                      <Trials>2</Trials>
                      <MaxTrials>1500</MaxTrials>
                      <MinutesBetweenTrials>5</MinutesBetweenTrials>
                      <Alerts>0</Alerts>
                      <AlertInterval>20</AlertInterval>
                      <ContentFileSubdir>ContentDHL</ContentFileSubdir>
                      <MustStoreContentFile>true</MustStoreContentFile>
                      <Attachments />
                      <ErrorMessages />
                      <EmailAddressReceiverCC />
                      <ErrorMessage />
                      <IsSent>true</IsSent>
                      <Content><![CDATA[UNA:+.? 'UNB+UNOC:4+5022756492+3D_Message_Hub+20220911:1600+786'UNH+1+IFTMIN:D:01B:UN+DHL2.5/ProLogis SendIT V5.0'BGM+787+786+9'DTM+9:202209111600:203'TSR+++01:57:87'CNT+11:24'LOC+10+03'TOD+6++1'LOC+19+6108::21'RFF+IL:01'RFF+AAD:27'RFF+IV:50227564920127'NAD+OS+5022756492++babymarkt.de GmbH+Martener Hellweg 39+Dortmund++44379+DE'CTA+AC+:N.A.'COM+00000:TE'GID+1+1:PK'PIA+1+200000'FTX+AIQ+++nicolahesse@t-online.de'NAD+CN+++Nicola Hesse+Eintrachtstr. 51+Mülheim an der Ruhr++45478+DE'MEA+WT+AAE+KGM:7.500'RFF+CU:RE19527886'RFF+CN:40327645478?+99000900023051'PCI+18'GIN+BN+00:340434635480244400'GID+2+1:PK'PIA+1+200000'FTX+AIQ+++nicolahesse@t-online.de'NAD+CN+++Nicola Hesse+Eintrachtstr. 51+Mülheim an der Ruhr++45478+DE'MEA+WT+AAE+KGM:12.600'RFF+CU:RE19527886'RFF+CN:40327645478?+99000900023051'PCI+18'GIN+BN+00:340434635480244417'GID+3+1:PK'PIA+1+200000'FTX+AIQ+++mireidreisbach@posteo.de'NAD+CN+++Mirei Dreisbach+Moritzstr. 18+Berlin++10969+DE'MEA+WT+AAE+KGM:16.000'RFF+CU:RE19528105'RFF+CN:40327610969?+99000900025018'PCI+18'GIN+BN+00:340434635480244592'GID+4+1:PK'PIA+1+200000'FTX+AIQ+++mireidreisbach@posteo.de'NAD+CN+++Mirei Dreisbach+Moritzstr. 18+Berlin++10969+DE'MEA+WT+AAE+KGM:5.000'RFF+CU:RE19528105'RFF+CN:40327610969?+99000900025018'PCI+18'GIN+BN+00:340434635480244608'GID+5+1:PK'PIA+1+200000'FTX+AIQ+++l_b1995@yahoo.de'NAD+CN+++Latisha Baumann+Gottfried-Ullrich-Str. 1+Zwönitz++08297+DE'MEA+WT+AAE+KGM:5.000'RFF+CU:RE19528341'RFF+CN:40327608297?+99000900172001'PCI+18'GIN+BN+00:340434635480244561'GID+6+1:PK'PIA+1+200000'FTX+AIQ+++l_b1995@yahoo.de'NAD+CN+++Latisha Baumann+Gottfried-Ullrich-Str. 1+Zwönitz++08297+DE'MEA+WT+AAE+KGM:8.000'RFF+CU:RE19528341'RFF+CN:40327608297?+99000900172001'PCI+18'GIN+BN+00:340434635480244578'GID+7+1:PK'PIA+1+200000'FTX+AIQ+++daniel.czullay@gmx.de'NAD+CN+++daniel czullay+Mies-Van-Der-Rohe-Str. 8+Potsdam++14469+DE'MEA+WT+AAE+KGM:0.900'RFF+CU:RE19529159'RFF+CN:40327614469?+99000900301008'PCI+18'GIN+BN+00:340434635480244639'GID+8+1:PK'PIA+1+200000'FTX+AIQ+++isabelspieker@googlemail.com'NAD+CN+++Isabel Spieker+Birkenstr. 4+Giesen++31180+DE'MEA+WT+AAE+KGM:19.600'RFF+CU:RE19528404'RFF+CN:40327631180?+99000900023004'PCI+18'GIN+BN+00:340434635480244424'GID+9+1:PK'PIA+1+200000'FTX+AIQ+++felicaneubauer@gmail.com'NAD+CN+++Felica Neubauer+Bahnhofstr. 3 1+Schwaikheim++71409+DE'MEA+WT+AAE+KGM:14.000'RFF+CU:RE19528208'RFF+CN:40327671409?+99000900009003'PCI+18'GIN+BN+00:340434635480244431'GID+10+1:PK'PIA+1+200000'FTX+AIQ+++nadine.donat82.nd@gmail.com'NAD+CN+++Nadine Donat+Gartenstr. 24+Schortens++26419+DE'MEA+WT+AAE+KGM:11.000'RFF+CU:RE19528251'RFF+CN:40327626419?+99000900091024'PCI+18'GIN+BN+00:340434635480244448'GID+11+1:PK'PIA+1+200000'FTX+AIQ+++cholawski.nicole@gmail.com'NAD+CN+++Nicole Cholawski+Spreeweg 6+Köln++50765+DE'MEA+WT+AAE+KGM:12.100'RFF+CU:RE19528477'RFF+CN:40327650765?+99000900128006'PCI+18'GIN+BN+00:340434635480244455'GID+12+1:PK'PIA+1+200000'FTX+AIQ+++nicolekeinprecht@gmail.com'NAD+CN+++Nicole Keinprecht+Lübecker Str. 56+Lüneburg++21337+DE'MEA+WT+AAE+KGM:10.000'RFF+CU:RE19528346'RFF+CN:40327621337?+99000900247056'PCI+18'GIN+BN+00:340434635480244462'GID+13+1:PK'PIA+1+200000'FTX+AIQ+++samya-malki9@hotmail.de'NAD+CN+++Samya Malki+Emdener Str. 1+Frankfurt am Main++65933+DE'MEA+WT+AAE+KGM:15.000'RFF+CU:RE19528312'RFF+CN:40327665933?+99000900036001'PCI+18'GIN+BN+00:340434635480244479'GID+14+1:PK'PIA+1+200000'FTX+AIQ+++k.fuchs138@gmail.com'NAD+CN+++Katrin Fuchs+Blumenstr. 18+Erfurt++99092+DE'MEA+WT+AAE+KGM:12.400'RFF+CU:RE19528269'RFF+CN:40327699092?+99000900021018'PCI+18'GIN+BN+00:340434635480244486'GID+15+1:PK'PIA+1+200000'FTX+AIQ+++bauermeisterlisa@yahoo.de'NAD+CN+++Lisa Bauermeister+Brotsack 39D+Calbe++39240+DE'MEA+WT+AAE+KGM:5.300'RFF+CU:RE19526907'RFF+CN:40327639240?+99000900106039'PCI+18'GIN+BN+00:340434635480244493'GID+16+1:PK'PIA+1+200000'FTX+AIQ+++stefanmikla@hotmail.de'NAD+CN+++Stefan Mikla+Schulbergstr. 20+Passau++94034+DE'MEA+WT+AAE+KGM:15.000'RFF+CU:RE19527374'RFF+CN:40327694034?+99000900179020'PCI+18'GIN+BN+00:340434635480244509'GID+17+1:PK'PIA+1+200000'FTX+AIQ+++maxi_engelhardt@gmx.de'NAD+CN+++Maxi Engelhardt+Lilienstr. 14+Hohenwarsleben++39326+DE'MEA+WT+AAE+KGM:7.400'RFF+CU:RE19527375'RFF+CN:40327639326?+99000900299014'PCI+18'GIN+BN+00:340434635480244516'GID+18+1:PK'PIA+1+200000'FTX+AIQ+++katrin-stolley@gmx.de'NAD+CN+++Katrin Klotzbücher+Eiderstr. 10a+Breiholz++24797+DE'MEA+WT+AAE+KGM:19.300'RFF+CU:RE19527307'RFF+CN:40327624797?+99000900015010'PCI+18'GIN+BN+00:340434635480244523'GID+19+1:PK'PIA+1+200000'FTX+AIQ+++inalieder@aol.com'NAD+CN+++Ina Woldag+Am Schulgarten 11+Cölbe++35091+DE'MEA+WT+AAE+KGM:22.000'RFF+CU:RE19526936'RFF+CN:40327635091?+99000900017011'PCI+18'GIN+BN+00:340434635480244530'GID+20+1:PK'PIA+1+200000'FTX+AIQ+++brigitte.aldinger1503@web.de'NAD+CN+++Brigitte Aldinger+Paul-Klee-Weg 5+Künzelsau++74653+DE'MEA+WT+AAE+KGM:0.300'RFF+CU:RE19527042'RFF+CN:40327674653?+99000900303005'PCI+18'GIN+BN+00:340434635480244547'GID+21+1:PK'PIA+1+200000'FTX+AIQ+++s.ringhut@freenet.de'NAD+CN+++Sabrina Fischer+Am Reuthenberg 20+Harburg Schwaben++86655+DE'MEA+WT+AAE+KGM:0.800'RFF+CU:RE19526843'RFF+CN:40327686655?+99000900099020'PCI+18'GIN+BN+00:340434635480244554'GID+22+1:PK'PIA+1+200000'FTX+AIQ+++tobiastautz@web.de'NAD+CN+++Tobias Tautz+Auf der Bommerbank 5+Witten++58452+DE'MEA+WT+AAE+KGM:4.400'RFF+CU:RE19526950'RFF+CN:40327658452?+99000900021005'PCI+18'GIN+BN+00:340434635480244585'GID+23+1:PK'PIA+1+200000'FTX+AIQ+++lilli.hartkamp@aol.com'NAD+CN+++Lilli Hartkamp+Im Thüle 2B+Rietberg++33397+DE'MEA+WT+AAE+KGM:3.200'RFF+CU:RE19529196'RFF+CN:40327633397?+99000900305002'PCI+18'GIN+BN+00:340434635480244615'GID+24+1:PK'PIA+1+200000'FTX+AIQ+++lilli.hartkamp@aol.com'NAD+CN+++Lilli Hartkamp+Im Thüle 2B+Rietberg++33397+DE'MEA+WT+AAE+KGM:17.400'RFF+CU:RE19529196'RFF+CN:40327633397?+99000900305002'PCI+18'GIN+BN+00:340434635480244622'UNT+231+1'UNZ+1+786']]></Content>
                  </Ticket>
                  

                  And I would need it to look like this:

                  UNA:+.? 'UNB+UNOC:4+5022756492+3D_Message_Hub+20220911:1600+786'UNH+1+IFTMIN:D:01B:UN+DHL2.5/ProLogis SendIT V5.0'BGM+787+786+9'DTM+9:202209111600:203'TSR+++01:57:87'CNT+11:24'LOC+10+03'TOD+6++1'LOC+19+6108::21'RFF+IL:01'RFF+AAD:27'RFF+IV:50227564920127'NAD+OS+5022756492++babymarkt.de GmbH+Martener Hellweg 39+Dortmund++44379+DE'CTA+AC+:N.A.'COM+00000:TE'GID+1+1:PK'PIA+1+200000'FTX+AIQ+++nicolahesse@t-online.de'NAD+CN+++Nicola Hesse+Eintrachtstr. 51+Mülheim an der Ruhr++45478+DE'MEA+WT+AAE+KGM:7.500'RFF+CU:RE19527886'RFF+CN:40327645478?+99000900023051'PCI+18'GIN+BN+00:340434635480244400'GID+2+1:PK'PIA+1+200000'FTX+AIQ+++nicolahesse@t-online.de'NAD+CN+++Nicola Hesse+Eintrachtstr. 51+Mülheim an der Ruhr++45478+DE'MEA+WT+AAE+KGM:12.600'RFF+CU:RE19527886'RFF+CN:40327645478?+99000900023051'PCI+18'GIN+BN+00:340434635480244417'GID+3+1:PK'PIA+1+200000'FTX+AIQ+++mireidreisbach@posteo.de'NAD+CN+++Mirei Dreisbach+Moritzstr. 18+Berlin++10969+DE'MEA+WT+AAE+KGM:16.000'RFF+CU:RE19528105'RFF+CN:40327610969?+99000900025018'PCI+18'GIN+BN+00:340434635480244592'GID+4+1:PK'PIA+1+200000'FTX+AIQ+++mireidreisbach@posteo.de'NAD+CN+++Mirei Dreisbach+Moritzstr. 18+Berlin++10969+DE'MEA+WT+AAE+KGM:5.000'RFF+CU:RE19528105'RFF+CN:40327610969?+99000900025018'PCI+18'GIN+BN+00:340434635480244608'GID+5+1:PK'PIA+1+200000'FTX+AIQ+++l_b1995@yahoo.de'NAD+CN+++Latisha Baumann+Gottfried-Ullrich-Str. 1+Zwönitz++08297+DE'MEA+WT+AAE+KGM:5.000'RFF+CU:RE19528341'RFF+CN:40327608297?+99000900172001'PCI+18'GIN+BN+00:340434635480244561'GID+6+1:PK'PIA+1+200000'FTX+AIQ+++l_b1995@yahoo.de'NAD+CN+++Latisha Baumann+Gottfried-Ullrich-Str. 1+Zwönitz++08297+DE'MEA+WT+AAE+KGM:8.000'RFF+CU:RE19528341'RFF+CN:40327608297?+99000900172001'PCI+18'GIN+BN+00:340434635480244578'GID+7+1:PK'PIA+1+200000'FTX+AIQ+++daniel.czullay@gmx.de'NAD+CN+++daniel czullay+Mies-Van-Der-Rohe-Str. 8+Potsdam++14469+DE'MEA+WT+AAE+KGM:0.900'RFF+CU:RE19529159'RFF+CN:40327614469?+99000900301008'PCI+18'GIN+BN+00:340434635480244639'GID+8+1:PK'PIA+1+200000'FTX+AIQ+++isabelspieker@googlemail.com'NAD+CN+++Isabel Spieker+Birkenstr. 4+Giesen++31180+DE'MEA+WT+AAE+KGM:19.600'RFF+CU:RE19528404'RFF+CN:40327631180?+99000900023004'PCI+18'GIN+BN+00:340434635480244424'GID+9+1:PK'PIA+1+200000'FTX+AIQ+++felicaneubauer@gmail.com'NAD+CN+++Felica Neubauer+Bahnhofstr. 3 1+Schwaikheim++71409+DE'MEA+WT+AAE+KGM:14.000'RFF+CU:RE19528208'RFF+CN:40327671409?+99000900009003'PCI+18'GIN+BN+00:340434635480244431'GID+10+1:PK'PIA+1+200000'FTX+AIQ+++nadine.donat82.nd@gmail.com'NAD+CN+++Nadine Donat+Gartenstr. 24+Schortens++26419+DE'MEA+WT+AAE+KGM:11.000'RFF+CU:RE19528251'RFF+CN:40327626419?+99000900091024'PCI+18'GIN+BN+00:340434635480244448'GID+11+1:PK'PIA+1+200000'FTX+AIQ+++cholawski.nicole@gmail.com'NAD+CN+++Nicole Cholawski+Spreeweg 6+Köln++50765+DE'MEA+WT+AAE+KGM:12.100'RFF+CU:RE19528477'RFF+CN:40327650765?+99000900128006'PCI+18'GIN+BN+00:340434635480244455'GID+12+1:PK'PIA+1+200000'FTX+AIQ+++nicolekeinprecht@gmail.com'NAD+CN+++Nicole Keinprecht+Lübecker Str. 56+Lüneburg++21337+DE'MEA+WT+AAE+KGM:10.000'RFF+CU:RE19528346'RFF+CN:40327621337?+99000900247056'PCI+18'GIN+BN+00:340434635480244462'GID+13+1:PK'PIA+1+200000'FTX+AIQ+++samya-malki9@hotmail.de'NAD+CN+++Samya Malki+Emdener Str. 1+Frankfurt am Main++65933+DE'MEA+WT+AAE+KGM:15.000'RFF+CU:RE19528312'RFF+CN:40327665933?+99000900036001'PCI+18'GIN+BN+00:340434635480244479'GID+14+1:PK'PIA+1+200000'FTX+AIQ+++k.fuchs138@gmail.com'NAD+CN+++Katrin Fuchs+Blumenstr. 18+Erfurt++99092+DE'MEA+WT+AAE+KGM:12.400'RFF+CU:RE19528269'RFF+CN:40327699092?+99000900021018'PCI+18'GIN+BN+00:340434635480244486'GID+15+1:PK'PIA+1+200000'FTX+AIQ+++bauermeisterlisa@yahoo.de'NAD+CN+++Lisa Bauermeister+Brotsack 39D+Calbe++39240+DE'MEA+WT+AAE+KGM:5.300'RFF+CU:RE19526907'RFF+CN:40327639240?+99000900106039'PCI+18'GIN+BN+00:340434635480244493'GID+16+1:PK'PIA+1+200000'FTX+AIQ+++stefanmikla@hotmail.de'NAD+CN+++Stefan Mikla+Schulbergstr. 20+Passau++94034+DE'MEA+WT+AAE+KGM:15.000'RFF+CU:RE19527374'RFF+CN:40327694034?+99000900179020'PCI+18'GIN+BN+00:340434635480244509'GID+17+1:PK'PIA+1+200000'FTX+AIQ+++maxi_engelhardt@gmx.de'NAD+CN+++Maxi Engelhardt+Lilienstr. 14+Hohenwarsleben++39326+DE'MEA+WT+AAE+KGM:7.400'RFF+CU:RE19527375'RFF+CN:40327639326?+99000900299014'PCI+18'GIN+BN+00:340434635480244516'GID+18+1:PK'PIA+1+200000'FTX+AIQ+++katrin-stolley@gmx.de'NAD+CN+++Katrin Klotzbücher+Eiderstr. 10a+Breiholz++24797+DE'MEA+WT+AAE+KGM:19.300'RFF+CU:RE19527307'RFF+CN:40327624797?+99000900015010'PCI+18'GIN+BN+00:340434635480244523'GID+19+1:PK'PIA+1+200000'FTX+AIQ+++inalieder@aol.com'NAD+CN+++Ina Woldag+Am Schulgarten 11+Cölbe++35091+DE'MEA+WT+AAE+KGM:22.000'RFF+CU:RE19526936'RFF+CN:40327635091?+99000900017011'PCI+18'GIN+BN+00:340434635480244530'GID+20+1:PK'PIA+1+200000'FTX+AIQ+++brigitte.aldinger1503@web.de'NAD+CN+++Brigitte Aldinger+Paul-Klee-Weg 5+Künzelsau++74653+DE'MEA+WT+AAE+KGM:0.300'RFF+CU:RE19527042'RFF+CN:40327674653?+99000900303005'PCI+18'GIN+BN+00:340434635480244547'GID+21+1:PK'PIA+1+200000'FTX+AIQ+++s.ringhut@freenet.de'NAD+CN+++Sabrina Fischer+Am Reuthenberg 20+Harburg Schwaben++86655+DE'MEA+WT+AAE+KGM:0.800'RFF+CU:RE19526843'RFF+CN:40327686655?+99000900099020'PCI+18'GIN+BN+00:340434635480244554'GID+22+1:PK'PIA+1+200000'FTX+AIQ+++tobiastautz@web.de'NAD+CN+++Tobias Tautz+Auf der Bommerbank 5+Witten++58452+DE'MEA+WT+AAE+KGM:4.400'RFF+CU:RE19526950'RFF+CN:40327658452?+99000900021005'PCI+18'GIN+BN+00:340434635480244585'GID+23+1:PK'PIA+1+200000'FTX+AIQ+++lilli.hartkamp@aol.com'NAD+CN+++Lilli Hartkamp+Im Thüle 2B+Rietberg++33397+DE'MEA+WT+AAE+KGM:3.200'RFF+CU:RE19529196'RFF+CN:40327633397?+99000900305002'PCI+18'GIN+BN+00:340434635480244615'GID+24+1:PK'PIA+1+200000'FTX+AIQ+++lilli.hartkamp@aol.com'NAD+CN+++Lilli Hartkamp+Im Thüle 2B+Rietberg++33397+DE'MEA+WT+AAE+KGM:17.400'RFF+CU:RE19529196'RFF+CN:40327633397?+99000900305002'PCI+18'GIN+BN+00:340434635480244622'UNT+231+1'UNZ+1+786
                  

                  I need to do this with ‘Replace All in All Opened Documents’

                  Thank you and once again sorry for the confusion.

                  Raul

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

                    Hello, @holczmann-raul,

                    Thanks you for this version. It’s perfect !

                    I’ll be back in about 3 hours !

                    BR

                    guy038

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

                      Hi, @holczmann-raul, @alan-kilborn and All,

                      First of all, sorry for my absence, longer than expected !


                      But indeed, I do not understand why my previous regex did not work for you ?

                      Of course, in my previous regex, I kept the very first line :

                      <?xml version="1.0" encoding="utf-8"?>

                      But you should had got the correct results !


                      Thus, here is my second version which deletes the very first line, as well !

                      So, from the INPUT text :

                      <?xml version="1.0" encoding="utf-8"?>
                      <Ticket xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
                          <TransportType>SFTP</TransportType>
                          <CodePage>28591</CodePage>
                          <Host>ebibkom.deutschepost.de</Host>
                          <User>pep04991</User>
                          <Password>N3pXJ8LDSYVEf4Z#</Password>
                          <RemotePath>/prod/in/5022756492_27_01_786_20220911.dat</RemotePath>
                          <HttpImplicitAuthentification>false</HttpImplicitAuthentification>
                          <HttpAccept>text/xml</HttpAccept>
                          <HttpMethod>POST</HttpMethod>
                          <HttpContentType>multipart/mixed; boundary=BOUNDARY</HttpContentType>
                          <HttpHeaders />
                          <LastSendTime>2022-09-22T10:58:48.3659602+02:00</LastSendTime>
                          <Trials>2</Trials>
                          <MaxTrials>1500</MaxTrials>
                          <MinutesBetweenTrials>5</MinutesBetweenTrials>
                          <Alerts>0</Alerts>
                          <AlertInterval>20</AlertInterval>
                          <ContentFileSubdir>ContentDHL</ContentFileSubdir>
                          <MustStoreContentFile>true</MustStoreContentFile>
                          <Attachments />
                          <ErrorMessages />
                          <EmailAddressReceiverCC />
                          <ErrorMessage />
                          <IsSent>true</IsSent>
                          <Content><![CDATA[UNA:+.? 'UNB+UNOC:4+5022756492+3D_Message_Hub+20220911:1600+786'UNH+1+IFTMIN:D:01B:UN+DHL2.5/ProLogis SendIT V5.0'BGM+787+786+9'DTM+9:202209111600:203'TSR+++01:57:87'CNT+11:24'LOC+10+03'TOD+6++1'LOC+19+6108::21'RFF+IL:01'RFF+AAD:27'RFF+IV:50227564920127'NAD+OS+5022756492++babymarkt.de GmbH+Martener Hellweg 39+Dortmund++44379+DE'CTA+AC+:N.A.'COM+00000:TE'GID+1+1:PK'PIA+1+200000'FTX+AIQ+++nicolahesse@t-online.de'NAD+CN+++Nicola Hesse+Eintrachtstr. 51+Mülheim an der Ruhr++45478+DE'MEA+WT+AAE+KGM:7.500'RFF+CU:RE19527886'RFF+CN:40327645478?+99000900023051'PCI+18'GIN+BN+00:340434635480244400'GID+2+1:PK'PIA+1+200000'FTX+AIQ+++nicolahesse@t-online.de'NAD+CN+++Nicola Hesse+Eintrachtstr. 51+Mülheim an der Ruhr++45478+DE'MEA+WT+AAE+KGM:12.600'RFF+CU:RE19527886'RFF+CN:40327645478?+99000900023051'PCI+18'GIN+BN+00:340434635480244417'GID+3+1:PK'PIA+1+200000'FTX+AIQ+++mireidreisbach@posteo.de'NAD+CN+++Mirei Dreisbach+Moritzstr. 18+Berlin++10969+DE'MEA+WT+AAE+KGM:16.000'RFF+CU:RE19528105'RFF+CN:40327610969?+99000900025018'PCI+18'GIN+BN+00:340434635480244592'GID+4+1:PK'PIA+1+200000'FTX+AIQ+++mireidreisbach@posteo.de'NAD+CN+++Mirei Dreisbach+Moritzstr. 18+Berlin++10969+DE'MEA+WT+AAE+KGM:5.000'RFF+CU:RE19528105'RFF+CN:40327610969?+99000900025018'PCI+18'GIN+BN+00:340434635480244608'GID+5+1:PK'PIA+1+200000'FTX+AIQ+++l_b1995@yahoo.de'NAD+CN+++Latisha Baumann+Gottfried-Ullrich-Str. 1+Zwönitz++08297+DE'MEA+WT+AAE+KGM:5.000'RFF+CU:RE19528341'RFF+CN:40327608297?+99000900172001'PCI+18'GIN+BN+00:340434635480244561'GID+6+1:PK'PIA+1+200000'FTX+AIQ+++l_b1995@yahoo.de'NAD+CN+++Latisha Baumann+Gottfried-Ullrich-Str. 1+Zwönitz++08297+DE'MEA+WT+AAE+KGM:8.000'RFF+CU:RE19528341'RFF+CN:40327608297?+99000900172001'PCI+18'GIN+BN+00:340434635480244578'GID+7+1:PK'PIA+1+200000'FTX+AIQ+++daniel.czullay@gmx.de'NAD+CN+++daniel czullay+Mies-Van-Der-Rohe-Str. 8+Potsdam++14469+DE'MEA+WT+AAE+KGM:0.900'RFF+CU:RE19529159'RFF+CN:40327614469?+99000900301008'PCI+18'GIN+BN+00:340434635480244639'GID+8+1:PK'PIA+1+200000'FTX+AIQ+++isabelspieker@googlemail.com'NAD+CN+++Isabel Spieker+Birkenstr. 4+Giesen++31180+DE'MEA+WT+AAE+KGM:19.600'RFF+CU:RE19528404'RFF+CN:40327631180?+99000900023004'PCI+18'GIN+BN+00:340434635480244424'GID+9+1:PK'PIA+1+200000'FTX+AIQ+++felicaneubauer@gmail.com'NAD+CN+++Felica Neubauer+Bahnhofstr. 3 1+Schwaikheim++71409+DE'MEA+WT+AAE+KGM:14.000'RFF+CU:RE19528208'RFF+CN:40327671409?+99000900009003'PCI+18'GIN+BN+00:340434635480244431'GID+10+1:PK'PIA+1+200000'FTX+AIQ+++nadine.donat82.nd@gmail.com'NAD+CN+++Nadine Donat+Gartenstr. 24+Schortens++26419+DE'MEA+WT+AAE+KGM:11.000'RFF+CU:RE19528251'RFF+CN:40327626419?+99000900091024'PCI+18'GIN+BN+00:340434635480244448'GID+11+1:PK'PIA+1+200000'FTX+AIQ+++cholawski.nicole@gmail.com'NAD+CN+++Nicole Cholawski+Spreeweg 6+Köln++50765+DE'MEA+WT+AAE+KGM:12.100'RFF+CU:RE19528477'RFF+CN:40327650765?+99000900128006'PCI+18'GIN+BN+00:340434635480244455'GID+12+1:PK'PIA+1+200000'FTX+AIQ+++nicolekeinprecht@gmail.com'NAD+CN+++Nicole Keinprecht+Lübecker Str. 56+Lüneburg++21337+DE'MEA+WT+AAE+KGM:10.000'RFF+CU:RE19528346'RFF+CN:40327621337?+99000900247056'PCI+18'GIN+BN+00:340434635480244462'GID+13+1:PK'PIA+1+200000'FTX+AIQ+++samya-malki9@hotmail.de'NAD+CN+++Samya Malki+Emdener Str. 1+Frankfurt am Main++65933+DE'MEA+WT+AAE+KGM:15.000'RFF+CU:RE19528312'RFF+CN:40327665933?+99000900036001'PCI+18'GIN+BN+00:340434635480244479'GID+14+1:PK'PIA+1+200000'FTX+AIQ+++k.fuchs138@gmail.com'NAD+CN+++Katrin Fuchs+Blumenstr. 18+Erfurt++99092+DE'MEA+WT+AAE+KGM:12.400'RFF+CU:RE19528269'RFF+CN:40327699092?+99000900021018'PCI+18'GIN+BN+00:340434635480244486'GID+15+1:PK'PIA+1+200000'FTX+AIQ+++bauermeisterlisa@yahoo.de'NAD+CN+++Lisa Bauermeister+Brotsack 39D+Calbe++39240+DE'MEA+WT+AAE+KGM:5.300'RFF+CU:RE19526907'RFF+CN:40327639240?+99000900106039'PCI+18'GIN+BN+00:340434635480244493'GID+16+1:PK'PIA+1+200000'FTX+AIQ+++stefanmikla@hotmail.de'NAD+CN+++Stefan Mikla+Schulbergstr. 20+Passau++94034+DE'MEA+WT+AAE+KGM:15.000'RFF+CU:RE19527374'RFF+CN:40327694034?+99000900179020'PCI+18'GIN+BN+00:340434635480244509'GID+17+1:PK'PIA+1+200000'FTX+AIQ+++maxi_engelhardt@gmx.de'NAD+CN+++Maxi Engelhardt+Lilienstr. 14+Hohenwarsleben++39326+DE'MEA+WT+AAE+KGM:7.400'RFF+CU:RE19527375'RFF+CN:40327639326?+99000900299014'PCI+18'GIN+BN+00:340434635480244516'GID+18+1:PK'PIA+1+200000'FTX+AIQ+++katrin-stolley@gmx.de'NAD+CN+++Katrin Klotzbücher+Eiderstr. 10a+Breiholz++24797+DE'MEA+WT+AAE+KGM:19.300'RFF+CU:RE19527307'RFF+CN:40327624797?+99000900015010'PCI+18'GIN+BN+00:340434635480244523'GID+19+1:PK'PIA+1+200000'FTX+AIQ+++inalieder@aol.com'NAD+CN+++Ina Woldag+Am Schulgarten 11+Cölbe++35091+DE'MEA+WT+AAE+KGM:22.000'RFF+CU:RE19526936'RFF+CN:40327635091?+99000900017011'PCI+18'GIN+BN+00:340434635480244530'GID+20+1:PK'PIA+1+200000'FTX+AIQ+++brigitte.aldinger1503@web.de'NAD+CN+++Brigitte Aldinger+Paul-Klee-Weg 5+Künzelsau++74653+DE'MEA+WT+AAE+KGM:0.300'RFF+CU:RE19527042'RFF+CN:40327674653?+99000900303005'PCI+18'GIN+BN+00:340434635480244547'GID+21+1:PK'PIA+1+200000'FTX+AIQ+++s.ringhut@freenet.de'NAD+CN+++Sabrina Fischer+Am Reuthenberg 20+Harburg Schwaben++86655+DE'MEA+WT+AAE+KGM:0.800'RFF+CU:RE19526843'RFF+CN:40327686655?+99000900099020'PCI+18'GIN+BN+00:340434635480244554'GID+22+1:PK'PIA+1+200000'FTX+AIQ+++tobiastautz@web.de'NAD+CN+++Tobias Tautz+Auf der Bommerbank 5+Witten++58452+DE'MEA+WT+AAE+KGM:4.400'RFF+CU:RE19526950'RFF+CN:40327658452?+99000900021005'PCI+18'GIN+BN+00:340434635480244585'GID+23+1:PK'PIA+1+200000'FTX+AIQ+++lilli.hartkamp@aol.com'NAD+CN+++Lilli Hartkamp+Im Thüle 2B+Rietberg++33397+DE'MEA+WT+AAE+KGM:3.200'RFF+CU:RE19529196'RFF+CN:40327633397?+99000900305002'PCI+18'GIN+BN+00:340434635480244615'GID+24+1:PK'PIA+1+200000'FTX+AIQ+++lilli.hartkamp@aol.com'NAD+CN+++Lilli Hartkamp+Im Thüle 2B+Rietberg++33397+DE'MEA+WT+AAE+KGM:17.400'RFF+CU:RE19529196'RFF+CN:40327633397?+99000900305002'PCI+18'GIN+BN+00:340434635480244622'UNT+231+1'UNZ+1+786']]></Content>
                      </Ticket>
                      

                      With the following regex S/R :

                      SEARCH (?xs-i) \Q<?xml version="1.0" encoding="utf-8"?>\E \R <Ticket\x20 .+? <!\x5B CDATA \x5B ( .+? ) \x5D\x5D> </Content> \R </Ticket> \R?

                      REPLACE $1\r\n     or     $1\n for Unix files

                      You should get the expected OUTPUT :

                      UNA:+.? 'UNB+UNOC:4+5022756492+3D_Message_Hub+20220911:1600+786'UNH+1+IFTMIN:D:01B:UN+DHL2.5/ProLogis SendIT V5.0'BGM+787+786+9'DTM+9:202209111600:203'TSR+++01:57:87'CNT+11:24'LOC+10+03'TOD+6++1'LOC+19+6108::21'RFF+IL:01'RFF+AAD:27'RFF+IV:50227564920127'NAD+OS+5022756492++babymarkt.de GmbH+Martener Hellweg 39+Dortmund++44379+DE'CTA+AC+:N.A.'COM+00000:TE'GID+1+1:PK'PIA+1+200000'FTX+AIQ+++nicolahesse@t-online.de'NAD+CN+++Nicola Hesse+Eintrachtstr. 51+Mülheim an der Ruhr++45478+DE'MEA+WT+AAE+KGM:7.500'RFF+CU:RE19527886'RFF+CN:40327645478?+99000900023051'PCI+18'GIN+BN+00:340434635480244400'GID+2+1:PK'PIA+1+200000'FTX+AIQ+++nicolahesse@t-online.de'NAD+CN+++Nicola Hesse+Eintrachtstr. 51+Mülheim an der Ruhr++45478+DE'MEA+WT+AAE+KGM:12.600'RFF+CU:RE19527886'RFF+CN:40327645478?+99000900023051'PCI+18'GIN+BN+00:340434635480244417'GID+3+1:PK'PIA+1+200000'FTX+AIQ+++mireidreisbach@posteo.de'NAD+CN+++Mirei Dreisbach+Moritzstr. 18+Berlin++10969+DE'MEA+WT+AAE+KGM:16.000'RFF+CU:RE19528105'RFF+CN:40327610969?+99000900025018'PCI+18'GIN+BN+00:340434635480244592'GID+4+1:PK'PIA+1+200000'FTX+AIQ+++mireidreisbach@posteo.de'NAD+CN+++Mirei Dreisbach+Moritzstr. 18+Berlin++10969+DE'MEA+WT+AAE+KGM:5.000'RFF+CU:RE19528105'RFF+CN:40327610969?+99000900025018'PCI+18'GIN+BN+00:340434635480244608'GID+5+1:PK'PIA+1+200000'FTX+AIQ+++l_b1995@yahoo.de'NAD+CN+++Latisha Baumann+Gottfried-Ullrich-Str. 1+Zwönitz++08297+DE'MEA+WT+AAE+KGM:5.000'RFF+CU:RE19528341'RFF+CN:40327608297?+99000900172001'PCI+18'GIN+BN+00:340434635480244561'GID+6+1:PK'PIA+1+200000'FTX+AIQ+++l_b1995@yahoo.de'NAD+CN+++Latisha Baumann+Gottfried-Ullrich-Str. 1+Zwönitz++08297+DE'MEA+WT+AAE+KGM:8.000'RFF+CU:RE19528341'RFF+CN:40327608297?+99000900172001'PCI+18'GIN+BN+00:340434635480244578'GID+7+1:PK'PIA+1+200000'FTX+AIQ+++daniel.czullay@gmx.de'NAD+CN+++daniel czullay+Mies-Van-Der-Rohe-Str. 8+Potsdam++14469+DE'MEA+WT+AAE+KGM:0.900'RFF+CU:RE19529159'RFF+CN:40327614469?+99000900301008'PCI+18'GIN+BN+00:340434635480244639'GID+8+1:PK'PIA+1+200000'FTX+AIQ+++isabelspieker@googlemail.com'NAD+CN+++Isabel Spieker+Birkenstr. 4+Giesen++31180+DE'MEA+WT+AAE+KGM:19.600'RFF+CU:RE19528404'RFF+CN:40327631180?+99000900023004'PCI+18'GIN+BN+00:340434635480244424'GID+9+1:PK'PIA+1+200000'FTX+AIQ+++felicaneubauer@gmail.com'NAD+CN+++Felica Neubauer+Bahnhofstr. 3 1+Schwaikheim++71409+DE'MEA+WT+AAE+KGM:14.000'RFF+CU:RE19528208'RFF+CN:40327671409?+99000900009003'PCI+18'GIN+BN+00:340434635480244431'GID+10+1:PK'PIA+1+200000'FTX+AIQ+++nadine.donat82.nd@gmail.com'NAD+CN+++Nadine Donat+Gartenstr. 24+Schortens++26419+DE'MEA+WT+AAE+KGM:11.000'RFF+CU:RE19528251'RFF+CN:40327626419?+99000900091024'PCI+18'GIN+BN+00:340434635480244448'GID+11+1:PK'PIA+1+200000'FTX+AIQ+++cholawski.nicole@gmail.com'NAD+CN+++Nicole Cholawski+Spreeweg 6+Köln++50765+DE'MEA+WT+AAE+KGM:12.100'RFF+CU:RE19528477'RFF+CN:40327650765?+99000900128006'PCI+18'GIN+BN+00:340434635480244455'GID+12+1:PK'PIA+1+200000'FTX+AIQ+++nicolekeinprecht@gmail.com'NAD+CN+++Nicole Keinprecht+Lübecker Str. 56+Lüneburg++21337+DE'MEA+WT+AAE+KGM:10.000'RFF+CU:RE19528346'RFF+CN:40327621337?+99000900247056'PCI+18'GIN+BN+00:340434635480244462'GID+13+1:PK'PIA+1+200000'FTX+AIQ+++samya-malki9@hotmail.de'NAD+CN+++Samya Malki+Emdener Str. 1+Frankfurt am Main++65933+DE'MEA+WT+AAE+KGM:15.000'RFF+CU:RE19528312'RFF+CN:40327665933?+99000900036001'PCI+18'GIN+BN+00:340434635480244479'GID+14+1:PK'PIA+1+200000'FTX+AIQ+++k.fuchs138@gmail.com'NAD+CN+++Katrin Fuchs+Blumenstr. 18+Erfurt++99092+DE'MEA+WT+AAE+KGM:12.400'RFF+CU:RE19528269'RFF+CN:40327699092?+99000900021018'PCI+18'GIN+BN+00:340434635480244486'GID+15+1:PK'PIA+1+200000'FTX+AIQ+++bauermeisterlisa@yahoo.de'NAD+CN+++Lisa Bauermeister+Brotsack 39D+Calbe++39240+DE'MEA+WT+AAE+KGM:5.300'RFF+CU:RE19526907'RFF+CN:40327639240?+99000900106039'PCI+18'GIN+BN+00:340434635480244493'GID+16+1:PK'PIA+1+200000'FTX+AIQ+++stefanmikla@hotmail.de'NAD+CN+++Stefan Mikla+Schulbergstr. 20+Passau++94034+DE'MEA+WT+AAE+KGM:15.000'RFF+CU:RE19527374'RFF+CN:40327694034?+99000900179020'PCI+18'GIN+BN+00:340434635480244509'GID+17+1:PK'PIA+1+200000'FTX+AIQ+++maxi_engelhardt@gmx.de'NAD+CN+++Maxi Engelhardt+Lilienstr. 14+Hohenwarsleben++39326+DE'MEA+WT+AAE+KGM:7.400'RFF+CU:RE19527375'RFF+CN:40327639326?+99000900299014'PCI+18'GIN+BN+00:340434635480244516'GID+18+1:PK'PIA+1+200000'FTX+AIQ+++katrin-stolley@gmx.de'NAD+CN+++Katrin Klotzbücher+Eiderstr. 10a+Breiholz++24797+DE'MEA+WT+AAE+KGM:19.300'RFF+CU:RE19527307'RFF+CN:40327624797?+99000900015010'PCI+18'GIN+BN+00:340434635480244523'GID+19+1:PK'PIA+1+200000'FTX+AIQ+++inalieder@aol.com'NAD+CN+++Ina Woldag+Am Schulgarten 11+Cölbe++35091+DE'MEA+WT+AAE+KGM:22.000'RFF+CU:RE19526936'RFF+CN:40327635091?+99000900017011'PCI+18'GIN+BN+00:340434635480244530'GID+20+1:PK'PIA+1+200000'FTX+AIQ+++brigitte.aldinger1503@web.de'NAD+CN+++Brigitte Aldinger+Paul-Klee-Weg 5+Künzelsau++74653+DE'MEA+WT+AAE+KGM:0.300'RFF+CU:RE19527042'RFF+CN:40327674653?+99000900303005'PCI+18'GIN+BN+00:340434635480244547'GID+21+1:PK'PIA+1+200000'FTX+AIQ+++s.ringhut@freenet.de'NAD+CN+++Sabrina Fischer+Am Reuthenberg 20+Harburg Schwaben++86655+DE'MEA+WT+AAE+KGM:0.800'RFF+CU:RE19526843'RFF+CN:40327686655?+99000900099020'PCI+18'GIN+BN+00:340434635480244554'GID+22+1:PK'PIA+1+200000'FTX+AIQ+++tobiastautz@web.de'NAD+CN+++Tobias Tautz+Auf der Bommerbank 5+Witten++58452+DE'MEA+WT+AAE+KGM:4.400'RFF+CU:RE19526950'RFF+CN:40327658452?+99000900021005'PCI+18'GIN+BN+00:340434635480244585'GID+23+1:PK'PIA+1+200000'FTX+AIQ+++lilli.hartkamp@aol.com'NAD+CN+++Lilli Hartkamp+Im Thüle 2B+Rietberg++33397+DE'MEA+WT+AAE+KGM:3.200'RFF+CU:RE19529196'RFF+CN:40327633397?+99000900305002'PCI+18'GIN+BN+00:340434635480244615'GID+24+1:PK'PIA+1+200000'FTX+AIQ+++lilli.hartkamp@aol.com'NAD+CN+++Lilli Hartkamp+Im Thüle 2B+Rietberg++33397+DE'MEA+WT+AAE+KGM:17.400'RFF+CU:RE19529196'RFF+CN:40327633397?+99000900305002'PCI+18'GIN+BN+00:340434635480244622'UNT+231+1'UNZ+1+786'
                      

                      Voila !


                      Seemingly, you have several .xml files, with the same template, all located in a specific folder. and all opened in Notepad++

                      So, the road map is :

                      • Backup this folder, preferably

                      • Start Notepad++

                      • Open all the concerned files

                      • Move to the very beginning of one of them

                      • Open the Replace dialog ( Ctrl + H )

                      • Untick all box options

                      • SEARCH (?xs-i) \Q<?xml version="1.0" encoding="utf-8"?>\E \R <Ticket\x20 .+? <!\x5B CDATA \x5B ( .+? ) \x5D\x5D> </Content> \R </Ticket> \R?

                      • REPLACE $1\r\n     or     $1\n with Unix files

                      • Select the Regular expression search mode

                      • Click on the Replace All button

                      • If the result is OK, then click on the Replace All in All Opened Documents button

                      • Click on the File > Save All option ( Ctrl + Shift + S , by default )


                      Note that I assume that the case of the very first line and the strings <Ticket, CDATA, </Content> and </Ticket> does not change !

                      If, for instance, the word CDATA may be written as Cdata, then change the modifiers, in the first part of the search regex by (?xsi)

                      Best Regards,

                      guy038

                      holczmann raul 1 Reply Last reply Reply Quote 0
                      • holczmann raul
                        holczmann raul @guy038 last edited by

                        Hello @guy038

                        It worked like a charm! Thank you very much for your time.

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