Left Function in C#

richard smith

I have several prefixes that I need to append to workbook names. They range from: CR12, LT23, EF232, RF232..

I need a way to take the left 2 characters of the string, and say if
(left(prefix, 2) == "LT")
{
formatAdditions();
}

How can I do this in C#?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Notice also that, if you're converting code which contains a large number of VBA functions to C#, then you can facilitate this by importing the VB.NET runtime library into your project:

/* add a reference to Microsoft.VisualBasic.dll to your project */

using System;
using VBS = Microsoft.VisualBasic.Strings; // create alias for Strings module

class Test
{
static void Main()
{
string name = "LTWorkBook";
if (VBS.Left(name, 2) == "LT")
{
name = "LT23" + VBS.Mid(name, 3);
}

Console.WriteLine(name); // LT23WorkBook
Console.ReadKey();
}
}

Here's a link to the docs for the VB.NET runtime library:

http://msdn.microsoft.com/en-gb/library/c157t28f(VS.100).aspx
richard smith13y ago
I was attempting to add a COM reference, not an assembly.
Jignesh Trivedi13y ago
hi,
you may use either your own function or extension method.
with own function
namespace testProject
{
class Program
{
        public static string Left(string myString, int index)
        {
            if (!string.IsNullOrEmpty(myString) && myString.Length > index)
            {
                return myString.Substring(0, index);
            }
            return string.Empty;
        }
        static void Main(string[] args)
        {
            var leftstr = Left("EF232", 2);
        }
}
}
or use extension method
namespace testProject
{
    public static class MyClass
    {
        public static string Left(this string myString, int index)
        {
            if (!string.IsNullOrEmpty(myString) && myString.Length > index)
            {
                return myString.Substring(0, index);
            }
            return string.Empty;
        }
    }
class Program
{
        static void Main(string[] args)
        {
            var otherLeftStr = "EF232".Left(2);
}
}
}
hope this will help you.