| User: tinghar -- 2014-12-16 << 1273 1275 >> |
| Hits: 3082 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| replace all the stock market EOD data,only replace the year ,by counting 1000 years back from the year of the date given, example: 2014 convert to 1014, 2013 to 1013.....2002 to 1002, 2000 to 1000,1997 to 0997, 1998 to 0998, the year format is at the beginning of each lines as example below, |
| Input Sample: |
| 19970702,1255.91,1261.57,1147.33,1199.06,0,0 19970703,1194.68,1194.68,1149.94,1150.62,0,0 |
| Output Sample: |
| 09970702,1255.91,1261.57,1147.33,1199.06,0,0 09970703,1194.68,1194.68,1149.94,1150.62,0,0 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 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: or * set 'replace with pattern' to: 3. click 'replace', done. 4. ctrl-s save to file. |
Screenshot 1: Replace_Window |
Similar Examples: |
| How to add different words at the beginning of each line? (63%) How to delete all blank/space at the beginning of each line? (63%) How to change multiple files, adding filename at the beginning of each file? (62%) How to batch insert filename at start/beginning of each lines? (61%) How to add a line number at the beginning of each line? (61%) How to move a string from the beginning of the line to the end of the line? (60%) How to move a string from the end of the line to the beginning of the line? (60%) How to replace the first 3 spaces into comma in each line of text? (60%) |
Check Demo of Text data calculation |
| Keywords: |
| 101 year digits given mark give 200 toc stock dec replace all digits search for digits lines below convert date text convert date to search replace convert date convert date date convert |