Replace Comma In String But Only At Specific Position
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
ADVERTISEMENT
Dec 1, 2011
I was wondering how I would replace a specific character at a specific position.[code]...
View 7 Replies
Apr 29, 2011
Hello all, im now trying to create a way to replace the last char of a string with "4"[code]....
View 7 Replies
Mar 1, 2012
I want to select a random space in a string and replace it with a word (%word%) but there is a problem. The position cannot be fixed as i want it to be inserted at a random break. Few things which iam considering :
1)break the string at a space and merge it with the word
2) find a random space and replace it with the word. I like this point and so far all i have is break the selectedtext into string array and then iterate over each line. But i don't know how to find a random string position? Any short and sweet code please?
If (rtfArticle.SelectedText.Length > 0) Then
Dim strArray As String() = rtfArticle.SelectedText.Split(New Char() {ChrW(10)})
For Each str3 As String In strArray
[code]....
View 2 Replies
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
May 29, 2011
I have tried with filestream but it also changed the strings that is in position
Dim fs As FileStream = File.Open("C: est.blah", FileMode.Open, FileAccess.ReadWrite)
Dim testdata As String = "a"
fs.Write(Enc.GetBytes(testdata), 0, testdata.Length)
[Code]...
View 6 Replies
May 5, 2009
I have text file with a row like this:
[Code]...
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
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
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
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 17, 2011
I am writing a hangman type game and I am displaying the word to the user in a label as all *'s, but I cannot figure out how to have just one of the *'s changed in the label to the correct letter when the user inputs the correct letter into the text box and clicks the check letter button.Everything else in the program works perfectly, except for this part.[code]When I use the .Replace it changes all of the *'s to the correct selected letter.
View 2 Replies
Mar 9, 2010
I also have a function that returns ALL tiles on the map and they're X, Y position. How could I find out which one is closest to the position I specify? I can't figure out how to go about it. how to implement it with this. Heres a MADE UP example if what I'm trying to do:
Dim MyPosition as New Position()
MyPosition.X = 400
MyPosition.Y = 400
Dim tList as New List(Of Tile) = MyMap.GetTiles
Now, I can already do the stuff above, but what I need to make is something like this:
tList.GetTileClosestToPosition(MyPosition)
View 2 Replies
Apr 1, 2009
Lets say I have a label with the text "_ _ _ _ _ ", some underscores. Now what if I want the program to locate the 3rd underscore and replace with something else. Is this possible? I was guessing by getting the character's position first and somehow there is a function that replaces characters by their position.
View 11 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
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
Dec 5, 2011
These is the content of my txt file which is saved in D drive in my pc abc,1,2,3..I tried the flowing but it didn't work:[code]I am getting error on this line.. data = line.Split(","c)...it says this line isn't in use anymore or something and that I rather use LineInput but thats asks for filenumber and i don't know what that is. I am sorry but I am a complete beginner. what else can I try? [code]ok that error is gone now but now if I want to add these values to a list box..how can i do that?
View 1 Replies
Jun 23, 2011
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][,]).*$
View 3 Replies
Oct 8, 2009
<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<zylab>
<document version="1.1" guid="{5BB6C5FF-FDA4-4FC5-99A2-20CFDF5651FE}" date="20060928"
[code]....
View 3 Replies
May 14, 2012
I have an XML file and I am loading it in Xmldocument. This document has a node with some child nodes like this
<xml here>
<somenode>
<child> </child>
<children></children>
[code]....
here somenode has some children where first and last children node names are same where as other nodes except the first and last node has some diffrent name ( identical to each other ). I am creating a function to insert a node at specific position, I am not sure about the criteria but may be in the mid.
how can I insert node in specific position. I am using XMLnode.appendChild method for insertion Do I need to rearrange/sort nodes after insertion. How can I determine what is structure and how should I find where the new node should be added according to current document structure.
View 2 Replies
Jan 4, 2010
I am to search for a particular string in a text file, which I can do using a regular expression.Upon getting this string I am supposed to search for another one then, find a value corresponding to some time step and write it to an excel file.How do I indicate the position from which I want my reader to commence? Let's say my match.Index returns 100 000 as the location for the first string I was searching for. How do I then resume my new search at this point?
View 10 Replies
Jan 9, 2010
I want to read a file from a specific position and at the same time i want to use the StreamReader.Peek to check out how it works....... So i tried out this
[Code]...
View 13 Replies
Jun 12, 2010
I have made a code where when the timer starts the botton appears randomly and my mouse position is placed on the button automatically if the progress bar has started... Here is my
[Code]...
View 5 Replies
Aug 12, 2009
I was wondering how I would go about replacing a specific line of text with different text, and then later reading a specific line of text (from the same file). The text file has a lot of lines, and basically the layout is like this:
Something1 Data I want to read
Something2 Data I want to read
Something3 Data I want to read
Each line has a specific word, and then after that word is the data I want to use for the form.
View 10 Replies
May 21, 2010
Is there a way to look in a textbox for some text1 and then if its there, it is replaced by text2?
View 3 Replies
Feb 10, 2011
Somebody would know to show some function to solve my doubt?
View 12 Replies
Feb 10, 2011
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?
View 5 Replies
Dec 6, 2009
How can I make my MDI child form to load in a specific position in the parent form? Or preferably, how can I make the child form Dock Inside a Panel in the parent form?
View 4 Replies
Aug 4, 2011
I have a program that will read a text file and put information from the text file into multiple text boxes. What I am trying to do now is be able to change the values in the textboxes and be able to write the specifc changes back to the text file. One way I though of doing that was using a while loop and copy the lines of the text file to another text file, then when it finds the line that has the specific change from the text box, make the change and continue writing the line until it reaches the end of the file. Then I was going to copy the file and overwrite the original, escientally making the change to the new file. Right now it will make the new file but will just make a blank text file. I think the problem is in the while loop statement but I am not sure. Here is the code below:
Code:
Private Sub submitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles submitButton.Click
Dim trackname As String
[Code].....
View 1 Replies
Dec 13, 2010
i am a beginner in vb8 i have a text file named alarm.txt,sample alarm.txt file is shown below
can someone help me to read the alarm.txt file and extract data.for eg
[Code]...
View 1 Replies