Shekhar: Copy the line into notepad and use Replace. If you have a lot of this, it could be automated but to me, it would not be fun.
hth,. Parke On Mon, Jun 23, 2014 at 7:00 AM, shekhar sharma <[email protected]> wrote: > Hi , > There is one string which is having double quotes as well in between. now, > i want to replace these double quotes with blank value or Null.String is > coming from a text file. > > strLine = "E|"C|"30020011|"1|"19000101|"99991231|"|"|"|" > > I have tried the below solutions but of no use. > > msgbox replace(strLine,Char(34),char(0)) > msgbox replace(strLine,Char(34),"") > msgbox replace(strLine,Char(34),Empty) > > But is gives 'Type Mismatch' Error. I checked and confirmed that these > double quotes are char(34) only to clear the doubt that if it is some other > char. > Please help if some one has any idea. > Thanks > > -- > -- > 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. > -- Parke Cell: 770-842-0121 -- -- 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.
