MSDN Archive Home
Help and FAQs
All Resource Updates
Change History (all pages)
Resource Page Description
Takes a string of \n separated values and puts a comma before each space for further use in the "IN" clause of a SQL query. There is also an option of enclosing "words" in apostrophes.
I created this little app because I work a lot with data creating different kinds of queries and running reports. Sometimes this utility comes in handy when I need to create a list quickly. There is also an option to copy the result into buffer
How it works:
Every change of text (TextChanged event) triggers the following sequence of events:
split the entry string by \n's (note to self -- change to Environment.NewLine)
if the option to enclose items in apostrophes is checked, then enclose item in apostrophes
append comma and Environment.NewLine
show the result in the right box
check the conversion
match source and result strings character-by-character ignoring everything but the alphanumeric characters. If conversion succeeds, the form window shows "all good". Otherwise, it points out the first occurrence of the error.
yet to add
option to ignore blanks
option to add \n at the end of the created line
Sep 22 2010 at 1:13 PM
, version 14
Sign in to add a comment
Wed Sep 22 2010 at 7:00 AM
More Tags ...
Visual Studio 2005
Visual Studio 2008
Visual Studio 2010
Manage Your Profile
MSDN Flash Newsletter
© 2008 Microsoft Corporation. All rights reserved.