Me again,

We have some customers sending in sheets for processing and the guys in the office are spending ages trying to re format. (please see attached)

1 - Particularly dates that have a dot or dash at the end. What's the best way to get these re-formatted ...some sort of Case structure ?? Replace Right , 1, with "" if it's a dot or dash ?


2 - The other pain is those Users putting a ", as in DITTO, for dates. Is there a way to replace the " with the offset of (-1,0) ..sort of thing ?? ...being mindfull that there may be several in succession.



Any help with above appreciated.


Stu (IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif)




Edited by: Squire_King on 05.25.04.