I am not the one getting the tatoo. I am mearly helping a friend out. Getting a word tatooed onto your body is not my idea of a good tatoo - especially when it is your name (even if it is in chinese symbols). Why would you want that??? In case you forget what your name is??? "Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

thank you... i will look into it. "Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

It's my pleasure to help you. :cool:

With a single line of code: Dim cleanString = Regex.Replace(LineText, "[^A-Za-z\d ]", " ") Despite everything, the person most likely to be fooling you next is yourself.

You could easily do this in a RegEx by itself and avoid looping through the matches. \W captures all non-word characters (anything not a-z A-Z or 0-9), so you can then just use the Replace method of the Regex class. Dim resultString As String resultString = System.Text.RegularExpressions.Regex.Replace("ABC$%123*>890!#XYZ", "\W", " ") I haven't done VB since VB6, but I assume that should work as it's a simple statement.

(via Instant VB): Dim cleanString As String = String.Empty Dim reg As New Regex("[A-Z]|[a-z]") Dim coll As MatchCollection = reg.Matches() For i As Integer = 0 To coll.Count - 1 cleanString = cleanString & coll(i).Value Next i David Anton http://www.tangiblesoftwaresolutions.com C++ to C# Converter C++ to VB Converter C++ to Java Converter Instant C#: VB to C# converter Instant VB: C# to VB converter Instant C++: convert VB, C#, or Java to C++/CLI Java to VB & C# Converter: convert Java to VB or C#

So sorry, i thought i clicked on the sql link... my appologies... "Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Support123 wrote: i am going to run this vb.net code in a ssis package (script task)... Even more of a reason to secure the code. Support123 wrote: so i dont think the user will be able to add bits to the query... All it takes is a screwed piece of data, that you're assuming is good, to screw up your database. You do know what "assume" really means, don't you? Support123 wrote: The user wont see the results of these queries as it does not return any values to them... Well, the database returns data to someone at some time in the future. The users will eventually see the results. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

okay, thanks... i will keep that in mind... i will change it when i get this working :-) "Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

okay, thanks. :-) "Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

This article[^] provides more information on the subject. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

It would make more sense if you posted this reply to the OP instead of myself. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

try setting VisibleDate as well asa SelectedDate (you would assume that VisibleDate is set to SelectedDate but it isnt by default!)

Support123 wrote: this bit of code is in a javascript file No, it's not. This is code snippet you posted is VBScript. sorry about that... i was thinking one thing and writing another. I had a java question too (i am working on a ssis project and asp.net project so i messed up the question). i appologize and thank you for the info. I will add the objOutFile.Close() section to the VBSript. (i dont know what the error is exactly... it is not displaying anything of use... it is saying that i have issues in one of my script files (vb.net) in the ssis package but it is working fine through visual studio... Only a problem when it is ran through a job in sql, so i thought that maybe the VBScript needed to be tweeked a bit.) I will test to see if it works. Thank you for your time. "Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Thank you i will try it :-) "Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Support123 wrote: it grays it out I think you can change it to some other colors from CSS Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)

Support123 wrote: I hope this is more clear??? Yes, it is clear now. Can you provide some table structure for a more precise answer ? It would help me allot. "A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder coolestCoder

select replicate('.', 9 - len(ltrim(rtrim(TestColumnValue)))) + ltrim(rtrim(TestColumnValue)) from YourTable and this will left prefix with '.' character your field. Nuclear launch detected