Thanks Vamsi it worked. On Friday, August 5, 2016 at 12:17:24 PM UTC+5:30, vamsi wrote: > > HI Pradeep, > Below code for separating upper and lower cases using ASCII. > > str = "Hi How Are You" > > For i = 1 To len(str) > ch = mid(str,i,1) > If asc(ch)>=65 and asc(ch)<=90 Then > ucaseletters = ucaseletters&ch > ElseIf asc(ch)>=97 and asc(ch)<=122 Then > lcaseletters = lcaseletters&ch > End If > Next > Msgbox ucaseletters > Msgbox lcaseletters > > Thanks, > Vamsi. > > On Thu, Aug 4, 2016 at 9:58 PM, pradeep <[email protected] > <javascript:>> wrote: > >> VB Script to separate upper & small Letters from a string and >> >> store in excel >> >> -- >> -- >> You received this message because you are subscribed to the Google >> "QTP - HP Quick Test Professional - Automated Software Testing" >> group. >> To post to this group, send email to [email protected] >> <javascript:> >> To unsubscribe from this group, send email to >> [email protected] <javascript:> >> For more options, visit this group at >> http://groups.google.com/group/MercuryQTP?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "QTP - HP Quick Test Professional - Automated Software Testing" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en --- You received this message because you are subscribed to the Google Groups "QTP - HP Quick Test Professional - Automated Software Testing" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
