Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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

User: Fiona -- 2012-07-29          << 980  982 >>
Hits: 1720
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