new fields from existing field values

hopkinsc — Tue, 26 Aug 2014 15:46:03 GMT

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?

Re: new fields from existing field values

nagaiank — Tue, 26 Aug 2014 15:51:53 GMT

Try

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

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