I have a field called cpic_info that contains data such as (Name: Sammy Cpic Address: 123 Main St Regina SK Date of Birth: 1978-12-20 Gender: Male Height: 5 feet 5 inches Weight: 123 pounds Place of Birth: Regina)
I need to be able to extract the following in this format:
Sammy Cpic
123 Main St
Regina, SK
1978-12-20
Male
5 feet 5 inches
123 pounds
Regina
Each field is seperated by a ":", but I can not seem to split the string apart. Any suggestions???
Thanks.
cjk
I need to be able to extract the following in this format:
Sammy Cpic
123 Main St
Regina, SK
1978-12-20
Male
5 feet 5 inches
123 pounds
Regina
Each field is seperated by a ":", but I can not seem to split the string apart. Any suggestions???
Thanks.
cjk