MichaelRSnow
Active Member
- Joined
- Aug 3, 2010
- Messages
- 409
Hi all, I've googled this but can't find a simple solution to the problem
I'm trying to convert a string that looks like this
X = 7/7/7/7/7/6/5/4/3/2 to X = 607001260012500124001230012200
Simple logic, each step between / is a 12 month step and value is a percentage, where the values are the same combine the months to the one value
5 x 7 would be 5 x 12 = 60, 7 is 7 percent so 700 (without the decimal place)
1 x 6 would be 1 x 12 = 12, 6 is 6 percent so 600 (without the decimal place)
I've see some split logic but struggle to find a way to merge the 5 steps of 7 in 1 step of 60700
Any assistance would be gratefully appreciated
I'm trying to convert a string that looks like this
X = 7/7/7/7/7/6/5/4/3/2 to X = 607001260012500124001230012200
Simple logic, each step between / is a 12 month step and value is a percentage, where the values are the same combine the months to the one value
5 x 7 would be 5 x 12 = 60, 7 is 7 percent so 700 (without the decimal place)
1 x 6 would be 1 x 12 = 12, 6 is 6 percent so 600 (without the decimal place)
I've see some split logic but struggle to find a way to merge the 5 steps of 7 in 1 step of 60700
Any assistance would be gratefully appreciated