Left of String (Cross Ref > Commands)

Left of String

Access VBA:   Left

Syntax Example: Dim LeftString As String LeftString = Left("Prestwood", 3) MsgBox LeftString More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages

ASP Classic:   Left

Syntax Example: Dim LeftString LeftString = Left("Prestwood", 3) Response.Write LeftString More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages

 Ref: http://msdn.microsoft.com/en-us/library/sk3xcs8k(VS.85).aspx

C#:   Substring

Above returns "abcd" on a string literal. You can, of course, use VarName.Substring(0, 4).

Syntax Example: Console.WriteLine("abcdefgh".Substring(0, 4)); More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages

Corel Paradox:   subStr

substr ( const startIndex LongInt [ , const numberOfChars LongInt ] ) String

Alternative syntax:

LeftString = subStr(NameVar, 1, 3)

Syntax Example: var �LeftString String; NameVar String; endVar NameVar = "Prestwood" LeftString = NameVar.subStr(1, 3) msgInfo("", LeftString) More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages

Delphi:   LeftStr

Syntax Example: Uses StrUtils; ShowMessage(LeftStr('Prestwood', 3)); More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages

Delphi Prism:   Substring

Syntax Example: MessageBox.Show("Prestwood".Substring(0, 3)); More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages

JavaScript:   substr

Above returns "Mike P".

SubStr(StartIndex, NumberOfCharacters)

Notice JavaScript is 0 based (the first character is character 0).�0 is start character, 6 is number�of characters).�

You can also use substring where both numbers are indexes:

SubString(StartIndex, EndIndex)

The following returns "re".

var sName;
sName = "Mike Prestwood";
sName = sName.substring(6, 8);
document.write(sName); 

Syntax Example: var sName; sName = "Mike Prestwood"; sName = sName.substr(0, 6); document.write("Hello " + sName); More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages

VB Classic: 

Syntax Example: Dim LeftString As String LeftString = Left("Prestwood", 3) MsgBox LeftString More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages

VB.Net:  "Left of Substring" Left or Substring

The above usage of Left and Substring are equivalent.

Left is a traditional VB approach popular with developers moving from VB Classic to VB.Net. Substring is considered the .Net way of doing string manipulation.

Syntax Example: Dim FullName FullName = "Prestwood" Console.WriteLine("Hello " + Left(FullName, 4)) Console.WriteLine("Hello " + FullName.Substring(0, 4)) More Info  To/From Code Guide: Left of String (Cross Ref > Commands) vs. Other Languages