Text String Manipulation

Results 1 to 2 of 2

Thread: Text String Manipulation

  1. #1
    Brian Graham Guest

    Default Text String Manipulation

    Is there a way to say when the first comma come up do this, one the second comma do this, and on the third comma do this? So that I can turn "650 town center drive,box #2 park center-back dock,costa mesa, ca 92626" into "<.street>650 town center drive<./street><.location>box #2 park center-back dock<./location><.city>costa mesa<./city><.state>ca<./state> <.zip>92626<./zip>

  2. #2
    Join Date
    Dec 1969

    Default RE: Text String Manipulation

    &#060;%<BR>strAddress="650 town center drive,box #2 park center,costa mesa, ca 92626"<BR>strAddress=Split(strAddress,",")<BR><BR> strStreet=strAddress(0)<BR>strPOBox=strAddress(1)< BR>strCity=strAddress(2)<BR>strSateZip=strAddress( 3)<BR>%&#062;<BR><BR>in your example string, there is no comma between state and zip... if you wish to split state and zip:<BR><BR>&#060;%<BR>strStateZip=Split(strStateZ ip," ")<BR>strState=strStateZip(0)<BR>strZip=strStateZi p(1)<BR>%&#062;<BR><BR>Split splits the specified string at the specified delimiter...<BR><BR>Split(String,Delimiter)<BR><BR >good luck...

Posting Permissions

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