06-05-2017 08:25 PM
I have a field which appears in this format: XXXX YYYY ZZZZ
Where it is separated by space. I would like to make a new line per space delimited string. So for the above example there would be 3 lines create.
Any help would be appreciate?
06-05-2017 08:36 PM
This is a basic structure which I am looking for:
|1||XXXX YYYY ZZZZ|
06-05-2017 08:38 PM
COUNTW to count the number of words
SCAN to extract the number of components.
n_words = countw(string); do i=1 to n_words; word = scan(string, i); OUTPUT; end;
A fully worked example is here:
Need further help from the community? Please ask a new question.