Solved

Function reader

Posted on 2008-10-15
11
223 Views
Last Modified: 2010-04-23
I need to create  a function in vb to read B1G1 ** or if it is B2G1 how would I get started. right now I have it hard coded.
0
Comment
Question by:sevensnake77
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
11 Comments
 
LVL 13

Expert Comment

by:crazyman
ID: 22722618
read from where

text file
database
regisistry
thin air
crystal ball?
0
 
LVL 2

Expert Comment

by:gwosgood
ID: 22722693
please provide more exacting details, your question is very broad.  Are you simply looking for a function that takes a string parameter and acts differently based on the variable passed to it?
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 22722712
LOL it was to early in the morning.

But what I am trying to do is where dim y as string,  I want to read a selected number,
for instance if b1g2 I would like this to select the 1 and the 2.

 Dim strNameFull As String = "B1G1 **"  ''hardcode

Dim strNameFull As String = S & y & T & y & " " & k & " "
''dynamic




Dim S As String = "B"
    Dim T As String = "G"
    Dim y As String = "[1-5]"
    Dim k As String = "**"
    Dim strNameFull As String = "B1G1 **"  ''hardcode
 
Dim strNameFull As String = S & y & T & y & " " & k & " "
''dynamic
Response.write(strNameFull)

Open in new window

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Author Comment

by:sevensnake77
ID: 22722933
I tried something like this but I get an error

If Not (exData(rowCt, 5) Like "[!A-Za-Z]*") Or "*[!0-9]*" Or "**" Then
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 22723104
do you guys have a better understanding of what I need?
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 22724177
Ok just answer this and I will give credit were credit is due.
How can I make Dim N more dynamic. so in the reader 1 can be 2 or 3

 Dim F As String = "B"
                Dim N As Integer = "1"
                Dim U As String = "G"
                Dim S As String = "**"
                Dim strNameFull As String = (F & N & U & N & " " & S)
0
 
LVL 2

Accepted Solution

by:
gwosgood earned 500 total points
ID: 22724214
How about just a simple if test for N?

If N < 4 then
strNameFull = F & N & U & N & " " & S
end if

Its not as high-level as the solution you proposed, but its straightforward.


0
 
LVL 9

Author Comment

by:sevensnake77
ID: 22724413
Well I have a reader that is reading from excel sheet. I have certain columns that read
B1G1 or B2G1, so I want to read the numeric number and pass it as a value as you see above Dim N is hard coded, but I want to read it as if 1 is not there but if 2 is the that is the value of N
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 22724504
And I want to get N from exData(rowCt, 5)
0
 
LVL 2

Expert Comment

by:gwosgood
ID: 22724819
Im sorry, I dont think I can offer you the solution you are looking for.  I am not familiar enough with Excel-VB compatibility to troubleshoot with you.
0
 
LVL 9

Author Comment

by:sevensnake77
ID: 22725027
Well I am not worried about the excel I just want a way to read the numeric number  if its 1 or 2 but no matter thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question