How do you seperate a string?

Results 1 to 3 of 3

Thread: How do you seperate a string?

  1. #1
    Curtis Guest

    Default How do you seperate a string?

    Lets say, in a memo field in Access, I have the value: 1, 2, 3<BR><BR>how can i pull the values seperated by the comma to get:<BR>strA = 1<BR>strB = 2<BR>strC = 3

  2. #2
    Join Date
    Dec 1969

    Default Use split

    Split breaks up a string into an array based on a delimiter (in this case, the comma).<BR><BR>Dim aResults<BR>aResults = split(str, ",")<BR><BR>&#039;Now, aResults(0) = 1<BR>&#039; aResults(1) = 2<BR>&#039; aResults(2) = 3<BR><BR>Check out this FAQ:<BR><BR>How can I convert a string into an array?<BR><BR><BR>And this article:<BR><BR>Parsing with join and split<BR><BR><BR>Happy Programming!

  3. #3
    Curtis Guest

    Default RE: Use split

    Thanks Scott!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts