delimited

Any problems with SVN merge on a multi column ( tab delimited ) text file?

I have a multi-column text file ( tab delimited ) that I use for localized text in my project. I picked this format since it can easily be edited by anyone in most text editors (and excel too). My makefile processes it into a bunch of defines and binary data for including directly into my app. Do you know if SVN merge only does lin...

Dynamic SQL Comma-Delimited Value Query

[Update: Using SQL Server 2005] Hi, what I want to do is query my stored procedure with a comma-delimited list of values (ids) to retrieve rows of data. The problem I am receiving is a conversion error: Conversion failed when converting the varchar value ' + @PassedInIDs + ' to data type int. The statement in my where-clause and e...

rijndael encryption

does this encryption library use pipe characters? I'm storing the key in an array with the corresponding UserID value, and delimiting them with a pipe character. If the library generates keys with pipe characters, those keys will get mangled when I split the string later. ...

Ways to read only select columns from a file into R? (A happy medium between `read.table` and `scan`?)

I have some very big delimited data files and I want to process only certain columns in R without taking the time and memory to create a data.frame for the whole file. The only options I know of are read.table which is very wasteful when I only want a couple of columns or scan which seems too low level for what I want. Is there a bette...

retrieve comma delimited data from a field in using SQL

I've created a form in PHP that collects basic information. I have a list box that allows multiple items selected (i.e. housing, rent, food, water). If multiple items are selected they are stored in a field called Needs separated by a comma. I have created a report ordered by the persons needs. The people who only have one need are...

How do I handle Column Headers in a Delimited Oracle Report

I am back in the Oracle 10g world and I need some help. I have created a dynamic Oracle report calling from an Oracle Form that will output a tab delimited file, but I am having problems with the orientation of the column headers. SET_REPORT_OBJECT_PROPERTY(RO_Report_ID, REPORT_DESFORMAT, 'DELIMITED') I have no problem with the functi...

Parsing large delimited files with dynamic number of columns

Hi, What would be the best approach to parse a delimited file when the columns are unknown before parsing the file? The file format is Rightmove v3 (.blm), the structure looks like this: #HEADER# Version : 3 EOF : '^' EOR : '~' #DEFINITION# AGENT_REF^ADDRESS_1^POSTCODE1^MEDIA_IMAGE_00~ // can be any number of columns #DATA# agent1^the...

Send comma delimited CSV through SFTP?

I am collecting registration information on my site and need to figure out how to pass all data stored in the MySQL DB (or just portions of it) as a CSV file through an SFTP so our partners can access the information. The pages are built using PHP. I literally have no idea how to do this and am hoping somebody has experience doing so. ...

Linq query with subquery as comma-separated values

In my application, a company can have many employees and each employee may have have multiple email addresses. The database schema relates the tables like this: Company -> CompanyEmployeeXref -> Employee -> EmployeeAddressXref -> Email I am using Entity Framework and I want to create a LINQ query that returns the name of the company...

From a one to many SQL dataset Can I return a comma delimited list in SSRS?

I am returning a SQL dataset in SSRS (Microsoft SQL Server Reporting Services) with a one to many relationship like this: ID REV Event 6117 B FTG-06a 6117 B FTG-06a PMT 6117 B GTI-04b 6124 A GBI-40 6124 A GTI-04b 6124 A GTD-04c 6136 M GBI-40 6141 C GBI-40 I would like to display it as a comma d...

multi-array search query with delimited field

I have a array which store some country names im doing a search module and i wanna to find the db records whether contain the country names or not but since db design problem , those record can own mutil counties and store the countries by delimiter "|" below is a example input: array("Cyprus","Austria") // note that the max input ...

Limiting Keywords with jQuery by counting commas?

I'm using a CMS to allow users to add keywords to their profiles, but I'm wanting to limit that to 10 keywords, which are comma delimited, by counting the number of commas (in this case, 9). Any ideas on how to go about doing this with jQuery? I'll be doing a double-check on the server-side, but I'd like a quick little, live error check...

Checking if 1 item or more in a delimited string exist in another

Hi all, Which is the best way to check if 1 item or more of one delimited string exist in another? I'd like to pass 2 delimited strings to a UDF and get back TRUE if at least one item of the first delimited string exists in the second delimited string. delStr1="US,FR,DE" delStr2="GB,DE,CA,IT,PL" delStr3="CN,DK" CheckDelimitedStrin...