Recent content by vbnetnewby1967

I found this someplace else and seems to work... Dim FullName As String FullName = "Public, John Q" UseRegularExpression(FullName) End Sub Private Sub UseRegularExpression(ByVal strName As String) Dim regExp As New...

Thanks for your response.

Hello... I have a problem that I am hoping someone can help me with. I have a field which contains the full name of an individual (i.e. "Public, John Q"). Is there a way to split this single field into three separate items that I can use to populate other variables. I've used Split to get the...

Hello... I was wondering if anyone could show me how to read a fixed-width file and how to go about writing a fixed-width file. I know in VB6 you could use something like: Dim aa as String * 10 to created a fixed-width string but this is no longer supported. I have done some research on the...

Can someone please show me how to create a text file where each element that is written to the file is a differnt width. Example: ABxxxxLAST_NAMExxxxxxxxxxxFIRST_NAMExxxxx Were x = spaces. Any assistance would be appreciated.

Thank you for answering my post. I really appreciate it. Will the fact that there are 90+ columns cause a problem using this method??? Thanks again for your help

Hello... I hope someone can help me. I have a Excel spreadsheet which contains approximately 1700 records. I need to process this file in a certain way and then write data to a file using a fixed width. Not all rows will have the same fixed width format. Example: ADIND09012005SPARKS1...