Guidence on Loops

[sara1989]

Hi all i have the below code

Please Login or Register  to view this content.

I AM WONDERING

How many times does the loop body execute when word is "Mr X"?
What value is returned by the method hideWord when word is
"Mr X"?

Looking for guidance on this for part of my coursework
Not sure how i work this out?
Thanks

[TMS]

How many times do you think it will go through the loop?

It's not our policy to do homework questions for people, but we can help you through the process of understanding how it works.

What programming language is that? It's not VBA ... hence not part of Excel.

Regards, TMS

[sara1989]

I thought it was vba. Sorry my guess is 4. As their is 4 characters in mr x? But im unsure how to work out if im on the right lines.. If you cam help I would appriciate it

[TMS]

No, it's not VBA. No idea what it is; maybe a pseudo language for discussion purposes ... or it may just be a language I've never seen (and there are a lot). You should ask your tutor.

My guess would be four too. There are four characters in "Mr X", so it will loop through four times ... From 1 To word.Length.

And it will replace the blank character with "|" and the other characters with "*". So, what would the result string be?

VBA does not use Set for text string handling, and it does not use "+" to concatenate, it uses "&".


Regards, TMS

[sara1989]

Thanks tms - So my guess of 4 should be correct ? what value is returned by the method Hideword when the word is also Mr x ? could this be 0 ?

[TMS]

could this be 0 ?

Why 0? What do you think the loop is doing? Read the third paragraph of my last post again.

Regards, TMS

[sara1989]

Ok 3? ?
I thought this would be 0 as the word has changed to hideword?
Im confused ?

[TMS]

No, you're replacing characters with other characters. So, look at what characters you are starting with, what you change each one to, and then see what you get.

Clue: you're going to end up with a four character text string. What is it?