I have a file that I'm uploading from a web page that I need to do some manipulation before I do a bulk upload. The file is a .csv file and I need to do some checking (if I can from from my web page)
I'll need to check a few things:
Fields (whether there are enough or too many and drop off the ones that are not needed.)
DateTime format (currently datetime is YYYYMMDD HH:MM and all incoming feels need to meet that expectation)
Phone Number (whether they have a area code prefacing the number or not)
Here is what I have so far (and this works as it's currently constructed, just more filters and manipulation needs to be added/modified so that all incoming files meet format requirments.)
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.Even ... Go to the complete details ...