split

Excel: Generate a SQL-Query from huge Excel

Hi guys, I have a huge excel with thousands of rows and I need to generate an sql query to insert the data into a sql server database. The format of the excel is the following 1 | string1 | another string string2 string3 2 | AAA AAA | ZZZZZZZ BB BBBB CCCC CC The first column is a row counter, it doesn't matter. The ...

Splitting list in python

Hi guys, I have a list which I have obtained from a python script. the content of the list goes something like: The content below is in a file but I loaded it into a list for comparing it to something else. But now I have to split this list such that each new list created contains the complex name with the corresponding number. Hope it i...

How to split an fileset in Ant into multiple sets

I have a set of files that I am picking up in an ant build, which I want to split into equal sized sub sets. What is a good simple way to do this in Ant without adding custom tasks. Example: Fileset contains TestOne.java TestTwo.java TestThree.java TestFour.java TestFive.java TestSix.java I would like 3 filesets Fileset1 TestOn...

special string splitting in Ruby

Hi I am trying to figure out the best way to do this... Given a string s = "if someBool || x==1 && y!=22314" I'd like to use Ruby to seperate statements and boolean operators.. so I'd like to split this into ["if","someBool","||","x","==","1","&&","y","!=","22314"] I could use s.split(), but this only splits with space as delim...

T-SQL: Parsing String with Multiple delimiters.

I need to be able to query a SharePoint database for survey results. The type of data I'm having problems with is a "Rating Scale" value. So the data in each table column represents a whole group of sub-questions and their answers. So the following is an example of what is found in ONE column: 1. Our function has defined how Availa...

Algorithm: Split a string into N parts using whitespaces so all parts have nearly the same length

I am looking for a algorithm that takes a string and splits it into a certain number of parts. These parts shall contain complete words (so whitespaces are used to split the string) and the parts shall be of nearly the same length, or contain the longest possible parts. I know it is not that hard to code a function that can do what I wa...

.NET Regex query to find only ONE new line...

I have a huge string that looks like this: "Text Text Text Text Text Text Text Text Text Text Text Text " Note that in between each text block is a new line. Also note that the very final text block has TWO new lines after it. So when I do a string[] strArray = Regex.Split(content, "\r\n"); This works well, since it looks for a...

C#: What's an effecient way of parsing a string with one delimiter through ReadLine() of TextReader?

C#: What's an effecient way to parse a string with one delimiter for each ReadLine() of TextReader? My objective is to load a list of proxies to ListView into two columns (Proxy|Port) reading from a .txt file. How would I go upon splitting each readline() into the proxy and port variables with the delimiter ":"? This is what I've got s...

Wind blowing on String

I have some basic idea on how to do this task, but I'm not sure if I'm doing it right. So we have class WindyString with metod blow. After using it : System.out.println(WindyString.blow( "Abrakadabra! The second chance to pass has already BEGUN! ")); we should obtain something like this : e ...

Split comma-separated parameters in LaTeX

I am trying to build a command which is similar to LaTeX \cite{}, which accepts a comma-separated list of parameters like this \cite{Wall91, Schwartz93} I would like to pass each item in the comma-separated list which the parameter represents to another command and return the concatenation of the individual results. I imagine it to be ...

Store a long string into mult array

Hello All, I have a long string arrays, which looks like that var callinfo_data=new Array( "1300 135 604#<b>Monday - Friday: 9:00 a.m. to 5:30 p.m. AEST</b>", //Australia .. "0844000040#<b>lunedì-venerdì ore 10:00 - 17:00 CET</b>", //Switzerland (it) "212 356 9707#<b>Hafta içi her gün: 10:00 - 18:00</b>", //Turkey "08451610009#<b>M...

Split text at the first instance of a letter

I have a bunch of product sku's that look like: abc234 asdf234324 adc234-b result: abc 234 asdf 234324 adc 234-b I want to split the text at the first instance of a letter. When I say split, basically I want to have access to both parts of the text, maybe in an array? What's the best way to do this? ...

Can you use zero-width matching regex in String split?

System.out.println( Arrays.deepToString( "abc<def>ghi".split("(?:<)|(?:>)") ) ); This prints [abc, def, ghi], as if I had split on "<|>". I want it to print [abc, <def>, ghi]. Is there a way to work some regex magic to accomplish what I want here? Perhaps a simpler example: System.out.println( Arrays.deepToStrin...

Regex to split up text into 6 columns

This is the text file well a part of it and I want it so I can have it as: Column 1 = distribution Column 2 = votes Column 3 = rank Column 4 = title Column 5 = year Column 6 = Subtitle (but only where there is a subtitle) The regex I'm using is: regexp = "([0-9\\.]+)[ \\t]+([0-9]+)[ \\t]+([0-9\\.]+)[ \\t]+(.*?[ \\t]+\\([0-9]{4...

What's the best way to remove portions of a string? (C#)

I am looping through an array and there is a string in there that reads like this example: "1001--Some ingredient". Right now, as I loop through the array I am getting the whole string string ingCode = theData[i + 1]; But what I really need is simply "1001" and not the whole shibang. ...

Regex split into overlapping strings

I'm exploring the power of regular expressions, so I'm just wondering if something like this is possible: public class StringSplit { public static void main(String args[]) { System.out.println( java.util.Arrays.deepToString( "12345".split(INSERT_REGEX_HERE) ) ); // prints "[12,...

Get image url from rss Cdata

Hi , I start testing android , trying to get image from xml my Image is hosting inside xmlnode <a href="http://www.site.com/id/?id=41564&quot;&gt;&lt;img src="http://www.site.com//news/images/2010/03_march/imagestock/thumb/22.jpg&quot; align="left" /></a> more text comes here i trying to get the http://www.site.com//news/images/2010/0...

bzr: Detach a repository subdirectory into a new repo

Hi, I have a bzr repository called misc. Naturally, it got clogged with lots of subdirectories which now deserve a repo of their own. How do I detach a subdirectory, say misc/docs, into a new repo called doc? I have tried: bzr split misc/docs But got : bzr: ERROR: To use this feature you must upgrade your branch at file://...

Identity column in SQL CLR Split UDF

How can I return a identity column with a standard SQL CLR Split UDF for example the code below will return a table with the string value split by delimiter, I need to somehow return an identity column as well. <SqlFunction(FillRowMethodName:="FillRow", TableDefinition:="value nvarchar(4000)")> _ Public Shared Function GetStrings(ByVal ...

Split string into multiple lines

I have a long string of comments that I'd like to split into multiple lines. It's currently displayed as <%= Html.Encode(item.important_notes) %> I've played with using .Substring to split it, but can't figure out how to prevent it from splitting in the middle of a word. Instead of characters 1-100 on line 1 and 101-200 on line 2, I'...