how to detect a ( , )

[Jmac2501]

I have to make folders out of addresses and want to seperate the address like this:
From this - 12345 1st St, Sacramento, CA 95817
to
this - 12345 1st St
Deleting everything after the ( , ).
I have a scrip but its not working.

Code: Select all

  let >y=1
  let>address=12345 1st St, Sacramento, CA 95817 
  label>ADD
    let y=y+1
   MidStr>%address%,%y%,1,add2
     if>add2=(need to know how to make is see the , here),ADD1
       else
       goto>ADD
       endif
label>ADD1

[Marcus Tettmar]

Hi,

I would do it like this:

Let>data=12345 1st St, Sacramento, CA 95817
Let>comma=,
Separate>data,comma,parts

Now parts_1 contains 12345 1st St
parts_2 contains Sacramento
parts_3 contains CA95817

[Jmac2501]

awsome thanks