Find a String in VB.NET

[Federico G. Babelis]

Hi,

I need to extract a string from another string separated by "," like a .csv
file.
for example I have this string:

String1 = 000,federico,00 ,439827HGH,1233 ,FGB,0000,00,00 0

and from that string i need to extract string "federico" and string "FGB"
and separate then into another 2 strings:

String2 = "federico"
String3 = "FGB"

How this could be done in Visual Basic .NET ????

Thanks and best regards,
Federico

[steve]

dim criteria as string = "(frederico)|(F GB)"
dim pattern as string = "(^" & criteria & ",?)|(,?" & criterion & ",?)|(,?"
& criterion & "$)"
dim regExp as new regEx(pattern)
dim match as match
dim yourString as string = "000,federico,0 0,439827HGH,123 3,FGB,0000,00,0 00"
for each match in regExp.Matches( yourString)
console.writeli ne(match.value)
next

or something therebouts.

hth,

steve
"Federico G. Babelis" <fe******@gazum .com> wrote in message
news:uC******** ******@TK2MSFTN GP10.phx.gbl...
| Hi,
|
| I need to extract a string from another string separated by "," like a
..csv
| file.
| for example I have this string:
|
| String1 = 000,federico,00 ,439827HGH,1233 ,FGB,0000,00,00 0
|
| and from that string i need to extract string "federico" and string "FGB"
| and separate then into another 2 strings:
|
| String2 = "federico"
| String3 = "FGB"
|
| How this could be done in Visual Basic .NET ????
|
| Thanks and best regards,
| Federico
|
|

[Federico G. Babelis]

Steve:

Thanks but, maybe I explain this in the wrong way, because the strings
always will be different and will don't know its value at any time, the only
thing that will know is the position regarding the "," character.

any idea ?

Thanks again...
Federico

"steve" <[e-mail]> wrote in message
news:10******** *****@corp.supe rnews.com...

dim criteria as string = "(frederico)|(F GB)"
dim pattern as string = "(^" & criteria & ",?)|(,?" & criterion & ",?)|(,?" & criterion & "$)"
dim regExp as new regEx(pattern)
dim match as match
dim yourString as string = "000,federico,0 0,439827HGH,123 3,FGB,0000,00,0 00" for each match in regExp.Matches( yourString)
console.writeli ne(match.value)
next

or something therebouts.

hth,

steve
"Federico G. Babelis" <fe******@gazum .com> wrote in message
news:uC******** ******@TK2MSFTN GP10.phx.gbl...
| Hi,
|
| I need to extract a string from another string separated by "," like a
.csv
| file.
| for example I have this string:
|
| String1 = 000,federico,00 ,439827HGH,1233 ,FGB,0000,00,00 0
|
| and from that string i need to extract string "federico" and string "FGB" | and separate then into another 2 strings:
|
| String2 = "federico"
| String3 = "FGB"
|
| How this could be done in Visual Basic .NET ????
|
| Thanks and best regards,
| Federico
|
|

[steve]

just make variable what needs to be variable...

=============== =====

Imports System.Text.Reg ularExpressions

Public Sub Main()
Dim thingsToMatch() As String = {"federico", "FGB"}
printMatches(th ingsToMatch,
"000,federico,0 0,439827HGH,123 3,FGB,0000,00,0 00")
End Sub

Private Sub printMatches(By Val thingsToFind As String(), ByVal
stringToSearch As String)
Dim criteria As String = "(" & Join(thingsToFi nd, ")|(") & ")"
Dim pattern As String = "(^" & criteria & "(?=,?))|((?=,? )" & criteria &
"(?=,?))|((?=,? )" & criteria & "$)"
Dim regExp As New Regex(pattern)
Dim match As Match
For Each match In regExp.Matches( stringToSearch)
Console.WriteLi ne(match.Value)
Next
End Sub

this is just a quick/maintainable way of parsing your string...make it what
you want...if you don't like regular expressions, there's always
string.indexOf( )

hth,

steve

[Jared]

First of all, you souldn't post the same question in multiple groups.

here is the answer you are looking for

Dim MyArray() As String = string1.Split(" ,")
String2 = MyArray(1)
String3 = MyArray(5)

"Federico G. Babelis" <fe******@gazum .com> wrote in message
news:uC******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I need to extract a string from another string separated by "," like a
.csv
file.
for example I have this string:

String1 = 000,federico,00 ,439827HGH,1233 ,FGB,0000,00,00 0

and from that string i need to extract string "federico" and string "FGB"
and separate then into another 2 strings:

String2 = "federico"
String3 = "FGB"

How this could be done in Visual Basic .NET ????

Thanks and best regards,
Federico

[steve]

he's searching for values w/n a string...right? if so, he doesn't know in
which array element a match will occur. second, if this is the case, this
method leaves a lot to be desired as far as finding the position w/n the
source string the match(es) occur.

now if he actually is parsing a cvs file then a more *refined* split is
called for since the value itself may contain a comma...

' for example...else, better to read/process file a line at a time
' to avoid memory problems w/ large files
dim records() as string = split(someCvsFi le, vbcrlf)
dim record as string
dim rexExp as new regex(",(?=(?:[^']*',[^']*',)*(?![^']*',))")
for each record in records
dim columns() as string = regExp.split(re cord);
dim column as string
for each column in columns
console.writeli ne(column)
next
next
"Jared" <VB***********@ email.com> wrote in message
news:10******** *****@corp.supe rnews.com...
| First of all, you souldn't post the same question in multiple groups.
|
| here is the answer you are looking for
|
| Dim MyArray() As String = string1.Split(" ,")
| String2 = MyArray(1)
| String3 = MyArray(5)
|
| "Federico G. Babelis" <fe******@gazum .com> wrote in message
| news:uC******** ******@TK2MSFTN GP10.phx.gbl...
| > Hi,
| >
| > I need to extract a string from another string separated by "," like a
| > .csv
| > file.
| > for example I have this string:
| >
| > String1 = 000,federico,00 ,439827HGH,1233 ,FGB,0000,00,00 0
| >
| > and from that string i need to extract string "federico" and string
"FGB"
| > and separate then into another 2 strings:
| >
| > String2 = "federico"
| > String3 = "FGB"
| >
| > How this could be done in Visual Basic .NET ????
| >
| > Thanks and best regards,
| > Federico
| >
| >
|
|

[Paul Bromley]

Take a look at Regex - you ill find a lot
of very useful techniques that you can apply to many things. It is very easy
then to do the split that you ar aiming to achived based on the comma
delimiter. There are a number of very good sites on Regex if you look at
Google. Start with a couple of simple Regexes.

I used something like below to convert an address delimited by commas into
an address block. Knowing my coding, this may not be the most elegant way -
but ot works for me!

Imports System.Text.Reg ularExpressions
Dim SplitAddress() As String
Dim strAddressEleme nt As String
Dim mAddress As String

SplitAddress = Regex.Split(mAd dress, ",")

For Each strAddressEleme nt In SplitAddress
mDemographics += strAddressEleme nt.Trim & ControlChars.Cr Lf
Next
Best wishes

Paul Bromley

"Federico G. Babelis" <fe******@gazum .com> wrote in message
news:uC******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I need to extract a string from another string separated by "," like a ..csv file.
for example I have this string:

String1 = 000,federico,00 ,439827HGH,1233 ,FGB,0000,00,00 0

and from that string i need to extract string "federico" and string "FGB"
and separate then into another 2 strings:

String2 = "federico"
String3 = "FGB"

How this could be done in Visual Basic .NET ????

Thanks and best regards,
Federico

[Cor Ligthert]

Hi Steve

Have a look at the split method

http://msdn.microsoft.com/library/de...splittopic.asp

That is in my opinion made for your problem

I hope this helps?

Cor

"steve" <[e-mail]> schreef in bericht
news:10******** *****@corp.supe rnews.com...

dim criteria as string = "(frederico)|(F GB)"
dim pattern as string = "(^" & criteria & ",?)|(,?" & criterion & ",?)|(,?" & criterion & "$)"
dim regExp as new regEx(pattern)
dim match as match
dim yourString as string = "000,federico,0 0,439827HGH,123 3,FGB,0000,00,0 00" for each match in regExp.Matches( yourString)
console.writeli ne(match.value)
next

or something therebouts.

hth,

steve
"Federico G. Babelis" <fe******@gazum .com> wrote in message
news:uC******** ******@TK2MSFTN GP10.phx.gbl...
| Hi,
|
| I need to extract a string from another string separated by "," like a
.csv
| file.
| for example I have this string:
|
| String1 = 000,federico,00 ,439827HGH,1233 ,FGB,0000,00,00 0
|
| and from that string i need to extract string "federico" and string "FGB" | and separate then into another 2 strings:
|
| String2 = "federico"
| String3 = "FGB"
|
| How this could be done in Visual Basic .NET ????
|
| Thanks and best regards,
| Federico
|
|

[steve]

i gave a split method example too...look in this thread. also, i'm not the
op. i gave two examples b/c of the vagueness in the description of what the
op is trying to acheive...one being a delimited string search returning
matches...the other treating the input as a cvs, tick (') encapsulted, comma
separated stream of data. hopefully, one of the two is exactly what's
needed...else, there is enough there for the op to work with.

thanks for your thoughts though.

post you later, cor.

steve
"Cor Ligthert" <no**********@p lanet.nl> wrote in message
news:OX******** ******@tk2msftn gp13.phx.gbl...
| Hi Steve
|
| Have a look at the split method
|
|
http://msdn.microsoft.com/library/de...splittopic.asp
|
| That is in my opinion made for your problem
|
| I hope this helps?
|
| Cor
|
| "steve" <[e-mail]> schreef in bericht
| news:10******** *****@corp.supe rnews.com...
| > dim criteria as string = "(frederico)|(F GB)"
| > dim pattern as string = "(^" & criteria & ",?)|(,?" & criterion &
| ",?)|(,?"
| > & criterion & "$)"
| > dim regExp as new regEx(pattern)
| > dim match as match
| > dim yourString as string =
| "000,federico,0 0,439827HGH,123 3,FGB,0000,00,0 00"
| > for each match in regExp.Matches( yourString)
| > console.writeli ne(match.value)
| > next
| >
| > or something therebouts.
| >
| > hth,
| >
| > steve
| >
| >
| > "Federico G. Babelis" <fe******@gazum .com> wrote in message
| > news:uC******** ******@TK2MSFTN GP10.phx.gbl...
| > | Hi,
| > |
| > | I need to extract a string from another string separated by "," like a
| > .csv
| > | file.
| > | for example I have this string:
| > |
| > | String1 = 000,federico,00 ,439827HGH,1233 ,FGB,0000,00,00 0
| > |
| > | and from that string i need to extract string "federico" and string
| "FGB"
| > | and separate then into another 2 strings:
| > |
| > | String2 = "federico"
| > | String3 = "FGB"
| > |
| > | How this could be done in Visual Basic .NET ????
| > |
| > | Thanks and best regards,
| > | Federico
| > |
| > |
| >
| >
|
|

[Cor Ligthert]

Hi Steve,

Normaly I do not echo, I saw it when I had sended the message that there was
more, however I did not correct that (although I was in doubt) I thought it
is even more confusing for the OP, however it was an accident. It is not my
normal way of behave.

Sorry

Cor