03-30-2017 12:30 PM
I found the code I think I need and made a few edits but my new vars are numeric rather than char. I need char vars;
data I have:
doe, john;doe, jane;doe, jack
data i want:
sp1 sp2 sp3
doe, john doe, jane doe, jack
array parsed_vars(*) sp1-sp3;
do while(scan(sp, i, ";") ne "");
parsed_vars(i) =scan(sp, i, ";");
03-30-2017 12:38 PM
You need to specify that your array is character with a "$"
You also will probably want to assign some appropriate length to the variables you created or you might see truncation.
Need further help from the community? Please ask a new question.