7 Replies Latest reply: Jan 19, 2012 5:40 AM by Anne Duffy RSS

    Search String

      Hello All,

      How are you?

       

      I have a simple question this time.

       

      I want to search the following strings from the right to find the price. The price value is concatenated with the item id in this manner.

       

      Item_Price:

       

      40637_123ABC_400

      40644_1457_2300

      40651_12_23005

       

      So all values after the second "_" (underscore) is the price. And all the value before the first underscore "_" is the Julian date

      So please suggest how to use the "Right" or Trim function.

       

       

      Thanks in advance,

      Bikash