new fields from existing field values

[hopkinsc]

Hi all,

i have a field called Cell_No and it contains values like the following..

BTS name =Rokupa,Cell ID=9

I want to create a new field called [BTS Name] which will be 'Rokupa'

and another Field called [Cell ID] which will be 9.

The first new field will be everything after the first = to anything before the comma.

and the 2nd field will be anything after the last =

but i am unsure how to do this, can anyone help please?

[nagaiank · Accepted solution]

Try

Load SubField(SubField([Cell_No],'=',2),',',1) as [BTS Name]

        ,SubField([Cell_No],'=',3) as [Cell ID]