Comma Separated List

[deleted_user]

Is there any way to get an entry out of a Comma Separated list?

I have a Table which stores data as follows:

PRODUCT_ID| DIMENSIONS
--------------------| --------------------------
10000000000 | L 200 X W 200 X D 200 mm
10000000001 | L 300 X W 150 X D 250 mm
etc etc..

I need to calculate the volume (L x W x D), so i need to grab each entry out of the "DIMENSIONS" field (Entry 2, Entry 5, Entry 😎 Based on the Delimiter of " ".

Is there a function available to extract this?

Any help would be appreciated.

[deleted_user]

Looks like "Scan(__value_list__, __entry__, __delimiter__)" is what i require.

[deleted_user]

here's some usage on the SCAN function ....
http://www2.sas.com/proceedings/sugi30/233-30.pdf