Text object in verticle value

[Anonymous]

Hi All,

Kindly please share the value should in vertically.

Ex:

Year

2014,2015,2016

O/P

2014

2015

2015

Thanks

[Anil_Babu_Samineni]

Use

Concat(Year,Chr(10))

[Anonymous]

Great help,Thanks you

[Anil_Babu_Samineni]

Please close this thread by flag Correct answer. And i recommend you to search on community rather creating the Thread

[ahaahaaha]

Hi,

If it's in a script, then as an variant

Table1:

LOAD*Inline

[Year

'2014, 2015, 2016'

];

Left Join

LOAD*,

SubField(Year, ',', IterNo()) as NewYear

Resident Table1

While IterNo() <= SubStringCount(Year,',')+1;

Drop Field Year;