What CF tags do I use ? - still cannot get it to work
I think I saw this post somewhere but I cannot find it. I tried myself and got it partially to work but not entirely.
I have a name, like Joe Smith, and I need to output it to J. Smith. I think I can do that. But where I have problem is if the the name is Joe C Smith (no period after the middle C). I need to convert that to J.C. Smith, or J. C. Smith. My current technique makes it J. C Smith (no period after the middle C).
What coldfusion functions would I use to convert Joe C Smith to J.C. Smith, or what sql commands, if that is a better approach.
