AnsweredAssumed Answered

Text functions

Question asked by binkel on Jul 13, 2018
Latest reply on Jul 17, 2018 by DanielShanahan

Objective Keep everything right of the Colon, excluding the colon

My Calculation: Right ( Alt Description ; Position ( Alt Description ; ":" ; 1 ; 1 ) +1 )

Data as imported into field Alt Description (Three Samples):

     A) From Share 30 XFR Pmt: From Share 30                          Result: XFR Pmt: From Share 30

     B) HB XFR Pmt: From Share 15 PartialPmt 0.00 to 18.50     Result: .00 to 18.50

     C) HB XFR Dep: From Share 01                                             Result: rom Share 01

 

Sample A is acceptable but looking for From Share 30

Is it because of the colon? Is there a work-a-round?

Also have problems with asterisks

Outcomes