C#

public static string ToXml(Soap.EventCode.EvCodes value)
      {
          string returnValue = null; // provide your default value
          switch (value)
          {
              case Soap.EventCode.EvCodes.DispatchedForDelivery:
              case Soap.EventCode.EvCodes.Delivered:
                  returnValue ="OD"; break;
              case Soap.EventCode.EvCodes.DepartedFromTerminal:
                  returnValue ="L1"; break;
          }
          return returnValue;
      }

public class EventCode
   {
       public static string ToXml(Soap.EventCode.EvCodes value)
       {
           switch (value)
           {
               case Soap.EventCode.EvCodes.DispatchedForDelivery:
               case Soap.EventCode.EvCodes.Delivered:
                   return "OD";
               case Soap.EventCode.EvCodes.DepartedFromTerminal:
                   return "L1";
               // Catch-all for all other cases. 
               // Throwing an exception here is just an example implementation, not mandatory.
               default: throw new ArgumentOutOfRangeException(nameof(value), "Unsupported Evcode: " + value);

           }
       }
   }

enhzflep wrote:

Mate, there's no need to SHOUT. Your question is perfectly clear without it. It merely gives the impression of someone too inarticulate to ask for the information they require who then becomes frustrated and raises their voice at the person that perfectly answered their ill-formed question. Not generally seen as a desirable personal attribute...

enhzflep wrote:

Typing "c# extract vba from access" into google

enhzflep wrote:

Since I've got 20 seconds to kill that I can donate to someone clearly to busy to expend it themselves, here's the first couple.

Kevin Marois wrote:

I DID look at Google. I ALWAYS go to Google

enhzflep wrote:

Mate, there's no need to SHOUT

Bootzilla33 wrote:

Is this how that would be done?

class Program
    {
        static void Main(string[] args)
        {
            string CurrentLine;
            string FilePath = "C:\\12837.SDF.txt";
            using (StreamReader sr = new StreamReader(FilePath))
            {
                while(!sr.EndOfStream)
                {
                    CurrentLine = sr.ReadLine();
                     GetSplit(CurrentLine);
                   // Console.WriteLine(array.Length.ToString());

                }
            }
        }

        private static void GetSplit(string CurrentLine)
        {
            string[] array = CurrentLine.Split(';');
            string first = array[0];
            string second = array[1];
            string third = array[2];
            string four = array[3];
          //  string five = array[4];
           // string six = array[5];
          //  string seven = array[6];
           // string eight = array[7];
            Console.WriteLine(first + " " + second + " " + third + " " + four);
        }
    }
}

WoodChuckChuckles wrote:

C# keeps bringing the RC-M down a line

1: 20170630
2:  37
3:  Denver
4:  Other Non-Interest Expense from RI item 7.d. : Travel Expense =$88,799.Excess public-facing website address listings fromRC-M line 8.b.: sparkalpha.com, www.getsparkalpha.com, www.getsparkalpha.com, www.sparkcapitalone.com.
5: 20170728
6: Explanations
7: Call
8: m1b