How to leave only the following strings? Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?How can I create a class of matrices programmatically?Manipulate excel file and plotHow do I partition a matrix?How to create a table of tables?Turn the following values into percentageHow to select the data in a given way?Reading CSV data from a streamHow to remove from the data the rows of with fixed number of elements?Padding lists for accurate plottingHow to remove the given columns and strings?

Multi tool use
Multi tool use

How was Lagrange appointed professor of mathematics so early?

Why aren't these two solutions equivalent? Combinatorics problem

2 sample t test for sample sizes - 30,000 and 150,000

How to produce a PS1 prompt in bash or ksh93 similar to tcsh

Checking IFI enabled on SQL server below 2016

Unix AIX passing variable and arguments to expect and spawn

Coin Game with infinite paradox

Why did Israel vote against lifting the American embargo on Cuba?

Why does BitLocker not use RSA?

Should man-made satellites feature an intelligent inverted "cow catcher"?

Meaning of "Not holding on that level of emuna/bitachon"

Is it OK if I do not take the receipt in Germany?

Is "ein Herz wie das meine" an antiquated or colloquial use of the possesive pronoun?

Putting Ant-Man on house arrest

Determine the generator of an ideal of ring of integers

Like totally amazing interchangeable sister outfit accessory swapping or whatever

Marquee sign letters

tabularx column has extra padding at right?

Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create?

How do I deal with an erroneously large refund?

Who can become a wight?

Why doesn't the university give past final exams' answers?

How to keep bees out of canned beverages?

Etymology of 見舞い



How to leave only the following strings?



Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?How can I create a class of matrices programmatically?Manipulate excel file and plotHow do I partition a matrix?How to create a table of tables?Turn the following values into percentageHow to select the data in a given way?Reading CSV data from a streamHow to remove from the data the rows of with fixed number of elements?Padding lists for accurate plottingHow to remove the given columns and strings?










2












$begingroup$


Consider a data having the form



data = 1,7,4,6,1,6,4,8,2,4,9,2,E,...,1,4,6,3,4,4,6,2,E,...,...


i.e., some number $n_1$ of rows followed by row $E,...$, then some number $n_2$ of rows followed by row $E,...$ and so on.



Could you please tell me how to leave only the last rows before $E,$, i.e. to obtain



subdata= 2,4,9,2,4,4,6,2,...?









share|improve this question









$endgroup$







  • 1




    $begingroup$
    e.g. SequenceCases[data, x_List, E, ___ :> x]
    $endgroup$
    – C. E.
    7 hours ago















2












$begingroup$


Consider a data having the form



data = 1,7,4,6,1,6,4,8,2,4,9,2,E,...,1,4,6,3,4,4,6,2,E,...,...


i.e., some number $n_1$ of rows followed by row $E,...$, then some number $n_2$ of rows followed by row $E,...$ and so on.



Could you please tell me how to leave only the last rows before $E,$, i.e. to obtain



subdata= 2,4,9,2,4,4,6,2,...?









share|improve this question









$endgroup$







  • 1




    $begingroup$
    e.g. SequenceCases[data, x_List, E, ___ :> x]
    $endgroup$
    – C. E.
    7 hours ago













2












2








2





$begingroup$


Consider a data having the form



data = 1,7,4,6,1,6,4,8,2,4,9,2,E,...,1,4,6,3,4,4,6,2,E,...,...


i.e., some number $n_1$ of rows followed by row $E,...$, then some number $n_2$ of rows followed by row $E,...$ and so on.



Could you please tell me how to leave only the last rows before $E,$, i.e. to obtain



subdata= 2,4,9,2,4,4,6,2,...?









share|improve this question









$endgroup$




Consider a data having the form



data = 1,7,4,6,1,6,4,8,2,4,9,2,E,...,1,4,6,3,4,4,6,2,E,...,...


i.e., some number $n_1$ of rows followed by row $E,...$, then some number $n_2$ of rows followed by row $E,...$ and so on.



Could you please tell me how to leave only the last rows before $E,$, i.e. to obtain



subdata= 2,4,9,2,4,4,6,2,...?






list-manipulation data






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 7 hours ago









John TaylorJohn Taylor

787211




787211







  • 1




    $begingroup$
    e.g. SequenceCases[data, x_List, E, ___ :> x]
    $endgroup$
    – C. E.
    7 hours ago












  • 1




    $begingroup$
    e.g. SequenceCases[data, x_List, E, ___ :> x]
    $endgroup$
    – C. E.
    7 hours ago







1




1




$begingroup$
e.g. SequenceCases[data, x_List, E, ___ :> x]
$endgroup$
– C. E.
7 hours ago




$begingroup$
e.g. SequenceCases[data, x_List, E, ___ :> x]
$endgroup$
– C. E.
7 hours ago










2 Answers
2






active

oldest

votes


















2












$begingroup$

Try SequenceCases:



data = 1, 7, 4, 6, 1, 6, 4, 8, 2, 4, 9, 2, E, 1, 2, 3, 
1, 4, 6, 3, 4, 4, 6, 2, E, 4, 5, 6
SequenceCases[data, p_, E, ___ :> p]


yields



2, 4, 9, 2, 4, 4, 6, 2





share|improve this answer









$endgroup$




















    2












    $begingroup$

    The most idiomatic solution to this problem is, in my opinion, pattern matching (as Sakra has also answered):



    SequenceCases[data, x_List, E, ___ :> x]



    2, 4, 9, 2, 4, 4, 6, 2




    But the problem also lends itself to functional solutions, e.g.:



    pairs = Partition[data, 2, 1];
    If[#[[2, 1]] == E, #[[1]], Nothing] & /@ pairs



    2, 4, 9, 2, 4, 4, 6, 2




    Or in one go:



    BlockMap[If[#[[2, 1]] == E, #[[1]], Nothing] &, data, 2, 1]



    2, 4, 9, 2, 4, 4, 6, 2







    share|improve this answer











    $endgroup$













      Your Answer








      StackExchange.ready(function()
      var channelOptions =
      tags: "".split(" "),
      id: "387"
      ;
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function()
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled)
      StackExchange.using("snippets", function()
      createEditor();
      );

      else
      createEditor();

      );

      function createEditor()
      StackExchange.prepareEditor(
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: false,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: null,
      bindNavPrevention: true,
      postfix: "",
      imageUploader:
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      ,
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      );



      );













      draft saved

      draft discarded


















      StackExchange.ready(
      function ()
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f195786%2fhow-to-leave-only-the-following-strings%23new-answer', 'question_page');

      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      2












      $begingroup$

      Try SequenceCases:



      data = 1, 7, 4, 6, 1, 6, 4, 8, 2, 4, 9, 2, E, 1, 2, 3, 
      1, 4, 6, 3, 4, 4, 6, 2, E, 4, 5, 6
      SequenceCases[data, p_, E, ___ :> p]


      yields



      2, 4, 9, 2, 4, 4, 6, 2





      share|improve this answer









      $endgroup$

















        2












        $begingroup$

        Try SequenceCases:



        data = 1, 7, 4, 6, 1, 6, 4, 8, 2, 4, 9, 2, E, 1, 2, 3, 
        1, 4, 6, 3, 4, 4, 6, 2, E, 4, 5, 6
        SequenceCases[data, p_, E, ___ :> p]


        yields



        2, 4, 9, 2, 4, 4, 6, 2





        share|improve this answer









        $endgroup$















          2












          2








          2





          $begingroup$

          Try SequenceCases:



          data = 1, 7, 4, 6, 1, 6, 4, 8, 2, 4, 9, 2, E, 1, 2, 3, 
          1, 4, 6, 3, 4, 4, 6, 2, E, 4, 5, 6
          SequenceCases[data, p_, E, ___ :> p]


          yields



          2, 4, 9, 2, 4, 4, 6, 2





          share|improve this answer









          $endgroup$



          Try SequenceCases:



          data = 1, 7, 4, 6, 1, 6, 4, 8, 2, 4, 9, 2, E, 1, 2, 3, 
          1, 4, 6, 3, 4, 4, 6, 2, E, 4, 5, 6
          SequenceCases[data, p_, E, ___ :> p]


          yields



          2, 4, 9, 2, 4, 4, 6, 2






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 7 hours ago









          sakrasakra

          2,8231429




          2,8231429





















              2












              $begingroup$

              The most idiomatic solution to this problem is, in my opinion, pattern matching (as Sakra has also answered):



              SequenceCases[data, x_List, E, ___ :> x]



              2, 4, 9, 2, 4, 4, 6, 2




              But the problem also lends itself to functional solutions, e.g.:



              pairs = Partition[data, 2, 1];
              If[#[[2, 1]] == E, #[[1]], Nothing] & /@ pairs



              2, 4, 9, 2, 4, 4, 6, 2




              Or in one go:



              BlockMap[If[#[[2, 1]] == E, #[[1]], Nothing] &, data, 2, 1]



              2, 4, 9, 2, 4, 4, 6, 2







              share|improve this answer











              $endgroup$

















                2












                $begingroup$

                The most idiomatic solution to this problem is, in my opinion, pattern matching (as Sakra has also answered):



                SequenceCases[data, x_List, E, ___ :> x]



                2, 4, 9, 2, 4, 4, 6, 2




                But the problem also lends itself to functional solutions, e.g.:



                pairs = Partition[data, 2, 1];
                If[#[[2, 1]] == E, #[[1]], Nothing] & /@ pairs



                2, 4, 9, 2, 4, 4, 6, 2




                Or in one go:



                BlockMap[If[#[[2, 1]] == E, #[[1]], Nothing] &, data, 2, 1]



                2, 4, 9, 2, 4, 4, 6, 2







                share|improve this answer











                $endgroup$















                  2












                  2








                  2





                  $begingroup$

                  The most idiomatic solution to this problem is, in my opinion, pattern matching (as Sakra has also answered):



                  SequenceCases[data, x_List, E, ___ :> x]



                  2, 4, 9, 2, 4, 4, 6, 2




                  But the problem also lends itself to functional solutions, e.g.:



                  pairs = Partition[data, 2, 1];
                  If[#[[2, 1]] == E, #[[1]], Nothing] & /@ pairs



                  2, 4, 9, 2, 4, 4, 6, 2




                  Or in one go:



                  BlockMap[If[#[[2, 1]] == E, #[[1]], Nothing] &, data, 2, 1]



                  2, 4, 9, 2, 4, 4, 6, 2







                  share|improve this answer











                  $endgroup$



                  The most idiomatic solution to this problem is, in my opinion, pattern matching (as Sakra has also answered):



                  SequenceCases[data, x_List, E, ___ :> x]



                  2, 4, 9, 2, 4, 4, 6, 2




                  But the problem also lends itself to functional solutions, e.g.:



                  pairs = Partition[data, 2, 1];
                  If[#[[2, 1]] == E, #[[1]], Nothing] & /@ pairs



                  2, 4, 9, 2, 4, 4, 6, 2




                  Or in one go:



                  BlockMap[If[#[[2, 1]] == E, #[[1]], Nothing] &, data, 2, 1]



                  2, 4, 9, 2, 4, 4, 6, 2








                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited 5 hours ago

























                  answered 7 hours ago









                  C. E.C. E.

                  51.4k3101207




                  51.4k3101207



























                      draft saved

                      draft discarded
















































                      Thanks for contributing an answer to Mathematica Stack Exchange!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid


                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.

                      Use MathJax to format equations. MathJax reference.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function ()
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f195786%2fhow-to-leave-only-the-following-strings%23new-answer', 'question_page');

                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      JBVO,F 0QX1mjyF4vrvukzkg6t7oTywNFyiJCH0zRpexsSIpMakdDiIAd
                      0BJ,RQhoW,yDYB05UV0UIWxSXnFbASZia5 c

                      Popular posts from this blog

                      What is the result of assigning to std::vector::begin()? The Next CEO of Stack OverflowWhat are the differences between a pointer variable and a reference variable in C++?What does the explicit keyword mean?Concatenating two std::vectorsHow to find out if an item is present in a std::vector?Why is “using namespace std” considered bad practice?What is the “-->” operator in C++?What is the easiest way to initialize a std::vector with hardcoded elements?What is The Rule of Three?What are the basic rules and idioms for operator overloading?Why are std::begin and std::end “not memory safe”?

                      Creating centerline of river in QGIS? The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Finding centrelines from polygons in QGIS?Splitting line into two lines with GRASS GIS?Centroid of the equator and a pointpostgis: problems creating flow direction polyline; not all needed connections are drawnhow to make decent sense from scattered river depth measurementsQGIS Interpolation on Curved Grid (River DEMs)How to create automatic parking baysShortest path creation between two linesclipping layer using query builder in QGISFinding which side of closest polyline point lies on in QGIS?Create centerline from multi-digitized roadway lines Qgis 2.18Getting bathymetric contours confined only within river banks using QGIS?

                      SQL Server 2016 - excessive memory grant warning on poor performing query The Next CEO of Stack OverflowFix for slow SQL_INLINE_TABLE_VALUED_FUNCTIONLarge memory grant requestsPoor performing Query -Tsql execution plan - estimated number of rows =1 Paste the PlanMSSQL - Query had to wait for memory grantRow estimates always too lowBad performance using “NOT IN”Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it?Optimizing table valued function SQL ServerWhen does SQL Server warn about an Excessive Memory Grant?Warning in Execution Plan