How can I extract address, city, state and Postal code from a text separated by * using REGEXP_SUBST

Discussion in 'MySQL' started by asifakhtar, Nov 17, 2022.

0
  1. #1
    REGEXP_SUBSTR('4550 Montgomery Avenue*Toronto*Ontario*M4A 2S3*', '(.*? ){2}(.*?),')

    I get a list of dynamic text which contains address, city, state and Postal code separated by *. Need to exact address, city, state and Postal code using REGEXP_SUBSTR.
     
    asifakhtar, Nov 17, 2022 IP