Charactor Removal

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • SirBob
    New Member
    • Sep 2006
    • 1
    #1

    Charactor Removal

    Hello all, I am very new to VB programming so please be gentle with me.

    I am reading a line from a CSV file and putting it into a string, when I do this all the contents of the cells are in quotes (eg "1","2","3" ).
    Can I manipulate the string to remove the quotes (the quotes will not always be in the same palce so I cannot use Mid?(eg"1","243 ","3")

    Thanks
    Tags: None
    • CaptainD
      New Member
      • Mar 2006
      • 135
      #2
      Originally posted by SirBob
      Hello all, I am very new to VB programming so please be gentle with me.

      I am reading a line from a CSV file and putting it into a string, when I do this all the contents of the cells are in quotes (eg "1","2","3" ).
      Can I manipulate the string to remove the quotes (the quotes will not always be in the same palce so I cannot use Mid?(eg"1","243 ","3")

      Thanks
      Look into the replace() function. I think it would be Replace("TextSt ring", """, " ")

      That would replace the quotes with a blank space, or no space you don't put it there.

        Comment

        Previous template Next
        Working...