Splitting Fields 2

[ganjass]

CR8

I have a field that consists of Address,Town and country in the same field each seperated by a *, how would i split this into 3 seperate fields in crystal

Cheers

 

[SmpTraining]

Create 3 formulas as follows:

@Address
Split(<fld>, &quot;,&quot[1]

@Town
Split(<fld>, &quot;,&quot[2]

@County
Split(<fld>, &quot;,&quot[3]


Steve Phillips, Crystal Trainer/Consultant

http://www.smptraining.co.uk

 

[synapsevampire]

Steve meant:

Create 3 formulas as follows:

@Address
Split(<fld>, &quot;*&quot[1]

@Town
Split(<fld>, &quot;*&quot[2]

@County
Split(<fld>, &quot;*&quot[3]

-k