THE FOLLOWING ARE THE LIST OF SINGLE ROW CHARACTER FUNCTIONS :
1. UPPER: THIS FUNCTION CONVERTS AN ATTRIBUTE TEXT INTO UPPER CASE.
2. LOWER: THIS FUNCTION CONVERTS AN ATTRIBUTE TEXT INTO LOWER CASE.
3. INITCAP: THIS FUNCTION CONVERTS ONLY THE FIRST ALPHABET IN UPPER CASE AND THE REST IN LOWER CASE
4. CONCAT: THIS FUNCTION IS USED TO CONCATENATE TWO STRINGS.
THIS FUNCTION TAKES ONLY TWO PARAMETERS.
5. LENGTH: THIS FUNCTION DISPLAYS THE LENGTH OF A STRING. THIS FUNCTION TAKES ONLY ONE PARAMETER.
6. SUBSTR: THIS FUNCTION DISPLAYS ONLY A PART OF THE STRING.
9. REPLACE: THIS FUNCTION REPLACES A SET OF CHARACTERS ONLY.
IN THE EXAMPLE BELOW, WE HAVE REPLACED 'in' WITH 'zz'.
10. TRANSLATE: THIS FUNCTION REPLACES CHARACTERS INDIVIDUALLY.
IN THE EXAMPLE BELOW ANY OCCURANCE OF 'i' WILL BE REPLACED BY 'z' AND ANY OCCURANCE OF 'n' WILL ALSO BE REPLACED BY 'z'.
THE OCCURANCE OF 'in' TOGETHER IS NOT MANDATORY.
11. TRIM: TRIM REMOVES THE STARTING ALPHABET OF A STRING.
1. UPPER: THIS FUNCTION CONVERTS AN ATTRIBUTE TEXT INTO UPPER CASE.
2. LOWER: THIS FUNCTION CONVERTS AN ATTRIBUTE TEXT INTO LOWER CASE.
3. INITCAP: THIS FUNCTION CONVERTS ONLY THE FIRST ALPHABET IN UPPER CASE AND THE REST IN LOWER CASE
4. CONCAT: THIS FUNCTION IS USED TO CONCATENATE TWO STRINGS.
THIS FUNCTION TAKES ONLY TWO PARAMETERS.
5. LENGTH: THIS FUNCTION DISPLAYS THE LENGTH OF A STRING. THIS FUNCTION TAKES ONLY ONE PARAMETER.
6. SUBSTR: THIS FUNCTION DISPLAYS ONLY A PART OF THE STRING.
THIS FUNCTION TAKES 3 PARAMETERS.
1. THE NAME OF THE ATTRIBUTE
2. THE START POINT OF THE STRING
3. THE NUMBER OF LETTER TO BE DISPLAYED IN THE SUBSTRING (OPTIONAL)
7. INSTR: THIS FUNCTION TAKES IN 4 PARAMETERS.
1. THE NAME OF THE ATTRIBUTE
2. THE ALPHABET TO BE SEARCHED (in eg. the alphabet is 'n')
3. THE START POINT OF THE STRING (OPTIONAL)
4. THE OCCURANCE OF THE ALPHABET (OPTIONAL)
In this eg. 'Atkinson' has the occurance of 'n' twice. We are searching for the 2nd occrance of 'n' starting from the 2nd position. But, the counting will always take place from the first postition.
8. LPAD/RPAD: THEY ARE USED IN MICR (MAGNETIC INK RECOGNITION SYSTEM.
THESE FUNCTIONS ARE USED TO DISPLAY ANY SYMBOL TO THE LEFT/RIGHT OF THE STRING. HAVE A LOOK AT THE EXAMPLE TO HAVE A BETTER UNDERSTANDING.
1. THE NAME OF THE ATTRIBUTE
2. THE ALPHABET TO BE SEARCHED (in eg. the alphabet is 'n')
3. THE START POINT OF THE STRING (OPTIONAL)
4. THE OCCURANCE OF THE ALPHABET (OPTIONAL)
In this eg. 'Atkinson' has the occurance of 'n' twice. We are searching for the 2nd occrance of 'n' starting from the 2nd position. But, the counting will always take place from the first postition.
8. LPAD/RPAD: THEY ARE USED IN MICR (MAGNETIC INK RECOGNITION SYSTEM.
THESE FUNCTIONS ARE USED TO DISPLAY ANY SYMBOL TO THE LEFT/RIGHT OF THE STRING. HAVE A LOOK AT THE EXAMPLE TO HAVE A BETTER UNDERSTANDING.
9. REPLACE: THIS FUNCTION REPLACES A SET OF CHARACTERS ONLY.
IN THE EXAMPLE BELOW, WE HAVE REPLACED 'in' WITH 'zz'.
10. TRANSLATE: THIS FUNCTION REPLACES CHARACTERS INDIVIDUALLY.
IN THE EXAMPLE BELOW ANY OCCURANCE OF 'i' WILL BE REPLACED BY 'z' AND ANY OCCURANCE OF 'n' WILL ALSO BE REPLACED BY 'z'.
THE OCCURANCE OF 'in' TOGETHER IS NOT MANDATORY.
11. TRIM: TRIM REMOVES THE STARTING ALPHABET OF A STRING.
No comments:
Post a Comment