Split the field

[manoranjan_d]

HI all,

I have data like this below 

Pdt	mismact errod
1	M01M02M03MO4

I want to get the data as below while loading

Required O/P

Pdt	mismact errod
1	M01
1	M02
1	M03
1	M04

Any help much thanks to you

[Anil_Babu_Samineni · Accepted solution]

Simplest way 

LOAD Pdt, SubField(Trim(Replace([mismact errod], 'M', ' M')), ' ') as [mismact errod]Inline [
Pdt, mismact errod
1, M01M02M03M04
];