June 18, 2008 at 8:34 pm
Greetings folks. This may be a little off topic here, but this is where I learned of what I am trying to do, so what the hay? I could not get Microsoft Money to work with one of my accounts, so I figured 'to heck with it', and I decided to make my own version using the tools I already have, which is SQL Server. Anyhow, the account data comes in a file called a .QIF, and when you open it with notepad it looks like about four lines of mumbo jumbo about three feet wide, with characters and squares and such, but if you copy it to word, it actually looks like something. So, using Jeff Moden's tip, control+f to find some special characters and replace them with others, bingo, I ended up with a perfect tab delimited file, ripe for BCP. My problem is that another one of my accounts, has the same looking output in word, but the only special character I can find is a ^, and I can not find a way to turn it into tab delimited. So, my question is, before I go manually changing any sensitive account data, would anyone be willing to look at my data files if I attach them, to see if maybe there is something I am missing?
Greg
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
June 18, 2008 at 10:13 pm
Such problems usually happen when you mix Unicode data with non-Unicode service characters (tabs, CR/LF, etc.)
Try to inspect your files with binary file viewer.
_____________
Code for TallyGenerator
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply