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

Replace Specific Character At A Specific Position?

Dec 1, 2011

I was wondering how I would replace a specific character at a specific position.[code]...

View 7 Replies

Replace A Char From String At Specified Position?

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

Regex - Replace Space In A String At Random Position In .net?

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

Forms :: Replace Comma With Regex.Replace?

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

Insert A String Into The Big Files On Specific Position?

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

Use Regex To Replace Non-word Chars In A Specific Piece Of String?

May 5, 2009

I have text file with a row like this:

[Code]...

View 2 Replies

VS 2005 Comma Seperated String To Multiple Comma Separated Strings?

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

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

Replace Each Space With Two Separated By Comma

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

VS 2005 RegEx - Remove '; (anything):' And Replace It With A Single Comma?

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

TRying To Replace One Specific Character Of String With New Character Entered By User

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

Get Closest Position To Specific Position?

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

VS 2008 - Replace Character By Position

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

String.replace - Replace The New Format YYYY-MM-DD Back To YYYYMMDD In The Code

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

Comma Separated Value Find The Value In A Comma Separated String?

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

Split Comma Separated String In Text File And Save Each String In Different Variable?

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

Get A Regular Expression That Can Validate That A String Is An Alphanumeric Comma Delimited String?

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

How To Add Element To Specific Position

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

C# - Inserting XML Node At Specific Position?

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

Read File From A Specific Position?

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

VS 2005 Reading A File From A Specific Position

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

VS 2008 Move Cursor On Specific Position

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

How To Replace Specific Line In Text File

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

Search A Textbox For Specific Text Then Replace It?

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

VS 2010 Replace Specific Picture In .bin File?

Feb 10, 2011

Somebody would know to show some function to solve my doubt?

View 12 Replies

Split The String By Comma?

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

Set MDI Child Form To Start In Specific Position? (Or Dock In Panel)

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

Find And Replace Specific Lines In A Text File

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

Count Occurance Of A Specific Number & Specific String In Text File Using Vb8?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved