Some TEXT functions, please!!!

ricardorauber

Gendai,

This is not difficult, I know you can easily do it. We want some text handling functions!! Check this out:

Example: self.Text Attribute = "Gendai"

- SUBSTR:

substr ( self.Text Attribute , 1 ) = "G"

substr ( self.Text Attribute , -1 ) = "i"

- SUBSTRL:

substrl ( self.Text Attribute , 1 , 3 ) = "Gen"

substrl ( self.Text Attribute , -2 , 3 ) = "ai"

substrl ( self.Text Attribute , -1 , -3 ) = "dai"

- UPPER:

upper ( self.Text Attribute ) = "GENDAI"

- LOWER:

lower ( self.Text Attribute ) = "gendai"

- LENGTH

length ( self.Text Attribute ) = 6

- REPLACE:

replace ( self.Text Attribute , "n" , "r" ) = "Gerdai"

replace ( self.Text Attribute , "en" , "ar" ) = "Gardai"