Recent content by ClearQuestion

I only changed the data as it is health information, all the letters and numbers are in the spot as they are in the file just different than the file. For example I changed one 6 letter last name with a different 6 letter last name. Otherwise it is exactly as it in the file.

Got it! Yes it does suck they are not already separated. Now I need to find the best way to separate them.

No the field contains all of the data it this one field. There is a comma before and after, I need to split it up.

Here is the raw data with a few letters and numbers changed. Paula P Chenowith906 Linden StBaxter IA 50028 Erika N Wolf5154 S Ovid AvenueDes Moines IA 50317 Jane H WReagan430 NW 2nd StEarlham IA 50072 Rubi K Owen Jr9514 Woodland Ave Apt 8Des Moines IA 50312 Michael Tubbman800 S 11th St...

The File is a Comma delimited File.

Good morning. I have a field that contains name, address, CSZ all in 1 field and I need to split the field into 3 to 5 fields. Below is how the field appears, since the name can be any length I cannot use the Left function since it will be different. Any other suggestions on how to split the...