Visual Basic

22-Feb-06 5:20

Hello ,
I am trying to manipulate the string
Dim str as string = "YS3EB45E833005745_20050610_WINDSHIELD"

Now i just need the part that is in between the two underscores. That is in the above string i just need that part 20050610.

I am trying to remember the function that i had used to identify the occurances of a particular character in the past.

Can any one help me with this?

Thanks
-L

Jason McBurney22-Feb-06 5:23

22-Feb-06 5:23

you can use string.split() and it will be the second item in the returned array.

do you need to investigate an online backup[^] company

Slow Learner22-Feb-06 5:37

22-Feb-06 5:37

Could you please elobarate on how do we implement this in my case?
Thanks
-L

Jason McBurney22-Feb-06 5:44

22-Feb-06 5:44

 Dim str As String = "YS3EB45E833005745_20050610_WINDSHIELD"<br />
 Dim results() As String<br />
 results = str.Split("_".ToCharArray())<br />
<br />
 Console.WriteLine(results(1))<br />
 Console.ReadLine()

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemstringclasssplittopic1.asp[^]

do you need to investigate an online backup[^] company

Slow Learner22-Feb-06 5:52

22-Feb-06 5:52

Yes this works here is what i did off course the same

Dim MyString As String = "YS3EB45E833005745_20050610_WINDSHIELD"
MySplitLine = MyString.Split("_")
MessageBox.Show(MySplitLine(1))

and its returning 20050610

But like you mentioned .ToCharArray()may be an efficient way of doing it.

we need to use ToCharArray() because we are splitting a string?

Thanks
-L

Jason McBurney22-Feb-06 6:36

22-Feb-06 6:36

Slow Learner wrote:
we need to use ToCharArray() because we are splitting a string?

No, I use it for documentation purposes, it is more clear what the code is doing, imo, when I see tochararray(). That being said, I recall I may have had issues when I had a string longer than one charater. Nonetheless, your code returns the correct results, so at the end of the day, our code is managerially equvilant Smile | :)

Slow Learner wrote:
.ToCharArray()may be an efficient way of doing it.

Although many people will argue this point to death, I feel efficent is only releveant in the 20% of the code that does 80% of the work in the program. Most of a program is scaffolding to support the core logic, anyway. Therefore, who cares if some ui element take 20 extra ns to complete. The user cant tell the difference! 80% of the code should be simple and readable Smile | :)

20% (that which does the work) should be "efficent"

do you need to investigate an online backup[^] company

Slow Learner22-Feb-06 8:14

22-Feb-06 8:14

Sure i like your arugment. If the code is more readable and understandable it would be easy for another developer who comes in after we left. I agree with you Smile | :)

thanks
-L

Guffa22-Feb-06 9:53

Guffa

22-Feb-06 9:53

If you would like the code to be more efficient, you should get rid of the Split all together (as that creates at least two strings that you don't even use). Use IndexOf to locate the first and second "_" in the string, then use Substring to get the part of the string in between.

Still I agree with Jason's opinion that most of the code doesn't need to be optimized to the max. Consider how often the code will be used, and how much resources it uses compared to the surronding code.

Simple code that works is always better than optimized code that doesn't. Wink | ;)

---
b { font-weight: normal; }

Slow Learner22-Feb-06 10:57

22-Feb-06 10:57

Good explanation and thanks for the reply. I am excited trying the same thing in different ways and figure out the best option.

Here is how i am trying to get the index of the string i posted in my string YS3EB45E833005745_20050610_WINDSHIELD

Dim indexOf_ As Integer
indexOf_ = fileName.IndexOf("_")

the above one gives me the index of the first occurance of the "_". How do i get the second occurance of the "_" and then use the substring?

Thanks for the reply,
-L

Guffa22-Feb-06 11:52

Guffa

22-Feb-06 11:52

You can use either LastIndexOf("_") or IndexOf("_", indexOf_ + 1).

For Substring you need the index of the first character and the length.

The first character is located at indexOf_ + 1.
The length I believe is the index of the second _ minus indexOf_ minus one.

---
b { font-weight: normal; }

vb.net problem

pankajgarg1222-Feb-06 4:53

pankajgarg12

22-Feb-06 4:53

I want to connect sql with vb.net and want to add and delete the record programically i.e using insert alter command etc. If somebody helps me , I am in urgent need of it.

Thanks and Regards
Pankaj Garg

Re: vb.net problem

Jason McBurney22-Feb-06 8:56