Questions tagged [delimited]

The tag has no usage guidance.

0
votes
2answers
36 views

Perl Combining first 2 lines of Pipe delimited file into one pipe delimited line

Trying to combine first 2 lines of a perl array as shown below: time |cpu |mem| stamp|util|util | to: time_stamp|cpu_util|mem_util| Using perl as this needs to work on both windows and linux
-1
votes
2answers
24 views

Delimited txt into an array with keys provided by first cell of delimieted txt [duplicate]

ID OID Title Description Option Price 01 01JAP Japanese Model Japanese Model of the Dave Smith Japanese "$3,000 " 02 02ENG English Model English Model of the dave Smith english "...
0
votes
1answer
25 views

sqlite3 is not using end-of-line character when importing data

I have a tab-delimited file which I'm attempting to load into a table. The table has already been created and structured appropriately, the challenge is that SQLite3 is combining the last value on ...
0
votes
2answers
41 views

MySQL - How to select rows in a table where id value is in a comma delimited field in another table?

I have been working on this problem for 3 days and am bleary eyed. I have an SQL "customers" table containing the customers name, address, email and a field called "venue" containing a comma delimited ...
-1
votes
1answer
33 views

Split string into set of sub-strings with given length, delimited by separator

Looking for best solution to create a number of sub-strings such that the length of each sub-string does not exceed the length value in parameter. It should converts spaces to specified separator(let'...
0
votes
1answer
45 views

TSQL Get Numbers as Range or Comma delimited

I'm trying to combine Numbers of Packagings, grouped on a Ordernumber. At the moment i combine this with STUFF as Comma delimited String. So i get now as example: 1-001, 1-002, 1-003 But if the ...
1
vote
0answers
22 views

Bulk Insert with text stream

After generating an SQL table using powershell with column names from the header of a delimited text file, I have successfully imported the tab-delimited file with some long fields into the SQL table ...
0
votes
2answers
40 views

SQL Server : using a query to generate a list of delimited numbers (with min/max threshold)

I did some searching here on this.. but it was either for PHP, Python or didnt relate. I understand this is somewhat of an odd use for a query.. I have an existing app. As a parameter to a section ...
0
votes
0answers
8 views

Saving SQL query results with different delimiter

When I save my SQL query results, the .csv file uses "," - comma delimited. I want to change it to semicolon. Under Tools > Options > Query Results > SQL Server > Results to Text I've changed the ...
0
votes
0answers
51 views

Parsing newline-delimited json in c# [duplicate]

I am making a game in Unity C# where request is made to external server every 10 seconds about the player's playing state. The server responses with newline-delimited JSON, for example. {"gamestate":...
0
votes
2answers
42 views

MS SQL + output query as delimited string

I'm not sure if I am not understanding the example found correctly.. or if I'm doing something else wrong here... but I am trying to get a my query results returned as: 1.) One long delimited string ...
0
votes
0answers
44 views

UNIX script to add column value to end of record

hi guys i have a tab delimited sample text file as below 6 12345 3405 02282018 4.0 8 12345 3405 02282018 1 4.0 4 44444 2211 11121111 12312 4 ...
1
vote
0answers
17 views

Using tab separation in linux/vim

I am having trouble with the cut command in linux. So say the original data looks something like this: 4567 Harrison Joel Accountant Mitchell Barbara Admin 3589 Olson Timothy Supervisor 4591 Moore ...
0
votes
1answer
27 views

Search field in Excel with delimited text

I am having a data in such format (DELIMITED TEXT) How do I Vlookup "F88" to get 1 dynamic value. Thanks a ton
0
votes
0answers
284 views

Adding a Cell Reference to a file name using a Macro

I am trying to save a file using VBA but the file name needs to reference a cell within the Workbook in which I am running the Macro from. I need to copy data from a tab within an Macro enabled ...
0
votes
1answer
59 views

Processing CSV data in Python: Wireshark CSV, comma/list issue

So I am trying to break this CSV data down a bit more, and grab a specific comma delimited piece of text. It is a wireshark CSV. import csv with open('wifi.csv', 'rt') as csvfile: reader = csv....
1
vote
0answers
284 views

Spark Csv specify new line character

I am writing a data frame using spark csv library. I am using spark 1.6. I was wondering if there is a way to specify the new line character. Usually, I think it is \n. Or if not, is there a good ...
-1
votes
2answers
91 views

mySQL >> Normalizing a comma-delimited field

I currently have a table called "RESOURCES" with a keywords field called "RES_Tags". The "RES_Tags" field contains a comma-delimited list of keywords for each record. I need to normalize this table/...
2
votes
2answers
63 views

Convert delimited string and value into hierarchical JSON with Python

I have data in the following format: [['Director', 9010], ['Director - Product Manager', 9894], ['Director - Product Manager - Project Manager', 9080], ['Director - Product Manager - Project Manager -...
0
votes
0answers
37 views

Import a text file into SQL Server with the size of fields limited and no delimiter [duplicate]

Is possible to import a text file into SQL Server with the size of fields limited and no delimiter?
0
votes
3answers
52 views

Converting multiple delimited fields into rows in SQL Server

I have a data source which contains data in delimited fields which exist in a staging area in SQL Server. I'd like to transform this data into many rows so it is easier to work with. This differs from ...
-2
votes
1answer
73 views

c# sort a tab delimited file

I have seen many subjects on sorting a tab delimited but have been unable to either grasp or comprehend the task to finish this piece of code plus I am just starting in C#. I hope someone can answer ...
1
vote
2answers
264 views

Delimited Semi-Colon Text in SQL with Accumulated Count

I have a table below Program FileCount B1 1 A1;B2 2 A2;B3 1 A3;C1;B4 1 A3;C2;D1;B5;B6 3 C3;D2;B7 1 B8;B9 2 B8;B9 2 ...
0
votes
1answer
98 views

Changing a comma delimited list into a paragraphed list in AppleScript

This is probably dead simple, but I am a total noob and have been searching for 2 hours to no avail. I need to change this type of list: 0001, 0002, 0003, etc into this: 0001 0002 ...
0
votes
0answers
508 views

Java OpenCSV Split by pipe limited

I am having an issue when reading from a file using comma split. I can read the file like this: CSVReader reader = new CSVReader(new FileReader(FileName), '|' , '"' , 0); Then when I want to get ...
1
vote
1answer
100 views

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 ...
0
votes
1answer
301 views

Count Number of instances of text in a text file - VB

I have a need to parse a large, delimited text file (28 million lines plus) and count the number of instances of a particular piece of text in the text file using VB 2015. The structure of the lines ...
0
votes
0answers
22 views

How to remove newline character pr line break within a column in a csv file?

Is there an easiest way to remove/replace line breaks in csv file? Many thanks!
0
votes
1answer
87 views

SliceNDice for 3 columns

I love brettdj's SliceNDice sub: Split comma separated entries to new rows I use it all the time. I have a situation now with three columns and for the life of me - I can't figure out how to change ...
0
votes
1answer
47 views

Specify Horizontal and Vertical Movement

I'm looking to be able to move through a pipe ("|") delimited text file, controlling both the row and column I read. I have previously achieved this in MS Access VBA and am currently starting to in ...
-1
votes
2answers
56 views

How do I convert data in this format to a table?

I have data that is in a big text file that looks like this: {"id": 111, "role": "manager", "name": "John doe"} with every "row" of info separated by swirly brackets. How do I get this to be a table ...
0
votes
1answer
27 views

Fixed Width File to 'Space' delimited in OS X

Need to convert Fixed Width File to 'space' delimited in OS X. However, I need the delimiter to be any amount of spaces that are greater than one. Principal Position Year Salary ...
0
votes
2answers
37 views

How to parse a delimited column of a CSV file and make them be part of CSV file by Python

I have a CSV file with the following format/content and would like to see an easier way to further parse the col3 content (delimited) to include them to CSV file by using python. I'm new to this and ...
0
votes
2answers
53 views

Read Nested XML in C# with no XSLT file

I have an XML file with 3-4 levels deep of nested children. Some of the children have either a missing element or an extra element. I am struggling with automating reading the xml x children deep ...
1
vote
2answers
38 views

R map delimited integers to delimited strings

Input I have the following dataframe (with headers expiry and fruit). And I have the follwing vector: index <- c("apple", "kiwi", "banana", "peach", "grape") Where apple = 1, kiwi = 2, banana = ...
2
votes
1answer
604 views

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, ...
0
votes
2answers
159 views

Powerbuilder-Remove last separator

Hi i'm using PB 12 and I have problems with SaveasFormattedText The funcion works well, but the separator char add one character at the end of each line and I need to delete the last separator. For ...
0
votes
1answer
755 views

Excel-VBA - Format data in Column to Delimited

Need help making Col D "Delimited" from cell D2 to the last cell in Col D that is not blank. I used the Record Macro to try to just steal the code but it does not seem to be working. Can anybody ...
1
vote
1answer
348 views

Splitting multiple delimited values into multiple rows [duplicate]

I have been looking for a solution in StackOverflow but didn't find anything useful. I am facing a issue and I hope anyone would like to help me out. I have value like this: Create table DemoRecords ...
1
vote
1answer
29 views

FileHelpers3 - recursive object

This object fills just fine [DelimitedRecord("|")] public class LvMenuItems { public string Sequence { get; set; } public string DisplayText { get; set; } public string MenuId { get; set; ...
3
votes
1answer
76 views

reading in rho delimited file

I'm trying to use Pandas to read in a delimited file. The separator is a greek character, lowercase rho (þ). I'm struggling to define the correct read_table parameters so that the resulting data ...
0
votes
2answers
119 views

How to separate space and semicolon in CSV files import to MS Access?

Here is my sample CSV file: 2000-01-10 19:59;0.000;m3/h;100.9;-0.0;100.9;m3;0.000;0.000;99;66 2000-01-10 20:14;0.000;m3/h;100.9;-0.0;100.9;m3;0.000;0.000;99;66 2000-01-10 20:29;0.000;m3/h;100.9;-0.0;...
-2
votes
2answers
134 views

populating a string vector with tab delimited text

I'm very new to C++. I'm trying to populate a vector with elements from a tab delimited file. What is the easiest way to do that? Thanks!
1
vote
2answers
694 views

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 ...
0
votes
2answers
213 views

Converting a delimited file into a Tree

I'm working on converting a delimited file into an ordered tree structure. Below is a sample input... 1.2.3.4.5 1.3.2.4.5 1.2.4.5.6 I need to be able to convert this into an output like the ...
-1
votes
1answer
106 views

Delimited file to SQL via SSIS

I am trying to upload data to a sql server database table from a delimited file via a SSIS package but its throwing error The value could not be converted because of a potential loss of data ...
0
votes
1answer
481 views

CSV to tab delimited java in command line

Updated Code. This program should take the CSV file and separate it into TSV files by school,but I am not getting it to work. I am getting it to create the files correctly, but only one has any data ...
1
vote
2answers
637 views

SAS import txt file using infile

I am looking at two procedures to import two txt files in SAS. The first file is fixed width. The second txt file is delimited file. The SAS code attached below: DATA filename; INFILE "...
1
vote
1answer
611 views

Reading non delimited text file into R

I have a large set of Data that is in an non delimited format that I am trying to import into R. The data set comes with a Column Locations file that includes a row number, the column name, and the ...
0
votes
1answer
501 views

mySQL LIKE Query on pipe

I'm trying to get a count for pics_india and pics_other in mysql using LIKE operator. I have a keywords piped (pics_india,pics_other,pics_other_france) i.e pics_other_france pics_other ...