Results 1 to 2 of 2

Thread: Formula in CR

  1. #1
    Join Date
    Jan 2006
    Posts
    1

    Unanswered: Formula in CR

    Hi, is anybody know how to transfer a string text to a number in the Crystal Report? Example , i have a text with S$20/pc, i want it to appear in number with 20 only, is it possible done by using CR formula? Thanks !

  2. #2
    Join Date
    Oct 2005
    Posts
    178
    Quote Originally Posted by leeling
    Hi, is anybody know how to transfer a string text to a number in the Crystal Report? Example , i have a text with S$20/pc, i want it to appear in number with 20 only, is it possible done by using CR formula? Thanks !
    You need to use the value and string function Val(MID("S$20/pc",3,2)) to extract the numeric portion
    Last edited by fredservillon; 01-07-06 at 00:24.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •