Split the data

[Nagaraju_KCS]

Hi All.

I have one field

Name

A:1 B:2 C:3 D:4

i want to display

A 1

B 2

C 3

D 4

Thanks in Advancee................

[MayilVahanan · Accepted solution]

Hi

Try like this

Load Replace(SubField(Name,' '),':',' ') as Name;

Load * Inline

[

Name

A:1 B:2 C:3 D:4

];