Replace Pioneer Home All Examples Free Download

981.Text merge -- How to put a list of names in different rows into one line?

User: Fiona -- 2012-07-29 << 980 982 >>

Hits: 3592

Type: Text merge

Search all Text merge examples

Description:

I need to put a list of names (one in a row) in an excel sheet in one line up row, divided by a "/" for data processing. How can I do this?

Input Sample:

name1
name2
name3
name4
etc

Output Sample:

name1/name2/name3/name4/

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. copy the names from excel and paste into "replace pioneer" edit window, or:
save the excel to a text file such as a.csv, then open "replace pioneer", and ctrl-o open a.csv
2. ctrl-h open 'replace' dialogue
* set 'search for pattern' to:

* set 'replace with pattern' to:

3. click 'replace', done.
4. ctrl-c copy text or ctrl-s save to a new file

Screenshot 1: Replace_Window

Similar Examples:

How to put the file list of a directory into a text file? (66%)
How to count and sort the occurrance of different lines? (63%)
How to merge two or more csv files with different columns into one file? (63%)
How to join hundreds of columns in different files into one csv file? (62%)
How to extract specified lines in different section of text file? (59%)
How to split a text file to different files according to first word in each line? (59%)
How to move a list of files that in different folders to a common folder? (59%)
How to split a text file to different files according to first word in each line? (59%)

Check Demo of Text merge

Keywords:

divide replace pioneer edit window div excel copy text text merge merge merg process mer merge line by line replace pioneer merge text list into excel row excel put list in one line merge excel paste an excel list into one line pioneer replace merge line replace pioneer excel save as excel