Seprating numbers out of string help!!!

[amit_saini]

Hi Folks ,

I'm having below scenario:

Were these KT-PartNo belongs to Plant codes highlighted after # in location filed

What I want to have is output like below , so that I can assign Location codes for KT-PartNo:

Please suggest how to do this???

Thanks,

AS

[tamilarasu]

Try,

Table:

LOAD * Where len(Trim(New_Location))>0;

LOAD *,  Keepchar(Subfield(Location,'#'),0123456789) as New_Location

Inline [

KT-PartNo, Location, PartFamily

72681 ,ABC#099 KT Holzlar HQ+PTF#008 KT Mallersdorf#098 KT Small-series production, unassigned

74257 ,ABC#008 KT Mallersdorf#012 KT Bohemia Fuel#099 KT Holzlar HQ+PTF ,unassigned

76620 ,ABC#008 KT Mallersdorf, unassigned

79051 ,ABC#010 KT Tessenderlo#007 KT Leer ,unassigned

];