Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
2
votes
2 answers

Merge tab delimited text files into a single file

What is the easiest method for joining/merging all files in a folder (tab delimited) into a single file? They all share a unique column (primary key). Actually, I only need to combine a certain column and link on this primary key, so the output file…
Bill D
  • 143
  • 3
  • 11
2
votes
1 answer

How to automate export of multiple tables to delimited text in SSIS?

I am trying to create some sort of automation whereby I can generate a series of pipe-delimited text extracts for about 100 different tables each month. Each extract would be based on a simple query like this: SELECT * FROM tablename WHERE AsOfDate…
RMQ1447
  • 21
  • 1
2
votes
1 answer

Oracle - How to write Query to return column header name with pipe delimited?

I want a Query to return the header name with pipe delimited. I found some reference online but couldn't get exactly what I want. I want something return like this, not need to output for a file, just a query…
azCats
  • 153
  • 13
2
votes
3 answers

Excel 2010 VBA - Split String by Comma, Skip Blank Results

I am using the following code to chop up a column of comma-separated lists and to return each entry in a new row: Sub SliceNDice() ' ' Splits the locations cells according to commas and pushes to new rows ' Code courtesy of brettdj…
Anders Kilmark
  • 35
  • 4
2
votes
4 answers

Split strings by different delimiting character sequences

I have the following strings, that comes with the format country: Cum name, Extra info. Asia: Asian Cup - Play Offs Asia: Asian Cup Asia: World Cup - Qualification - First Stage Australia: A-League Belgium: Jupiler League - Championship…
KodeFor.Me
  • 13,069
  • 27
  • 98
  • 166
2
votes
2 answers

Parsing large delimited files with dynamic number of columns

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 :…
annelie
  • 2,569
  • 6
  • 25
  • 39
2
votes
2 answers

Get a comma separated list of first cell values for rows with classname (using Jquery)?

Trying to grab ids from the table below when a row is selected. For example, the jquery should return: "12,14"..My code below returns empty string? My html: …
Chaka
  • 1,709
  • 11
  • 33
  • 58
2
votes
2 answers

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…
KPexEA
  • 16,560
  • 16
  • 61
  • 78
2
votes
5 answers

Get the last N words in a string

I am trying to get the last few words in a string. For the last word, I am using this: $string = "Hallo dies ist ein extrem langer Text den ich gern gekuerz haette, leider bin ich selbst zu doof dafür und mach hier einen test."; $pattern =…
hamburger
  • 1,339
  • 4
  • 20
  • 41
2
votes
1 answer

MySQL includes comma on a Tab delimited file (LOAD DATA INFILE)

Here is a peculiar scenario: I am trying to import a tab-delimited file into MySQL which has some rows with prices above 1,000. When I finish the import, the values after the comma are excluded and I end up with just 1 in my table. Tried in both…
user1715559
  • 79
  • 2
  • 9
1
vote
1 answer

Oracle PL-SQL : Import multiple delimited files into table

I have multiple files (f1.log, f2.log, f3.log etc) Each file has the data in ; & = delimited format. (new lines are delimited by ; and fields are delimited by =) e.g. data of f1: 1=a;2=b;3=c data of f2: 1=p;2=q;3=r I need to read all these files…
user613114
  • 2,731
  • 11
  • 47
  • 73
1
vote
2 answers

Tkinter GUI to Convert Fixed Width File to Delimited File

I am writing a converter code for our Data Department to convert fixed width files into delmited files. Normally we use import the file into Excel, use the text import wizard to set the field lengths, and then just save as a csv. However we have run…
Ryan McDevitt
  • 73
  • 1
  • 11
1
vote
2 answers

Extract nth element from comma-delimited list with Google Sheets formula

I have a string: "apple12,bear23,chile,dormir45,elephant" I'd like to use the regexextract() formula to get the nth element from this list, where n is going to be a row() in an arrayformula. I just need the regex where I can input a number {1},…
Aleister Tanek Javas Mraz
  • 452
  • 2
  • 8
  • 26
1
vote
3 answers

Split qualifying colon-space separated strings in an array to form a new associative array

I have an array named $stat that looks like this: Array ( [0] => OK MPD 0.23.5 [1] => repeat: 0 [2] => random: 0 [3] => single: 0 [4] => consume: 1 [5] => partition: default [6] => playlist: 11292 [7] =>…
Tony
  • 687
  • 1
  • 6
  • 15
1
vote
1 answer

Remove sequential duplicates using regex (pipe delimited)

I have a pipe delimited list of phrases. I would like to remove sequential duplicates using a regex replace/substitution. For example: dog|cat|cat woman|cat woman|dog|dog cat|cat|catman|catman|catman|cat woman|cat woman|dog|dogman|doggy would be…
hwm.nem
  • 11
  • 1
1 2 3
…
14 15
ID