Solved

Function reader

Posted on 2008-10-15
11
213 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
  • 7
  • 3
11 Comments
 
LVL 13

Expert Comment

by:crazyman
Comment Utility
read from where

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

Expert Comment

by:gwosgood
Comment Utility
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
Comment Utility
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
 
LVL 9

Author Comment

by:sevensnake77
Comment Utility
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
Comment Utility
do you guys have a better understanding of what I need?
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 9

Author Comment

by:sevensnake77
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
And I want to get N from exData(rowCt, 5)
0
 
LVL 2

Expert Comment

by:gwosgood
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now