[sqr-users] Ltrim/Rtrim usage

[Kaz.Narayanan@averydennison.com]

Hi,

I am trying to trim a value 'TAX' in an SQR.
My codes are as follows:


      let $document1 = ltrim($document , 'TAX')
      let $document1 = Rtrim($document1 , 'TAX')
      let $document1 = ltrim($document1 , ' ')
      let $document1 = rtrim($document1 , ' ')


For Example if I have a value of '8710212004ATAX' in $document I want
$document1 to be '8710212004A' without the 'TAX'
however, the $document1 is also trimming the 'A' before the 'TAX'. I want
the
$document1 to be '8710212004A'

Am I doing anything wrong? Any Suggestions?

Thanks
Regards
KM Narayanan



-----------------------------------------
The information transmitted is intended only for the person or entity  to
which it is addressed and may contain confidential and/or  privileged
material. Any review, retransmission, dissemination or  other use of, or
taking of any action in reliance upon, this  information by persons or
entities other than the intended recipient  is prohibited. If you received
this in error, please contact the  sender and delete the material from any
computer.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users