Editing a CSV file in a C++ Program

[Brad King]

Hello All & Thank You in advance for any responses to my question.

I am writing a program at work and need a few syntax specific pointers. I will be as clear as I am able. I can program in C++ but I am a little rusty.

I need to write a program that throws an error code out when an address in the csv file do not meet a certian format. How would i setup the format after importing the file?

Correct format example: 3456 E. 36th St W
Incorrect format example: 3456 E 36 ST

I do not know how to approach making the program look for ###(space)(LETTER).##(space)(TWOCAPITALLETTERS)(sp ace)(CAPITALLETTER)

I know how to import the file, I know how to write to a file, i just don't know how to put this logic into an if/else or switch statement.

Please Help!

[sicarie]

Looks like a very good setup for a regex.

Does this look like it might help?

I'm sure you can do it with strings and tokens as well, but I think using a regex that will either pass or fail will be easier for you, and then you can just throw the string to stdout or whatever you want it on fail.

[Brad King]

Looks like a very good setup for a regex.

Does this look like it might help?

I'm sure you can do it with strings and tokens as well, but I think using a regex that will either pass or fail will be easier for you, and then you can just throw the string to stdout or whatever you want it on fail.

Is this going to be case sensitive if i use the | "or" function?

[oler1s]

Is this going to be case sensitive if i use the | "or" function?

| is not a function. It is an operator. Wait, what exactly are you talking about?

[Brad King]

| is not a function. It is an operator. Wait, what exactly are you talking about?

You are correct, forgive my error. To begin with, the option you provided worked fantastic.

When researching the option you gave me I haven't found wiether or not the operator will choose a Character based on it's case(upper or lower).

Example: ^5\d*(a|d|e)\w+2001.

I understand this statement. I just don't understand if (a|d|e) will only pick up the lowercase or the uppercase. For my purposes i need it to be case specific.

I need it to distinguish between 3456 e 63rd st w
and 3456 E63rd St W


Am I clear now? Thank you again for your help.

[sicarie]

I'm pretty sure it is case sensitive, so you would be able to put (A|D|E) and it would only pick up the capital letters.

You can always create a small function to test it and have a sample that has both, see if they both get picked up or not.

[Brad King]

I'm pretty sure it is case sensitive, so you would be able to put (A|D|E) and it would only pick up the capital letters.

You can always create a small function to test it and have a sample that has both, see if they both get picked up or not.

I have to wait for my compiler but i am going to write out my idea in notepad today.

It will follow this Process.
1. Open data file for reading
2. Open update file for writing
3. for each record in the file is the record correct?
3.a Yes write it unchanged to the update file.
3.b no fix the record and write it to the update file
4. close data file
5. close update file.

if you don't mind giving it a look on Monday I will post it then. Thanks for all your help.