I am trying to loop through a comma delmited field (peru, ama, ecu,) and perform a function for each of the words between the commas. The loop continues while the field LEN > 0. Before looping after the function, I want to remove everything left of the first comma, including the comma so that when function has been performed for each word, the field will be empty and the loop will end.
I can't seem to find a the correct TRIM function to remove everything left of the comma including the comma.
Can anyone help with this?
Thanks!
~ lahddah
~ lahddah
I can't seem to find a the correct TRIM function to remove everything left of the comma including the comma.
Can anyone help with this?
Thanks!
~ lahddah
~ lahddah