• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data formating - Macros

sampath

Member
Dear Friend,


I need to convert the huge data from following format.

[pre]
Code:
INPUT
A              B               C.........
1        S1             S2              S3
2        105            262             MA
3        266            107             1088
4        R262 1088      262             107
5        MAS            1062 MA         R262
6        105 MBB        756             1088 1925
7                       2065            R265 MAS

Required OUTPUT
A        B
1         S1       105-266-1088-MAS-MBB-R262
2         S2       107-262-756-1062-2065-MA
3         S3       107-1088-1925-MA-MAS-R265
[/pre]

Please anyone help me to convert from above mentioned data as macros.


Regards,

Sampath.S
 
Sampath


Please note that nothing is Urgent here and marking posts as such will not mean you get any faster help than anyone else.


Please read: http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


Explaining the relationship between the data as displayed before and after will ensure you get a faster more accurate response!
 
Hi Sampath ,


I think for S3 , the output should be :


107-1088-1925-MA-MAS-R262-R265


unless the R262 is a mistake , and should actually read R265.


Narayan
 
Hi NARAYAN,


Thanks for your response, sorry, That one is typo error, your statment is right(R265).


Please help me do make that format. we have huge data such kind of inputs.


Sampath
 
Hi Narayan,


Your given document is working fine. Thanks for your support for our project.


I really excited. Thanks once again.


Regards,

Sampath.S
 
Back
Top