Regular expression example

--remarks  :=== wU K‡i U¨ve‡jU  ‡L‡Z n‡e  (1 w`b)#1  Tab  by mouth  for 1 Days
  select    regexp_substr(remarks,'[^#]+',1,2)
    from pm_presmedicine
   will show
    1  Tab  by mouth  for 1 Days
   and
    select    regexp_substr(remarks,'[^#]+',1,1)
    from pm_presmedicine
    will show wU K‡i U¨ve‡jU  ‡L‡Z n‡e  (1 w`b)#