I'm trying to insert a string that contains a comma into a varchar in vb.net. How do I make the insert statement I'm building understand that I want "X,Y" to be in the varchar and not X in the varchar and Y in the next column?
How to insert and retrive multiple asp.net checkboxes values to MSSQl database as comma seperaed string 1,2,3,4,5 using vb.net ? and retrieve the inserted checkbox chekched in disabled form ..using vb.net url...I want this type of whole layout in vb.net means if user registered selected seats then then next the same page load for todays date the selected seats will be disabled
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;
I am using an INSERT INTO statement and one of my database variables is a varchar(51). Can a string be directly stored as a varchar or do I need to convert this to something else beforehand?
how to insert a (,) comma between 2 (' ') in a textbox. The reason is I have a couple of checkboxes, and when checked, text is added to the textbox ex. 1''2''3''4' and so on. This is then added to a sql request so there must be a , between each '' ex. '1','2','3','4' Now I trid with doing like this:
I'm pulling records from a db table (sybase) where I have run into a problem with a long varchar field. Using the OLEdb class I convert the field into a string variable which works fine in most cases, but there are problem with a few records. Examining the field in the database it shows that the value is not null, but the length of the field is 0.(SELECT field, length(field) FROM table). When I try to convert this into a string the result is rubbish.strContent = objReader.Item(i). I can't figure out what's the problem here, so I have avoided the issue by doing a table update before I start the process of getting data (I set the field value to null if field.length = 0
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?
I used a built in function to create comma separated string using List easily.(It is not split and join but new function) I'm not able to recollect or find it. If some one knows about it and uses it please post a link to that. Framework - .net 2.0
(It is not Join or split - I know about this, .net has new built in function to create CSV format)
Check Jacob G Answer below for what i was looking for let me know your thoughts on it compared to join ;)
And whoever gave me -ve rep need to keep some patience and not hurry
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'm trying to write two regex's - you'll need to tell me if they're even possible. Both are based on VB.net syntax.
Regex 1: The string I'm testing against - Size on disk: 25,754,900,936 bytes
It has a handful of leading spaces, but the text is ALWAYS the same. I'm trying to extract out just the number (25,754,900,936).
I've tried a handful of regex's, but I can't get everything on one line. The commas are messing me up and returning multiple matches (For example, d+W+ gives me four matches, one for each set of numbers separated by commas.)
The best I've done is [0-9/,]* but that gives me 25 empty matches and one match (On match 19) of the number. I need this to match on match 1.
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 '?'
What i want to do is take particular values from a list of strings and store them into variables for that particular index. Com317,subject,1,20,M,year1the example is what is contained in each index of the list of strings. I want to select the 1 and the 20 from this list and store them into 2 variables. Been trying to do this with a for each loop but I'm not sure how i can single out these 2 values
I've got a variable which contains a string like: dim test as string
test="bjcbhiabab,1,1,50,0,1,telepathie2,1,60,0"
Now I need to seperate all those values (each seperated by a comma) into new variables let's say value1 to value9 What's the most easy to use coding for this? I haven't got a clue which coding to use for this :S
VB.NET 2010/ASP.NET 4. I am using a web service which returns a string like this: US,"UNITED STATES",MN,MINNESOTA,"MAPLE GROVE",45.1234,-93.4947,613,763,AMERICA/CHICAGO,NA,55311,"COMCAST CABLE","COMCAST CABLE",COMCAST.NET,"AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS, INC",CABLE/DSL,RESIDENTIAL,3,99,35,96,,
If I split by comma it's usually fine except in the above string I have the following: "AS13367 COMCAST CABLE COMMUNICATIONS HOLDINGS, INC" Which contains a comma and splits into two. This I don't want.
How to see if this field (array(15)) contains a comma & if it does to leave it intact into one array field? It's always constant in the same place in the array
I have string 12.3.2010,13.3.2010,14.3.2010,15.3.2010 And how to check for example: is 12.3.2010 member of this string up. If it is, messagebox ("true") If it isn't, messagebox ("false") It's important to say that size of the string is not specified, so it can have more dates.