String Functions

[bld21]

I am using crystal 2008. I have string field of 150). I setup a formula field for -

Leftletter_tracking.usps_data},20) which shows as
32202,918,4/25/2010. Which works exactly how I want it.

But I would like to then brake this apart into 3 columns as 32202, then 918, then 4/25/2010.

I can get the first & last fields using the LEFT & RIGHT functions. But I can get the MID function to work for just "918".

Any ideas?
Thans!

 

[Turkbear]

Hi,
Don't have access to the CR program to test but using InStr function to locate the 1st and 2und commas should help in parsing the string with the MID function.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bld21]

Thanks, I was able to figure out the Mid function.