PADRIGHT() Pads a string on the right to a particular length ------------------------------------------------------------------------------ Syntax PADRIGHT(<cString>,<nLength>,[<cCharacter| nCharacter>]) --> cString Arguments <cString> Designates the string that is processed. <nLength> Designates the selected new length for <cString>. <cCharacter|nCharacter> Designates the character with which the beginning of the <cString> string is filled. The default value is a space, CHR(32). Returns The processed <cString> is returned. Description PADRIGHT() allows you to pad the end of a character string with characters, in accordance with a length specification. Spaces or any other characters that you choose can be used. Notes . The function works like the Clipper LEFT() function when <nLength> is shorter than the length of <cString>. If <nLength> is negative, PADRIGHT() returns a null string. . When the <cCharacter|nCharacter> parameter is not specified, spaces are automatically used for padding. Examples . The function works like LEFT(): ? PADRIGHT("123456", 4) // "1234" . Pad the right with spaces: ? PADRIGHT("123456", 8) // "123456 " . Pad the right with the "." character: ? PADRIGHT("123456", 8, ".") // "123456.."
See Also: PADLEFT()
Pingback: CT_PADLEFT | Viva Clipper !