writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 2:
Line 2: − + − + Line 14:
Line 14: − + − + − + − + − +
no edit summary
where,
where,
*<math>Text</math> is a text string containing characters to extract,
*'''Text''' is a text string containing characters to extract,
*<math>Number_chars</math> represents the number of characters to be extracted.
*'''Number_chars''' represents the number of characters to be extracted.
LEFT() displays the specified number of characters from a text string.
LEFT() displays the specified number of characters from a text string.
*LEFT counts 1 byte per characters. LEFT works with the languages that use 'Single Byte Character Set' (SBCS).
*LEFT counts 1 byte per characters. LEFT works with the languages that use 'Single Byte Character Set' (SBCS).
*<math>Text</math> can be any string containing characters, numbers, symbols, blankspaces etc.
*'''Text''' can be any string containing characters, numbers, symbols, blankspaces etc.
*If argument <math>Text</math> is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
*If argument '''Text''' is directly entered in the command, it should be enclosed in double quotes (e.g. "Name").
*Argument <math>Number_chars</math> indicates the number of characters to be displayed from a text string. <math>Number_chars</math> should be >0.
*Argument '''Number_chars''' indicates the number of characters to be displayed from a text string. '''Number_chars''' should be >0.
*If <math>Number_chars</math> >'length of text', Calci displays the entire text.
*If '''Number_chars''' >'length of text', Calci displays the entire text.
*If <math>Number_chars</math> is omitted, Calci assumes it to be 1.
*If '''Number_chars''' is omitted, Calci assumes it to be 1.
== Examples ==
== Examples ==