Hi Lisa,
Try using Mid and Replace combination,it would go like this
Create a 5 different formulas for Mid function replace the
'12345-6789000' with your table field...
tonumber(mid('12345-6789000',1,1))
tonumber(mid('12345-6789000',2,1))
tonumber(mid('12345-6789000',3,1))
tonumber(mid('12345-6789000',4,1))
tonumber(mid('12345-6789000',5,1))
Then create the following single replace formula replacedigits
replace(cstr({@left1}),cstr({@left1}),'#')+
replace(cstr({@left2}),cstr({@left2}),'#')+
replace(cstr({@left3}),cstr({@left3}),'#')+
replace(cstr({@left4}),cstr({@left4}),'#')+
replace(cstr({@left5}),cstr({@left5}),'#')
this will convert the first five digits in to # then you can create text object and place the replacedigits formula along with the remaining digits
Cheers
Rahul
Edited by rahulwalawalkar - 03 Jul 2008 at 1:46am
IP Logged
