pendaz's Profile User Rating: -----

pendaz's Photo
Reputation: 2 Apprentice
Group:
Members
Active Posts:
49 (0.18 per day)
Joined:
14-August 12
Profile Views:
409
Last Active:
User is offline May 17 2013 04:11 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   pendaz has not set their status

  1. Awards
  2. About Me
  3. Blog

Posts I've Made

  1. In Topic: Parse Specific text from textfile (not sure on the format)

    Posted 17 May 2013

    Thanks for the replies, apologies for my late reply, i've been busy with other things.


    Heres what i have so far: 

      ' Loop over each line in file, While list is Not Nothing.
        Do Until (line Is Nothing)

            If line.Contains("ID") Then

               
                line = line.Substring(0, line.Length - 1)
                line = line.Remove(0, 18)
                
                ListBox.Items.Add(line)


            End If



    with this code i managed to pull out the id numbers from the text file and add them on each line of a listbox, but this is where i'm now stuck, i can't seem to work out how to pull the "ID" and the "ID#" and keep them related to each other


    CharlieMay's reply seems like exactly what i need, i just can't work out how to do it.

    Quote

    you might even benefit from replacing the vbTabs, { } and " with an empty string. And then use String.Split on the LineFeed character that remains


    could you elaborate please?


    Thanks a lot!


    -Pendaz

  2. In Topic: Parse Specific text from textfile (not sure on the format)

    Posted 13 May 2013

    View Postmodi123_1, on 12 May 2013 - 09:40 AM, said:

    Quote

    I need to read this file and pull out specifically the "account1|ID|xxxxx" and store it in such a way that i can for example call "account1" and be able to display the related ID number


    If you don't care about the preceding hierarchy just load the file as a string via streamreader, and use the string's namespace functions to search for the 'account1', and then just navigate a few characters over (remember strings are arrays!), and you got it.



    Thanks for the reply


    i need to be able link "account1" with the following "ID" "xxxxx" so then i can call "account1" and display its ID number


    can i achieve this with streamreader?

  3. In Topic: Change row colour if a date has passed

    Posted 3 Apr 2013

    View PostCharlieMay, on 03 April 2013 - 04:36 AM, said:

    Try

    If row.Cells(1).Value = enddate.date Then


    Depending on what is actually stored in the cell, you might have to do a datetime conversion on the cell value but I don't think so.

    EDIT:
    added .date to the enddate so that it is only comparing the date with the cell. Otherwise, it would include a time in the comparison.




    thanks for the reply mate


    this is throwing the error:

    Quote

    Operator '=' is not defined for type 'Double' and type 'Date'.

  4. In Topic: Strange MySql Exception

    Posted 22 Jan 2013

    ok i set all my tables to lower case and my code all called in lower case, still getting the same error


    i'm not exactly sure what version of the connector im using so im going to update to the latest and report back if it makes any difference

  5. In Topic: Strange MySql Exception

    Posted 22 Jan 2013

    View PostCharlieMay, on 22 January 2013 - 08:38 AM, said:

    Check out my last post. It appears others are having similar issues with a certain release. I know it talks about stored procedures but on down it does state that it doesn't have to be ran from a stored procedure to reproduce the bug. It's more a case-sensitivity issue with names.


    ah yes i missed that post, i'll look into it when im home

    thanks gain mate

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

pendaz hasn't added any friends yet.

Comments

pendaz has no profile comments yet. Why not say hello?