Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1303.Advanced search and replace -- How to split a string (text + number) at the last number?

User: flash -- 2015-04-27          << 1302  1304 >>
Hits: 1116
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to split a string (text + number) at the last number?
Input Sample:
shi2 shi4 qiu2 shi4 be practical 
li4 suo3 neng2 ji2 in one's power 
bu4 hao3yi4si shy/ feel embarrassed 
Output Sample:
COLUMN A 
shi2 shi4 qiu2 shi4 
li4 suo3 neng2 ji2
bu4 hao3yi4

COLUMN B 
be practical 
in one's power 
shy/ feel embarrassed 
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
Following steps will add a comma after the last number in each line:
1. ctrl-o open text file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Chars'
* set 'replace scope' to 'Line'
* set 'search for pattern' to:

* set 'replace with pattern' to:

3. click 'replace', done
4. ctrl-s save to result.csv file, you can use excel to open the csv files with columns.

Screenshot 1:  Replace_Window


Similar Examples:
How to find missing numbers from a list of numbers? (66%)
How to split text file by number of bytes? (61%)
How to split each line of text into 2 lines with same number of characters? (57%)
How to change all negative numbers to the format of (number)? (57%)
How to replace strings and numbers with new format in multiple files? (55%)
How to calculate the percentage of the number in the column1? (54%)
How to split a large text file into specified various number of lines? (54%)
How to calculate the average of the numbers in the same column? (53%)

Check Demo of Advanced search and replace
Keywords:
after the last  excel  csv files  columns  comma  the last  after  last  csv  string  add comma after  replace last comma in a text file  excel text in string after last comma  split columns csv file  csv file split columns  split csv columns  replace comma in split  split columns to files