Regex only matching one group
You can use Regex.Matches: var matches = Regex.Matches(input_string, regex); foreach (var m in matches) { // do whatever } Or, you can get a match, then get the next match, etc: var m = Regex.Match(input_string, regex); while (m.Success) { // do something with this match // then get the next...
Caché SQL: Select string segments as separate columns?
sql,parsing,delimited-text,caché
This should work in Cache: select * from ( select $PIECE(text,',',1) fruit, $PIECE(text,',',2) color, $PIECE(text,',',3) car, $PIECE(text,',',4) name from mytable) where fruit = 'apple'; ...
how to read data delimited by space and save it to arrays,and then write it other order in new text file in c++
You are having a char array for "BXX"s, whereas you want strings. Basically, you want a string array, or even vector. The problem is that only 'B' will be read from "BXX" into your first parameter. This code works for me: #include <iostream> #include <fstream> #include <sstream> #include <string> using...
Delimit a string by character unless within quotation marks C#
Copied from my comment: Use an available csv parser like VisualBasic.FileIO.TextFieldParser or this or this. As requested, here is an example for the TextFieldParser: var allLineFields = new List<string[]>(); string sampleText = "Method,\"value1,value2\""; var reader = new System.IO.StringReader(sampleText); using (var parser = new Microsoft.VisualBasic.FileIO.TextFieldParser(reader)) { parser.Delimiters = new string[] {...
C reading in from a vertical line character delimited file
c++,file-io,delimiter,fscanf,delimited-text
Hint: when trying to use a problematic feature, do it in a small separate program. So you won't take the risk to draw wrong conclusions because of another unrelated issue. // just playing with |-separated fields #include <stdio.h> int main(int argc, char **argv) { char line[]="TOM|1234.56"; char name[20]; float value;...
Regex to validate a semi-colon seperated list of emails?
c#,regex,validation,email,delimited-text
Microsoft's regex does a pretty good job. However, it doesn't catch a few strange scenarios and a number of special characters which are valid for email. I'll give you a different regex. Choose to use it or not is your prerogative. I would separate the concerns by having one extension...
separating into columns in r - delimiter changes
r,delimited-text,strsplit,read.csv
Good old plyr works, too: txt <- readLines(n = 3) 1 00006303657102064942660780914135165036 12867 15476 15473 15474 15397 14050 2 00006319625527159782351492300309533775 12867 15473 13678 13497 15397 3 00006327933867965144524703512179615086 12867 14245 15397 15473 15474 library(plyr) rbind.fill( lapply( strsplit(txt, " "), function(y) { as.data.frame(t(y),stringsAsFactors=FALSE) # via @Arun http://stackoverflow.com/questions/17308551/do-callrbind-list-for-uneven-number-of-column } ) ) # V1...
Correct way of convert delimited texbox lines to a datagridview?
vb.net,datagridview,datatable,delimited-text,datagridviewtextboxcell
You should add the columns once, at the beginning of the app, then use DataGridView.Rows.Add() as suggested by the_lotus. You can simply pass the "holder" array: Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load DataGridView1.AutoGenerateColumns = False DataGridView1.Columns.Add("name", "name") DataGridView1.Columns.Add("service", "service") DataGridView1.Columns.Add("caller-id", "caller-id") DataGridView1.Columns.Add("address", "address") DataGridView1.Columns.Add("uptime", "uptime") End...