G
Guest
Hi,
I have a VB.Net program that extracts data from Word document tables and saves it off to Sql Server. I notice that when it gets to the database, there are two nonprintable characters on the end of each field. I thought of using substring-before to parse these out, but I'm not sure how to refer to them as they are just represented as squares in the database. I'd also like to convert number strings to numerics but need to get rid of these first. Any idea of how I can identify what they are in order to use substring-before? Or is there some other function that would work better?
Thanks
I have a VB.Net program that extracts data from Word document tables and saves it off to Sql Server. I notice that when it gets to the database, there are two nonprintable characters on the end of each field. I thought of using substring-before to parse these out, but I'm not sure how to refer to them as they are just represented as squares in the database. I'd also like to convert number strings to numerics but need to get rid of these first. Any idea of how I can identify what they are in order to use substring-before? Or is there some other function that would work better?
Thanks