subfield?

[Anonymous]

Hi,

I have the a field that is formatted like this example:- 100:780:876:600000

What is the easiest way to have each number in its own field in the expression formula?

Cheers,

Laura

[arulsettu]

Hi

try like this

SubField('100:780:876:600000',':',1) as filed1,

SubField('100:780:876:600000',':',2) as filed2

SubField('100:780:876:600000',':',3) as filed3

SubField('100:780:876:600000',':',4) as filed4

[Anonymous]

Hi,

the field that I used was just to show an example of the format.  their all different

[arulsettu]

can u post sample and your expecting result

[Anonymous]

I've used MID:

MID([Tech1Data],8,3)