IBM Mainframe Forum

Hello,
i have those records in my dataset :



I'd like to get the word separated with comma

For example, in the first line, i'd like to get :

AAA
BBB
CCC
and in the secand line :
EEEEEEEEEE
FF
GGGGGGGGGG

I can't use WORD function because, it is not space separated value...

Thank's.

Change the commas to blanks: line=translate(line,' ',',')

posted gazillions of times in many forums

Thank you enrico, t didn't think about the command PARSE wich is very usefull

PARSE is a very useful command. In this particular case, assuming that you have only 3 words, you can combine the TRANSLATE and PARSE thus: