Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

285.Advanced search and replace -- How to re-organize excel data with complicate date format?

User: Lan -- 2008-10-24          << 284  286 >>
Hits: 1857
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
I have a excel file with daily values of 20years, source format and target format are listed below, can you tell me how to use Replace Pioneer to get the target format? Thanks very much!
Input Sample:
M\D 1 2 3 4 5 6 7 8 9 10 11...
Jan X X X X X X X X X  X  X...
Feb X X X X X X X X X  X  X...
Mar X X X X X X X X X  X  X...
...
Output Sample:
Date
01/Jan X
02/Jan X
03/Jan X
04/Jan X
.....
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
I am not quite sure your question, let me simplize it:
===================
Source:
Jan a b c d e
Feb a1 b1 c1 d1 e1
Mar a2 b2 c2 d2 e2 f2
===================
Target:
1/Jan a
2/Jan b
3/Jan c
4/Jan d
5/Jan e
1/Feb a1
2/Feb b1
3/Feb c1
4/Feb d1
5/Feb e1
1/Mar a2
2/Mar b2
3/Mar c2
4/Mar d2
5/Mar e2
6/Mar f2

Procedure to make it happen:
1. copy your excel rows and paste to "Replace Pioneer" edit window like format:
Jan a b c d e
Feb a1 b1 c1 d1 e1
2. ctrl-o to open replace dialog
* set Replace Unit to 'Line'
* set Replace with pattern to: 
click "Advanced" window:
* set "Run Following to each matched unit" to:

3. click "Replace" button, and paste result back to Excel.

Note: the above 3 lines code is to convert each line to your format.
Download Script:  scripts/285.rst.zip

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to change each line of data to the specified format? (60%)
How to re-organize following text and generate a new format dictionary? (58%)
How to format all the data in the text file with 8.2 format? (57%)
How to merge the data of second column base on value of first column? (52%)
How to remove the xml tag and some duplicated tags of combined xml files? (51%)
How to reorganize following ":" delimited data into columns? (50%)
How to replace all duplicate lines with some text? (49%)
How to remove/delete consecutive duplicate lines in a text file? (48%)

Check Demo of Advanced search and replace
Keywords:
abcd  asp  year  replace pioneer edit window  question  excel  tel  comp  abc  date format  convert excel  how to convert daily data  copy paste  copy lines  copy line to lines  lines below  convert date to search  replace convert date