runswithsizzors
Well-known member
I have an excel file that I am uploading and adding to a database. The database column for the state allows only 2 characters. Well the excel files that have been coming in lately have had some extra space.
When they do get uploaded they have that nice � character appended to the state which case the app to fail.
So I am brain dead on string manipulation. I need to take the first 2 characters and use just them. I tried trim and that didn't work. Any body have a suggestion for me. Thanks!
When they do get uploaded they have that nice � character appended to the state which case the app to fail.
So I am brain dead on string manipulation. I need to take the first 2 characters and use just them. I tried trim and that didn't work. Any body have a suggestion for me. Thanks!
