Text Properties

Asc():

      Returns an Integer value representing the character code corresponding to a character.

            Ex: Asc("a")---97

                   Asc("abc")—97

AscW():

      Returns an Integer value representing the character code corresponding to a character.

              Ex:AscW("a")---97

                    AscW("abc")---97

Chr():

     Will returns char of particular key code. Returns the character associated with the specified character code.

              Ex: Chr(97)--- a

chrW():

     Returns the character associated with the specified character code. 

              Ex: Chr(97)--- a

FormatCurrency():

     Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.

              Ex:   FormatCurrency(100,0)--$100

                       FormatCurrency(100,3)--$100.000

Format():

      Returns a string formatted according to instructions contained in a format String expression.

              Ex: Format(100,"$##")--$100

     Note:

     Here ## represents data.

              Ex:  Format(100,"$##$")--$100$

                      Format(100,"$##$")--$100$

                      Format(Today(),"MMM-dd-yyyy")— May-12-2012

                      Format(Today(),"MMM-dd-yyyy tt")—May-12-2012 AM

GetChar():

     Returns a Char value representing the character from the specified index in the supplied string.

              Ex:GetChar("karthi",1)--k

  

FormatNumber()

FormatNumber(123.123,5)------------ 123.12300

FormatNumber(123.123,1)------------123.1

FormatPercent()

FormatPercent(121.123,3)---- 12,112.300%

FormatPercent(121.123,2)---- 121,112.30%

FormatPercent(121.123,0)---- Error

FormatPercent(121,0)--- 12,100%

FormatPercent(121,1)---- 12,100.0%

FormatDateTime()

FormatDateTime()--------(Format will 0-4)

FormatDateTime(Now) ---3/30/2012 7:24:32 PM

FormatDateTime(Now,1)---Friday,March 30,2012

FormatDateTime(Now,2)---3/30/2012

FormatDateTime(Now,3)--- 7:28:56 PM

FormatDateTime(Now,4)--- 19:30

FormatDateTime(Now,5)--- Error

format(Fields!StartDate.Value,"MM/dd/yyyy")

Format(Fields!DateCreated.Value, "d-MMMM-yy") - 14-March-86  

Format(Fields!DateCreated.Value, "M/d/yyyy H:mm") - 3/14/1986 22:10  

Format(Fields!DateCreated.Value, "MMM-dd-yyyy") - Mar-14-1986  

Format(Fields!DateCreated.Value,"dd-MMM-yy")

GetChar()------(Will start from 1)
GetChar(“Karthi”,2)--- a

InStr(“Source string”,”finding the position of the string”)
will returns the first occurance of the string position.if not match will returns 0.

InStr("i am karthi"," ")--- 2

InStr("i am karthi","i")---1

InStr("i am karthi","am")---3

InStr("iamkarthi","k")----4

InStrRev():

        Returns the position of the first occurrence of one string within another, starting from the right side of the string.

        InStrRev()--- Will starts from rigth to left. Oposite to InStr().

        Ex: InStrRev(“karthi”)----ihtrak

Join():

       Returns a string created by joining a number of substrings contained in an array.

       Ex: Join(Array) returns—Joined array  string.

LCase()

       Returns lower case string.

       Ex: LCase("KING")---king

Left():

      Wil returns specified char’s from left to right.

      Ex: Left("karthi",2)--- ka

Len():

       will returns number of char’s or number of bytes need to store those char’s.

       Ex:Len(" i am karthi ")----13

LSet():

       wil returns specified number of char’s

       Ex:LSet("karthi hi",2)---ka

Trim():

       Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).

1.LTrim():=LTrim("  karthi")—karthi

2.RTrim() :=RTrim(“karthi  ”)—karthi

3.Trim():=Trim(“  karthi  ”)--karthi

Mid():

       Ex:Mid(“karthi”,2)-arthi

             Mid(“karthi”,2,1)-- a

Replace():

      Returns a string in which a specified substring has been replaced with another substring a specified number of times.

      Ex: Replace("India is my country","my","our")

Replace(our string,find,replacement)

Right():

      Returns a string containing a specified number of characters from the right side of a string.

      Ex:Right(“karthi”,2)---hi

Split():

      Returns a zero-based, one-dimensional array containing a specified number of substrings.

StrComp():

       Returns -1, 0, or 1, based on the result of a string comparison.

       Ex:StrComp(“k”,”k”)—0          

             StrComp(“a”,”b”)--1

StrDup():
       Returns a string or object consisting of the specified character repeated the specified number of times.

       Ex:StrDup(5,"M")---MMMMM

strReverse():
        Returns a string in which the character order of a specified string is reversed.

        Ex:strReverse(“1988”)---8891

UCase():

        char into uppercase characters

        Ex:UCase("king")---KING