Concatenating strings from multiple rows into a file separated by new rows

If I have a file with multiple lines like:

name1
12345
67890

name2
23456
78901

name3
34567
89012

How would I go about concatenating each line in the form:

"name1 1234567890"

"name2 2345678901"

"name3 3456789012"

Specifically, what is the best way to concatenate strings from a file into a single line until an empty line is encountered?

You can split first with \n\n and then split \n to get each item.

data = open('file_name').read()

output = ["%s %s%s" % tuple(item.split('\n')) for item in data.split('\n\n')]

['name1 1234567890', 'name2 2345678901', 'name3 3456789012']

Is it possible to concatenate strings from multiple rows and tables in a result column?

I am trying to write a MySQL query that retrieves one record from table "projects" that has a one-to-many relationship with table "tags". My application uses 4 tables to do this: Projects - the projects table Entities - entity table; r

Create a comma separated string from multiple rows of a column?

I've an access table like this ID | UserName | CarBrand ------------------------- 0 Peter VW 1 Peter Ferrari 2 Mike Audi 3 Peter Dodge 4 Heidi BMW 5 Heidi Ford I need the names from the CarBrand field as a comma separated list for a report. Is there

to delete a line with a duplicate string from multiple lines of a file

I have a file with many such lines containing paths of some files. ../../ds1_src/wrapper/memory/beh/mem_1w1r_8x160.v ../../ds1_src/wrapper/memory/beh/mem_1w1r_8x134.v ../../ds1_src/wrapper/memory/beh/mem_1w1r_8x178.v ../../ds1_src/wrapper/memory/beh/

to copy multiple files from multiple directories into a single directory using MATLAB

How can I manage to copy the files from multiple directories into one target directory IN MATLAB for example if the directories are organized as follow: directory1 sub-directory1 sub-sub-directory1-1 file1 file2 sub-sub-directory1-2 file4 thisis-my-f

How to merge data from multiple rows into a single column in a new table?

How do I merge data from multiple rows in one table to a single column in a new table? create table new_paragraphs ( id NUMBER paragraph CLOB ); create table old_paragraphs ( id paragraph CLOB ); merge into new_paragraphs a using (select * from old_p

SQL Query to concatenate column values from multiple rows in Oracle

Would it be possible to construct SQL to concatenate column values from multiple rows? The following is an example: Table A PID A B C Table B PID SEQ Desc A 1 Have A 2 a nice A 3 day. B 1 Nice Work. C 1 Yes C 2 we can C 3 do C 4 this work! Output of

copy the same line from multiple sheets into a single sheet in Excel

I need to copy the same row from multiple sheets into one row. Example: I have an excel file with 5 sheets. I have to copy the 10th row (or the 15th row, or the 21th row) of every sheet in a 6th sheet, in the order of the sheets. Thanks in advance.Th

how to delete single records from multiple row records like gridview in the jsp page

I am trying to edit and delete a single record from multiple records.Here below is my sample record displaying on jsp page, I can edit the record for each row easily using below code, <%@ page language="java" contentType="text/html; char

Creating a query string from multiple check boxes

I'm trying to form a query string from multiple checkboxes that will be used to query my database. I have the following form: <fieldset data-role="controlgroup"> <input type="checkbox" name="wheat" id="checkbox-

Cut common strings from multiple files and paste them into another file

So lets say I have 5 files: f1, f2, f3, f4, f5. How can I remove the common strings (same text in all files) from all 5 files and put them into a 6th file, f6? Please let me know. Format of the files: property.a.p1=some string property.b.p2=some stri

Effective method of concatenating multiple strings from multiple records bound to single strings per record string

I have a table which contains records relating to absence details for an employee; when an absence is updated, instead of the existing row being updated; instead a new row is created and the LinkedRecordId field of the previous record is populated wi

Batch file to extract a string from multiple text files

I have over a hundred text files formatted like this <TITLE> This is the title <SUBJECT> This is the subject <XTITLE> I want to extract the title values using a Windows batch file, e.g. "This is the title" from each of these te

Excel VBA to concatenate data from multiple rows into 1 row

Possible Duplicate: Excel Concatenate Rows I want to merge several rows of data into a single row with an Excel VBA macro, and for the output to be on a new worksheet, but I don't know where to start. The data is fairly simple, and consists of a colu

.bat removes strings from multiple .txt files

I have 10 text files in the same folder with lists like the following: abc0012345 abc0012346 abc0012347 abc0012348 abc0012349 abc0012350 abc0012351 abc0012352 I have a remove.txt file containing the strings I want to remove, it contains abc0012347 an

Related Articles