User: flash -- 2015-04-27 << 1302 1304 >> |
Hits: 2789 |
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 |