Dimension values in Text object

[santhosh_k_n]

Hi All,

I have requirement to place the below data in a text object. Please suggest.

Data : 

Region	country
Africa	Iraq
	India
	Japan
	China
Africa	Libya
	Niger
	Zimbabwe

Required in text object as ,

Africa. Africa contains countries such as Libya, Niger and Zimbabwe. ...

Asia. Asia contains countries such as Iraq, India, Japan and China. ... Asia. Asia contains countries such as Iraq, Japan and China. ...

Note: for Asia 2nd line is with one excluded values and the values need to be dynamic.

Regards,

SK

[jochem_zw · Accepted solution]

as a starting point, some string parsing, see attachment