Friday, 20 March 2015


'Remove the repetitive strings form a huge set of data in text file 


Set otext = createobject("scripting.filesystemobject")
set otxt= otext.OpenTextFile("C:\Users\psha64\Desktop\QTP_Algo\inactive.txt",1)
str = otxt.ReadAll
strarr = split(str," ")
strnum = ubound(strarr)
For i=0 to strnum-1
If not(instr(1,temp,strarr(i))>0Then
    temp = temp&" "&strarr(i)
End If
Next

msgbox temp    

No comments:

Post a Comment