I am creating a program that first reads each line of a fixed-length field document. Each line is a record, and depending on which character you are at, the values mean different things (for example, characters 1 through 20 may be an identification number). I am running into a problem when I load these through the JDBCODBC driver into SQL Server where it is dropping the white spaces. This means that when I am parsing the data, if a field has 3 characters instead of the 4 designated to it, all the fields following that will be off by one characters.
222 333 444 would be parsed as 222, 333, 444 (fields separated by commas)
22 333 444 would be parsed as 22, 334, 44
Can you post the code you using? Nothing in JDBC should be dropping white spaces, although its possible this may be a driver issue. I'd also consult the driver documentation to see if there are any parameters you can pass into the connection string related to white space handling.
the code and the problem you have in your first post don't seem to relate.
We can see that you are splitting strings separated by ' , and putting the results in three tables based upon the starting sequence of the split.
Wow. I can't believe I overlooked something like this. Every time I split the string on an apostrophe, it cuts that character out, therefore when a field had a description with a possessive noun it was removing those characters. I have it replacing the characters with a space now and we're back up and running. I feel like such a schmuck!