Alternatives
Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
You may want to take a look at String.Join:Your code can be compressed to:Dim str as Stringstr = Chr(34) + String.Join(Chr(34) + "," + Chr(34), arr) + Chr(34)(My VB skills are a bit lacking, so the syntax may be a bit off, but you get the idea).
24 Sep 2010Alan Burkhart 3 alternatives
I'd never used String.Join before. Didn't even know it was there. :laugh: However, part of the idea is to skip all empty lines AND not end up with an empty string at the end (which my first code didn't address) AND insert the quotes. To get all this done with String.Join, it still took 8...
Working since 2006 on VBA, VB6, VB.Net, C#, ASP.Net, MSSQL
- Courage is not the absence of fear, but rather the judgement that something is more important than fear.
- The fear of suffering is worse than the suffering itself.
- People need not fear the unknown if they are capable of achieving what they need and want.
- Every blessing ignored becomes a curse.
- Sometimes what's in your head isn't as crazy as you think.
- We never really grow up, we only learn how to act in public.
- You can make very bad teams with very good individuals.
- Admitting mistakes means you have a sense of responsibility in your actions and that shows you are more matured than almost anyone. -Nithin