Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1274.Text data calculation -- How to decrease the first 4 digits in the beginning of each line by 1000?

User: tinghar -- 2014-12-16          << 1273  1275 >>
Hits: 1411
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