Search:

Type: Posts; User: SeanVb

Search: Search took 0.07 seconds.

  1. Re: Keeping Speech Marks In a Field When Using ADODB To Read/Write a CSV

    Hi jdc,

    Thanks for your reply. However I prefer to manipulate the data as I received it. At the expense of performance (+-2 seconds), I managed a known workaround. Using FSO I created a temp file,...
  2. Keeping Speech Marks In a Field When Using ADODB To Read/Write a CSV

    Hi,

    Another project of mine required looking up account numbers from an Excel spreadsheet but the machine does not have Excel on it, so ADODB was the way to go. For the below code I found using a...
  3. Replies
    0
    Views
    2,784

    VS 2010 SQL Statement Failing On Windows 10

    Hi vbforums,

    I was not sure which thread to ask this question in. However I am using Visual Studio 2010, so perhaps a fitting spot. I have a SQL statement that was given to me on another site and...
  4. VS 2010 Split Function Freezing UI - Some Backgroundworker Help Please

    Hi,

    I'm currently running multiple For Each loops which are time consuming loops. They started to cause issues so I added them to a backgroundworker, not only for the threading advantages but also...
  5. VS 2010 Re: Read a text file line by line, use a number from each line to loop an array n tim

    You would think that I would have thought of that since I help run a website too. Although we recently moved to Xenforo due to VBulletin been so full of holes.

    Thanks again and thread marked as...
  6. VS 2010 Re: Read a text file line by line, use a number from each line to loop an array n tim

    Apologies for my late reply. And thanks for your continued help. I actually had many stringbuilders in one SUB due to having to manipulate said data in many ways. One could not multi-manipulate the...
  7. VS 2010 Re: Read a text file line by line, use a number from each line to loop an array n tim

    Thanks dday9 for sharing your idea. Taking into account that my live data is as follows.

    { item = 0000, Count = 199 }
    I had to change the get count because yours returned " 199}".

    count =...
  8. VS 2010 Re: Read a text file line by line, use a number from each line to loop an array n tim

    Hi,

    My temp.txt is something like this and will contain roughly 400 000 lines.



    #01t 001
    ss02-Oct-2015
    ss06-Oct-2015
    #02vv
  9. VS 2010 Re: Read a text file line by line, use a number from each line to loop an array n tim

    Bump. Anyone have any thoughts I would really appreciate it.
  10. VS 2010 [RESOLVED] Read a text file line by line, use a number from each line to loop an array n times

    I have a sub that reads a text file into a array then manipulates, sorts and extracts the data in it. The file is then saved to a new file called temp.txt. Another array reads the temp.txt file,...
  11. VS 2010 Re: Creating a dataset/recordset from variable record length text data

    Thanks GBeats for the advice. I went ahead and looked at regex and damn it can get a little complicated. I managed to find this test site from one of the threads here. I managed after fiddling around...
  12. VS 2010 Creating a dataset/recordset from variable record length text data

    Hello vbforums,

    I have looked all over and cannot get my head around the following. I hope someone here can help.

    I'm making a program in MS Visual Basic 2010 Express that will read a text data...
Results 1 to 12 of 12



Click Here to Expand Forum to Full Width