I apologize if these questions sound lame, I have some C++ experience, but, not much with string manipulation. I have a large comma delimited text file and I need to modify some data that it contains.
Some records have malformed phone numbers with random text appearing in the column. I would like to to force the phone numbers into the following format: "(555)-555-5555" and also eliminate any unecessary data that appears after 5555. Could anyone point me in the right direction?
I have looked at using GRETA to implement regular expression string matching/substitution, but I cannot figure out how to use it. Do I need to compile it as an additional library or something like that? Would anybody have any instructions for using it? The html file that's included only covers some basic syntax, function and class information.
Thanks in advance for any help or information, I really appreciate it.