C# - Replace Comma With Semicolon In Between Quotas
Jan 18, 2012
I have a csv file from which i am getting the data into a table. Example: "ABC",1,"Apple" The requirement is that the strings will be inside the quotas " " and integer will be without quotes. The above line will split into three columns. i am using stream reader class to split the line into columns using line.split(','). It was working fine unfortunately i got a record in a file where there is a comma in between the string quotes like these "ABC,DEF,ghi",2,"Orange". So instead of 3 columns now they are acting as five columns and all the conversion are failing. writing the script in C# which will replace the comma between the quotas into semicolon and don't touch the comma in between the columns.
View 2 Replies
ADVERTISEMENT
Mar 10, 2009
I am trying to filter out all unwanted characters from a string. All I want in the string is letters A-Z, numbers 0-9 as well as comma (,) plus (+) and quotes (").I figured how to do the letters and numbers, but the 3 special characters are giving me a problem. I also tried with the Chr(34) equivelant for the " sign, but no luck, as and " or , messes up the way the code is read. Here�s what I have so far, but it only works for A-Z and 0-9:
STR = System.Text.RegularExpressions.Regex.Replace(STR, "[^A-Z, 0-9, Chr(43) ]", "")
View 4 Replies
Mar 30, 2009
How could I have streamwriter write a , terminator for every space?
For example if I have a line that reads "Hello World!"
I would like streamwriter to write Hello , World
View 2 Replies
Dec 12, 2011
I am reading a csv file in VB.net and saving the line to a SQL database. At a later point in my code, the SQL line is retrieved in the application, and the Split function is used to get 'field' values. The Split is done taking comma as the separator. The application processes many other files (including excel), and the split function is used for all of them. The problem I am now facing is that one of the csv files I read, has a field value that starts with " followed by multiple values separated by a comma and ends with another ". The normal reading of the csv file results in each of those single field values is taken to be a separate value.
An example line is:
Elker,MissB,"Bus, Taxi, Train, Ferry, Parking, Toll",800253
Where there should only be separated to 4 columns, they get separated to 9 columns instead. What I want to do is replaced the commas after 'Bus' and until 'Toll' with a '?' instead. I have tried using Replace, including the overloaded one with starting position, but it ends up replacing ALL the commas in the line with '?'
Attempt 1:
If vstrLine(intStartPos) = "," Then
strRetVal = Replace(vstrLine(intStartPos), ",", "?")
end if
Where vstrLine is Elker,MissB,"Bus, Taxi, Train, Ferry, Parking, Toll",800253
and intStartPos is the first instance of a comma after the "
It returns only the '?' and not the string with 1 comma replaced by '?'
Attempt 2:
If vstrLine(intStartPos) = "," Then
strRetVal = Replace(vstrLine, ",", "?", intStartPos)
end if
It returns a string with all commas replaced with '?'
View 3 Replies
Mar 18, 2009
I have this text:
[Code]...
How to remove '; (anything):' and replace it with a single comma? I am sure RegEx can do it...
View 4 Replies
Feb 7, 2012
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), ",(?=([^""]*""[^""]*"")*[^""]*$)")
View 2 Replies
Feb 23, 2010
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]...
View 4 Replies
Nov 7, 2011
In VB6, there was a function that moves the print position along to the next tabstop, like so:
[Code]...
View 1 Replies
Jun 13, 2009
I have a txtEmail textbox
In this textbox i will get mail id s like [url]... when i press Treeview node
if treeview node.tag doesn't has email ids i will display only semicolon
so in some conditions i got values like[url]...
and also i need to remove mail ids when i un check treeview.
View 5 Replies
Jul 9, 2011
I have written a VBA (Excel macro) to open a workbook, and save it as a semicolon .CSV file, and then close it self. Excel on the server at work has a nasty tendency to start in safe mode (or at least ask if it should start in safe mode), making my Open-And-Shut macro fail. Now I've rewritten the program into VB.NET code (vs2008), but it creates a true .CSV (comma separated value), and I need semicolon. The excel file contains "last name, first name" making comma separation useless. Also making it impossible to substitute "," with ";" [Code]
View 3 Replies
Aug 15, 2011
newUserCommand.CommandText = "INSERT INTO users(username, password, security) VALUES('" & newUserNameBox.Text & "';'" & newPassWordBox.Text & "';" & newUserSecurityBox.Text & ";'"
I cannot find where the syntax error is but vstudio tells me the error is in a unclosed quotation after ;
View 1 Replies
Jul 9, 2011
I am trying to add a text file with SemiColon Delimiters to DatagridView, i did few codings but getting a error as "
"At least one of the DataGridView control's columns has no cell template"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
OpenFileDialog1.ShowDialog()
[Code]....
View 1 Replies
Dec 3, 2008
I use the following code to add a record but get the error:"Missing semicolon ( at end of SQL statement. " I removed the semicolon, placed it before the SELECT but it seems to continuously cause problems.
Quote:
Public Sub AddAccountRecord(ByVal name As String, ByVal type As String, ByVal user As String, ByVal balance As String)
Dim strSQL As String
Dim objConnection As New OleDbConnection(strConnection)
Dim objCommand As New OleDbCommand(strSQL, objConnection)
[code]....
View 4 Replies
Jun 14, 2012
I am using VB .Net to loop through a regex Match and generate a sql statement. I'm creating the sql like this
sql = "Insert Into Agencies (Address) Values"
While MatchObj.Success
sql = sql & "(""" & MatchObj.Groups(1).Value & """), "
[code].....
View 1 Replies
Apr 4, 2011
What I am trying to do is allow the user to enter a list of authors in a textbox separated by semi colons. After each author is entered, followed by a semicolon, I would like the autocomplete to work on the next name and so on (e.g., Smith, John; Eastwood, Clint...). I can get the autocomplete to work in a textbox with one name, but cannot seem to figure out how to get it to work on a list of names in a text box.
View 8 Replies
Apr 23, 2009
Is there a way to open a semicolon delimited text file to a datagrid in vb.net??
View 4 Replies
Mar 20, 2007
I have ran into an issue where I need to save some Excel data to a semicolon delimited file. (Why is an issue unto itself) And I can not find a way to do this using VB. In excel I can use Import Semicolon delimited files but I can not find a way to save them. Is there a VB constant or method I can use to save semicolon delimited files without having to write my own save procedure to format the data? such as the xlCSV, xlDIF, xlTextMSDos formats. I would think that since it can import this format that it should be able to save it.
View 6 Replies
Jun 3, 2011
I'm trying to make the autocomplete work on a list of items entered into a textbox separated by semicolons. I have a list of authors the user can choose from and it autocompletes as they type the name no problem, but what I'd like to do is after the user types a name followed by a semicolon, the autocomplete works on the next name and so on.e.g., Smith, John; Eastwood, Clint?
View 1 Replies
Jul 11, 2011
I have a string like
human, roti, makan, ghar, house, language, english, india, US, master, teacher, html, code, asp, jsp
i need code for find the input string.
View 3 Replies
May 5, 2009
The file reads in parameters and two of the parameters used to be in Date Format YYYYMMDD but will now permanently be in format YYYY-MM-DD. This change, I believe, is stopping the import of the file from working. I would like to replace the new format YYYY-MM-DD back to YYYYMMDD in the code. If possible I'd also like to see some output so I know that the old format has been replaced with the new format. The code is below. I added the two rows with .replace code in green in expecting that to be enough but it is still not working.
Public
Sub Main()
Dim R1, O1, P1, C1, strDateFrom, strDateTo, strRunDate
As
String
[CODE]...
View 3 Replies
Dec 8, 2008
I'm working on a timekeeping application in Visual Basic 2008 and am having trouble formatting a timespan for display. Here's how I want to the information:If a positive number my Label will be: lblTimespan.txt will show as "12 Hours And 15 Minutes" This works fine.If its a negative number I want to display it as "(12 Hours And 15 Minutes)'[ in red. The problem is that I can't get rid of the minus sign. [code] Thr Replace doesn't seem to want to replace the "-", can anyone suggest what to do?
View 2 Replies
Dec 9, 2011
I have a bunch of object variables which are all initialised in their declarations such that:
Private _myObject As New ThisObject("SomeString")
where ThisObject is one of a number of object types, but all are initialised using a string.
I would like to use the Visual Studio Find/Replace dialog box to search for "As New" then replace everything from "As New" to the first set of speech marks with some text such that:
EDIT
My original example could be solved using other methods. This example is more representative of the actual problem:
Private _myObjectA As New ThisObjectA("SomeString")
Private _myObjectLongName As New ThisObjectLongName("SomeString")
[Code]....
View 2 Replies
Jul 13, 2009
I am trying to think of a regex replace to replace double quotes with nothing. Example:
hello("hi there") would become hello(hi there)
"hi" would become hi
"example "3" would become example "3
-edit Maybe an easier way to explain this is, replace all " that do not have a backslash before them.
View 6 Replies
Mar 6, 2010
How can I specify in my string that I want to replace occurrences of ALL characters and replace them with a specified character? Something like this:
'assuming currentWord is a string that contains any word
_myWord = CurrentWord.Replace("a-z,A-Z", "*")
View 3 Replies
Jul 7, 2011
I am using replace function to replace a character in the file
sw.WriteLine(Regex.Replace(strLine, "\", Chr(13)))
This code is working fine, but now I want to replace two times and I want to use the replace function twice. Something like this, but it is not working . Can anyone tell me how to use Replace function multiple times?
sw.WriteLine(Regex.Replace(strLine, "\", Chr(13)).Replace(strLine, Chr(13), ""))
View 2 Replies
Apr 7, 2009
Suppose i have two strings which is given below.
CODE:
Where ever i find , it should be replaced one blank line and " replace by "
When i migrated the data from MYSQL to SQL Server 2005, i found few problem in one of the column. In MYSQL indicates as new line and " indicates as ".
View 7 Replies
Apr 8, 2011
I got this problem, is there way to use "replace" function to replace multiple strings of same list?
Like;
Dim rList As List(Of String)
rList.Add("A")
rList.Add("B")
[Code]....
View 3 Replies
Mar 8, 2009
I am trying to do this(will explain below) :
If RichTextBox1.Text = "" Then
MsgBox("No text selected!", , "Warning!")
Else
[CODE]...
I created a button , i have a richtextbox , i want to do this : i will right something in the richtextbox , and when i will select what i wrote and click on the button it will replace it with <font color="">something</font>. but instead it rights next of what i selected .. any clues how to replace it and not right next to it ?
View 7 Replies
Jan 27, 2010
Can anyone tell me how to add a comma to two values?
What I'm trying to do is read two values into variables, combine them with a comma in the middle, create an array and store the result in the array; e.g. var1,var2
It doesn't have to be a comma, a space will do. Just something I can later use to split the array when I read it.[code]...
View 15 Replies
Dec 7, 2009
The comma/dot may appear only ones. How do I modify that within this code??
bpuntingedrukt as boolean
Private Sub VoegCijferToe(ByVal sCijfer)
If Len(lblDisplay.Text) > 15 Then Exit Sub
If sCijfer = "0" And lblDisplay.Text = "0," Then
[Code] .....
View 24 Replies
