C# Import CSV File
Remember to add reference to Microsoft.VisualBasic
C# Format DateTime
Format Result .ToString(“MMMM dd, yyyy”) June 10, 2011 .ToString(“MM/dd/yyyy”) 05/09/2019 .ToString(“hh:mmtt”) 12:00AM .ToString(“hh:mm:ss tt”) 6:09:01 PM Format Result DateTime.Now.ToString(“MM/dd/yyyy”) 05/29/2015 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 05:50 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 05:50 AM DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015... » read more
C# Format Decimal
Mask Format .ToString(“0.00”) X.XX .ToString(“C2”) $X,XXX.XX Source: https://docs.microsoft.com/en-us/dotnet/api/system.decimal.tostring?view=netframework-4.8
TransactionScope
Makes a code block transactional. Source: https://docs.microsoft.com/en-us/dotnet/api/system.transactions.transactionscope?view=netframework-4.8
Path
System.IO.Path Path.* Path.Combine Sources: https://docs.microsoft.com/en-us/dotnet/api/system.io.path.combine?view=netframework-4.8
continue (C# Reference)
The continue statement passes control to the next iteration of the enclosing while, do, for, or foreachstatement in which it appears. Sources: https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/continue
Regex
Expression Example String ^TestFile-.+.txt$ TestFile-03Jul2019150038.txt ^FILE-(OUTPUT|INPUT|ALL)-.+.txt$ FILE-OUTPUT-03Jul2019150038.txt Regex Tools https://regex101.com/
Upload File to FTP/FTPS Server
This is implemented using FtpWebRequest which can only handle FTP/FTPS. This will NOT WORK for SFTP, which is a completely different protocol.