Post reply

data entry problem

  • November 27, 2006 at 3:41 pm

    #674191

    Can you give us samples of the type of data you have?

    Basically, you could use PATINDEX or CHARINDEX to find each comma and separate it that way. For example:

    1. put the value into a variable

    2. get the first part by grabbing the string upto the comma.

    3. put the rest back into the variable (so that now the variable is missing the part taken out)

    4. continue this until you have parsed the whole value.

    -SQLBill

  • November 28, 2006 at 2:28 am

    #674263

    THANKS SQLBILL

    THE DATA IS SIMPLE ADDRESS TEXT EG

    14 THE RIDE,WOKING,SURREY,GU34 5SF

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply