Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
0
votes
1 answer

Storing Game Player Progress ID's in database - Comma-delimited data in MySQL vs Normalized MySQL Records (regarding server performance)

I'm developing an online game which will save the player's progress to a MySQL database, and i'm trying to optimize for performance. This data would be in the form of an ID which corresponds to a specific progress achievement. These 'achievements'…
MetalEdd
  • 5
  • 2
0
votes
1 answer

Importing Tab delimited file to Access. Getting error if I save an import specification

I have the following tab delimited file: And this Access table: When I go through the "Get External Data - Text File" procedure, everything works. But, when I go through the same procedure with the added step of saving a specification file…
skihansen
  • 83
  • 1
  • 2
  • 8
0
votes
2 answers

Open a .txt file in Excel from VB.NET

How can I open a tab delimited .txt file in Excel from VB.NET code? This question has been asked on many forums, but I can not find an answer anywhere that actually solves this problem. Dim fileName As String = "file.txt" Dim filePath As String =…
Bernoulli Lizard
  • 537
  • 1
  • 12
  • 23
0
votes
3 answers

Convert array of comma-separated strings to a flat array of individual values

I need to change an array of comma-delimited integers into an array of individual numbers. Sample input: [ '1,24,5', '4', '88, 12, 19, 6' ] Desired result: Array ( [0] => 1 [1] => 24 [2] => 5 [3] => 4 [4] => 88 [5] =>…
user2440987
  • 19
  • 3
0
votes
1 answer

Losing Columns when Replacing NULL values in Tab Delimited File - Coldfusion

I have a Tab Delimited Text file that contains the dreaded "NULL" value. And after some searching I found how to replace the Empty string... with "something". But when I do this I seem to be losing Half of my values.
Big Fat Designs
  • 51
  • 5
0
votes
1 answer

How to obtain max length of fields in huge pipe delimited file

I have a pipe delimited file that is too large to open in Excel. I'm trying to import this file into MSSQL using the import wizard in SSMS. Normally when I do this, I open the file in Excel and use an array function =MAX(LEN(An:Annnn)) to get…
user1038638
  • 85
  • 1
  • 5
0
votes
2 answers

Converting space delimited text file to CSV VB.NET

I have a hundreds of space delimited text files that I would like to convert in VB.NET to CSV-files according to RFC 4180. The files have variying length but can contain upp to 200000 rows and have varying ammount of columns (up to 30) separated by…
user2404987
  • 11
  • 1
  • 4
0
votes
1 answer

parsing specific data from .txt file to excel or something else

I have extracted data from one source to .txt file. Source is some sort of address book and I used macro recorder for extraction. Now I have several files which are formated exactly in next way (example on 4 contacts): Abbrucharbeiten ATR…
dzordz
  • 2,277
  • 13
  • 51
  • 74
0
votes
3 answers

Sending delimited from textarea to mysql. Column by "," and row by "\n"

I need a user to be able to enter data into a textarea in the following format. name,email@email.com name,email@email.com name,email@email.com The information would then be sent to the mysql database. My issue is that I want to place the proper name…
sethcarlton
  • 71
  • 1
  • 6
0
votes
1 answer

Parsing delimited string from a file

I am trying to parse specific information from text files. I would like to be able to take the following text: &15:44:25.3911456_0089& SIPEngine 0x208c N SIPUDPTransport::process_message() : remote=10.250.2.18:5060, message= To:…
Lincoln Rose
  • 1
0
votes
1 answer

take a tab delimited file and update a MySQL field based on matching rows to a unique field

Trying to piece together fgetcsv questions and answers to get where I need to be but do not grasp the basics enough to get the result I need. The Tab delimited file sample.... ╔══════════════╦════════════╦═══════╦══════════╗ ║ sku ║ asin…
northofnowhere
  • 3
  • 3
0
votes
3 answers

Processing .txt files into arrays, and manipulating the array data

I figure I'd just post the whole program I'm working with. I've pretty much finished the Main method. I just need to create 3 classes. FileRoutines, Student, and Students. FileRoutine is the main problem I'm running into. It has 2 public classes.…
Adam Cole
  • 1
  • 1
0
votes
1 answer

How to parse a large dataset using python into a CSV file?

I have a large .dat file (3gigs) which contains values separated by space. Here's how the first first line looks like: S 201001 7 2 2 30105 …
user2019940
  • 11
  • 1
  • 3
0
votes
1 answer

Comma delimited string values from SQL Server to ListBox select

I have trawled the internet but I cannot find a solution to the following problem. I have a ListBox control that gets populated with a list of values from a SQL Server database table on FormLoad. This allows the user to select multiple values and…
Bob the Builder
  • 503
  • 1
  • 12
  • 33
0
votes
2 answers

add a new column of numbers to whitespace delimited data based on another column of numbers using Bash utilities

I want to perform a simple calculation on each number in a column of whitespace delimited data using Bash utilities such as cut and bc. The data may look like something such as the following: string 0.998663 string string string string 0.998592…
d3pd
  • 7,935
  • 24
  • 76
  • 127
1 2 3
…
14 15