I'm trying to parse csv file with VB.NET.csv files contains value like 0,"1,2,3",4 which splits in 5 instead of 3. There are many examples with other languages in Stockoverflow but I can't implement it in VB.NET.Here is my code so far but it doesn't work...
Dim t As String() = Regex.Split(str(i), ",(?=([^""]*""[^""]*"")*[^""]*$)")
I am pretty good with perl regular expressions but evidently I am at a loss on why this doesn't work.The code below stores "Person Test" in output variable.
im output As String
Dim userName As String = "Test, Person"
Dim re As New Regex("(w+),s(w+)", RegexOptions.Singleline)
output = re.Replace(userName, "$2 $1")
So why doesn't the following code store "#Test##Person#" in output variable.
Dim output As String
Dim userName As String = "Test, Person"
Dim re As New Regex("(w+),s(w+)")
For Each Match As Match In re.Matches(userName)
output &= "#" & Match.ToString & "#"
Next
Given an input string like the following:I, Need, Some, Coffee, Before, I, "Fall, Asleep" I need to split this into parts like so:
I
Need
Some
[code]...
Splitting on the comma character alone is easy enough, but how can I handle the quotationmarks? Regular expressions is not on my strong side, and I have been googling for quite a bit without any good results.
I need a regular expression that can validate that a string is an alphanumeric comma delimited string.
Examples:
123, 4A67, GGG, 767 would be valid.
12333, 78787&*, GH778 would be invalid
fghkjhfdg8797< would be invalid
This is what I have so far, but isn't quite right: ^(?=.*[a-zA-Z0-9][,]).*$
I'm having a little trouble with this... I have a Session variable which contains a string of comma separated ID's which needs to be passed to a stored procedure but if it is more than 8000 characters, it needs to be split into more comma separated strings. For example;
[Code]...
i would like to split my data from string and put it into integer and invidual string as sample below:
this is the data i want:
Private total() As Integer = {10, 6, 2, 1} 'here consider length = 4
Private towns() As String = {"A", "B", "C", "D"} 'here consider length = 4
below is the data i get it now:
Dim total2 as string = "10,6,1" 'here consider length = 1
Dim towns2 as string = ""A,"B","C","D"" 'here consider length = 1
how to split the total2 and towns2 i get and split into total() and towns() i want.
it is i need to write a for loop to split the string by comma?
I have spent a long time debugging an application that occasionally goes awry, it ends up that the problem is that the comma delimited text files that I am looping through occasionally inserts a comma within one of the fields.
At any rate, I was loading the text file into Excel to try and spot the error which was of no help, somehow Excel parsed out the field correctly and didn't use that extra comma as a delimiter. Is there any way I can get my application to do the same?
And example field value is: "7-8-ALL (1,2&3)", but of course my split code turns this into two separate array values.
my problem is for example if
1,50
1,200
are loaded in listbox1 and i split the "," and its value to textbox1 when i select the index 1 in listbox i get the same value as first index here is my code for load the textfile to listbox
Dim linereader As New System.IO.StreamReader(OpenFileDialog.FileName)
While (linereader.Peek <> -1)
ListBox1.Items.Add(linereader.ReadLine.Split(",")(0))
End While
[Code]...
i'm using regex to get some information from a website, i have this code:
Dim request As System.Net.HttpWebRequest = System.Net.HttpWebRequest.Create("http://www.startkabel.nl/zoeken/index.php?zoek=" & TextBox1.Text)
[code].....
I want to split some text by comma from My.Settings.Text1 . I found this
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim newLines = (From line In RichTextBox1.Lines _
Let parts = line.Split(","c) _
Where parts.Length = 4 _
[code]....
but in this code knows how many splits are, and I dont't know how many will by in my settings. How to solve this problem? and how to select parts.
I have an error in this section:' convert the hours, pay rate, and allowances to numbers [code] It underlines the 1stHours and 1stRate with an error of "Comma, ')' or a valid expression contiuation expected. I'm not quite sure what this code means. [code]
View 3 RepliesI have this text:
[Code]...
How to remove '; (anything):' and replace it with a single comma? I am sure RegEx can do it...
I need my VB.net to write a file containing the following line
objWriter.WriteLine ("TEXTA " (FILEA) " TEXTB")
Unfortunatly the variable (FILEA) is causing problems i now get the error
Comma, ')', or valid expression continuation expected.
I get this error at the second dot of the IP address specified in my connection string.
Error1Comma, ')', or a valid expression continuation expected.
The code is as follows:
Option Strict Off
Option Explicit On
Imports System.Data
Imports System.Data.SqlClient
[code].....
I'm trying to read a csv file with comma separated. Problem is inside the file, it has one column which original value already contains Comma. Here is the example
[Code]....
So, when I Split the string with Comma, it gave me problem. Actually total it has 6 columns. But because of internal comma, it gave me 7 columns. And this CSV format can't change so I must deal with this problem. And so here I come out with a solution (because of its too long, I looking for better idea and solutions from you guys ):
[Code]....
I'm having some trouble converting a double to a string.I have a double value, like 43.64 and I need a string like this: "43.64"If I try to convert the double to a string I always get "43,64" what doesn't work for me..
View 5 RepliesIf I try to display a command line argument that has double quotes around, the double quotes are always stripped off. How can I avoid this?
for example, the argument is "c:xx.txt" and this displays c:xx.txt instead Console.WriteLine((My.Application.CommandLineArgs(4)))
My coworker needs me to write him a regular expression for his vb.net app.I do not know vb and he does not know regex.The regex he needs is:/.*web id: ?(d+).*/iBasically he needs to search a string for something like "web id: 345" or "web id:2534" and retrieve the ID.He took what I gave him above and was able to put this together:
Dim strPattern As String = ".*web id: ?(d+).*"
Dim strReplacement$ = "$1"
GetWebId$ = Regex.Replace(LCase$(strNote$), strPattern$, strReplacement$)
[code].....
When I'm trying to update or remove record from database I'm getting this error:
Syntax error (comma) in query expression 'Ime='Blagojce', Prezime='', Adresa='', Grad='', Telefonski_br='( ) -', Fax='( ) -', e_mail='''
Here is my connection string:
command.CommandText = "DELETE * FROM podatoci WHERE Ime='" & ime & "', Prezime='" & prezime & "', Adresa='" & adresa & "', Grad='" & grad & "', Telefonski_br='" & broj & "', Fax='" & fax & "', e_mail='" & email & "'"
where ime, prezime and so on are ListView selected items.
I want regular expression validator for my telephone field in VB.net. Telephone format should be (+)xx-(0)xxxx-xxxxxx ext xxxx (Optional) example my number would appear as 44-7966-591739 Screen would be formatted to show +44-(0)7966-591739 ext?
View 3 RepliesI'm trying to type a regular expression that follows the following format: [URL] There are no special characters or numbers permitted for this criteria. I thought I had it down, but I'm a bit rusty with regular expressions and when I tested mine, it failed all across the boards. So far, my regular is expression is:
[Code]...
I have a CSV file where the values are in double quotes and seperated by a comma. I'm getting incorrect data if I try to seperate the string with my Split function. How do I do it?
Example:[code...]
I'm using the code below to take a string and split it up into an array. It will take: Disney Land and make it two separate elements. If the string contains "Disney Land" then it is one element in the array. Works great, however it adds some empty elements to the array each time. So I just iterate over the elements and remove them if they are empty. Is there a tweak to the code below that will prevent those empty elements from occurring?
Private m_Reg As Regex
m_Reg = New Regex("([^""^s]+)s*|""([^""]+)""s*")
Dim rezsplit = m_Reg.Split(criteria)
ok, For the moment I have a string() where each element is in the structure of
[Code]...
I'm trying to find the right RegEx to capture some (potentially) repeating data. I don't know how many times it will repeat. If I give an exanple of the data and what I want to capture can anyone point me in the right direction? It's the .Net regex engine (Visual Basic)
[Code]...
Excel returns a reference of the form
=Sheet1!R14C1R22C71junk
("junk" won't normally be there, but I want to be sure that there's no extraneous text.)I would like to 'split' this into a VB array, where
a(0)="Sheet1"
a(1)="14"
a(2)="1"
[code]....
I'm sure it can be done easily with a regular expression, but I just can't get the hang of it.
I need a regular expression that requires at least ONE digits and SIX maximum. I've worked out this, but neither of them seems to work. ^[0-9][0-9]?[0-9]?[0-9]?[0-9]?[0-9]?$ ^[0-999999]$
View 4 RepliesIt seems up until now I've never used Regex, nor even heard of it. But once I did I realized how extremely useful this is. Having said, it's been 2 days since I've began looking into constructing my own patterns. My most recent being for decimals. Is the pattern I provided below "proper"? and are there also any improvements I could be making for a more efficient patter, which would minimize any possibility of a loophole? [code] So for my use, this is doing what it's supposed to being doing under every test I can through at it. But do mind the 0. and .0, I have a function to normalize these as they are proper, I just pad the left and right accordingly. I found most regex questions asked here..and yes I am doing this in vb.net so it fits. If not, then feel free to move this post somewhere else better suited for the topic of discussion.
View 12 RepliesQuick RegExp problem (i hope). I need to identify a sub string from any string based on a regular expression. For Example, take the following strings:
[Code]...
regex - regular expression to check input on multiline textbox
View 5 Replies