4 Replies Latest reply: Jun 17, 2014 8:54 AM by Sifat Rahman RSS

    Complex substring selections

    Sifat Rahman

      Hi, I am trying to select particular substrings from a long string, but can't seem to formulate a way of doing this. This is the string, and colour-coded substrings I'd like to select:


      "Received Order Insert message from gbarnfieldfsn. Instrument: 1M KRW Fix Midpoint, Mkt: 7. Order: Bid 10 @ 1.37."


      I want to make new fields and input these substrings in them like below:


      Instrument, B/O, Amount, Price

      1M KRW, Bid, 10, 1.37



      I can think of different operators like trim, index, right, left, len, etc. but finding it very difficult to select these without wildmatches. Any help greatly appreciated!