split

SQL Split Comma Separated Column on Delimiter

Here is a split function, it can apply as dbo.Split('sf,we,fs,we',','), when I change the string to column name it doesn't work, such as dbo.Split(table.columnName,','). Select * from dbo.Split('[email protected]','@') is works but Select * from dbo.Split((Select Email from Users),'@') has an error message: Msg 102, Level 15, State 1...

How to replace multiple strings with replace() in Javascript

Hey Guys, I'm guessing this is a simple problem, but I'm just learning... I have this: var location = (jQuery.url.attr("host"))+(jQuery.url.attr("path")); locationClean = location.replace('/',' '); locationArray = locationClean.split(" "); console.log(location); console.log(locationClean); console.log(locationArray); And here is w...

PHP: Split a string in to an array foreach char.

Hi I am making a method so your password needs at least one captial and one symbol or number. I was thinking of splitting the string in to lose chars and then use preggmatch to count if it contains one capital and symbol/number. however i did something like this in action script but can't figure out how this is called in php. i cant f...

restoring mysql db from the contents of split up mysqldump

Hi my database has started to go over 2GB in backed up size, so I'm looking at options for splitting the file and then reassembling it to restore the database. I've got a series of files from doing the following backup shell file: DATE_STRING=\date +%u%a\ BACKUP_DIR=/home/myhome/backups /usr/local/mysql_versions/mysql-5.0.27/bin/mys...

split a huge XML interms of GB's, retaining header and footer - the same structure

Hi All, My program will be receiving an XML of size upto 8GB to 10GB with the following structure: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE gsafeed PUBLIC "-//Google//DTD GSA Feeds//EN" ""> <gsafeed> <header> <datasource>Name</datasource> <feedtype>incremental</feedtype> </header> <group> <record url="" action="add" mimetype="t...

Split a VARCHAR in DB2 to retrieve a value inside

I have a VARCHAR column that contains 5 informations (2 CHAR(3) and 3 TIMESTAMP) separated with '$'. CREATE TABLE MYTABLE ( COL VARCHAR(256) NOT NULL ); INSERT INTO MYTABLE VALUES ( 'AAA$000$2009-10-10 10:50:00$null$null$null' ), ( 'AAB$020$2007-04-10 10:50:00$null$null$null' ), ( 'AAC$780$null$2007-04-10 10:50:00$2009-...

Manipulating the Split Function for two arrays

Hello all, I had a question regarding the split function used in Visual Basic. As of now I have written a function that brings in a string value. The string value returned will probably look like this "List1;List2; Field1,Field2". My goal is to use the split function for this string to put all the lists in one array and to put the field...

Split String - the Cartesian way.

Given the following string: "foo bar-baz-zzz" I want to split it at the characters " " and "-", preserving their value, but get all combinations of inputs. i want to get a two-dimensional array containing {{"foo", "bar", "baz", "zzz"} ,{"foo bar", "baz", "zzz"} ,{"foo", "bar-baz", "zzz"} ,{"foo bar-baz", "zzz"} ,{"foo", "bar", "baz-z...

fpdf Tables: Cell Splitting/Merging

I am trying to generate a pdf which contains a table with split/merged cells looking like so: Cell | Cell       | Cell Cell | C1 | C2 | Cell        | C1 | C2 | Cell I am using fpdf and was referred to the multicell table script, which I have used previously in similar pdfs. I looked at the code and can't think of a way to make the cell...

Linux command line: split a string

Hi, I have long file with the following list: /drivers/isdn/hardware/eicon/message.c//add_b1() /drivers/media/video/saa7134/saa7134-dvb.c//dvb_init() /sound/pci/ac97/ac97_codec.c//snd_ac97_mixer_build() /drivers/s390/char/tape_34xx.c//tape_34xx_unit_check() (PROBLEM)/drivers/video/sis/init301.c//SiS_GetCRT2Data301() /drivers/scsi/sg.c/...

Split Twitter RSS string using Python

Hi, I am trying to parse Twitter RSS feeds and put the information in a sqlite database, using Python. Here's an example: u'MiamiPete: today\'s "Last Call" is now up http://bit.ly/MGDzu #stocks #stockmarket #finance #money' What I want to do is create one column for the main content ("Miami Pete....now up)", one column for the URL ("ht...

How do I split a large file in unix repeatedly?

I have a situation with a failing LaCie 500GB hard drive. It stays on for only about 10 minutes, then becomes unusable. For those 10 minutes or so I do have complete control. I can't get my main mov file(160GB) transferred off that quickly, so I was thinking if I split it into small chunks, I could move them all off. I tried splitting t...

iTextSharp: SplitLate/SplitRows?

I have an issue where I have a table (PdfPTable) that may extend past the length of the page. I have tried looking up how to "split" a table onto more than one page but iTextSharp is pretty poorly documented in this area. Does anyone know how to do this without choosing an arbitrary Y position on the page and telling it to split if it's ...

split a file into segments?

I have a file containing text data which are separated by semicolon ";". I want to separate the data , in other words split where ; occurs and write the data to an output file. Is there any way to do with bash script? ...

Fixed Panel Height in a SplitContainer

I have a WinForm containing a bindingNavigator at the top and a splitContainer with two horisontal panels below it. The splitContainer fills the space not occupied by the bindingNavigator. I would like to set the bottom panel to a fixed height of, say 100 pixels, and have the top panel fill the rest of the space. This is my current cod...

Too many split screens opening in Emacs!

Ever since I installed emacs on a new machine I have seen an ugly behaviour. Unfortunately, my old .emacs files are rather fragmented and I can't determine whether I used to have elisp that took care of this. The problem is this: it used to be that when I performed a command that would open a new buffer such as grep'ing, or clicking a f...

Merge two Audio files in android

Hi Everyone, I am developing an application in which i need to merge and split audio recording. Can anyone give me a hint how to get it done in android? Does it require any external jar? Please help ...

Date Range Intersection Splitting in SQL

I have a SQL Server 2005 database which contains a table called Memberships. The table schema is: PersonID int, Surname nvarchar(30), FirstName nvarchar(30), Description nvarchar(100), StartDate datetime, EndDate datetime I'm currently working on a grid feature which shows a break-down of memberships by person. One of the requirem...

split <b>'s in php

For this code i need to take a string like <b>hey</b> more text<b>hey2</b> other text and i expect the returned array to look like <b>hey</b> more text <b>hey2</b> other text However it doesnt. How do i make it look like the above? my test code is $myArr = split("<b>", "<b>hey</b> more text<b>hey2</b> other text"); foreach($myArr ...

Splitting a string with curly braces as delimeters?

'{5}<blah>{0}</blah>' i want to turn that into: ['{5}', '<blah>', '{0}', '</blah>'] i currently use: ________.split(/({.*?})/); but this fails when curly brace is the first character as in the case: '{0}<blah>' which gets turned into: ['', '{0}', '<blah>'] ... a 3 element array, not a 2 what's wrong with my regex? Thanks! ...