I have a text file that has 100 entries. each entry is on a new line and is it ALL CAPS. It looks like this:
JOHN BOB HARRY MARK
KATIE SARA VALERIE MICHELLE
etc...
I need to be able to access the file, pass through it and change every name on each line to lowercase with a capitlized first letter, so that it looks like this:
John Bob Harry Mark
Katie Sara Valerie Michelle
I know that I am may have to use the string function UCFIRST() and STRTOLOWER(). My main problem is that I don't know how to access the file, make the changes, and at the same time, keep the same formatting (it has to keep the same formatting for database purposes). any thoughts?
Blue