i have one column with data smith john michale the o/p should be smith,john,michale how we do in unix
6 10850Post New Wipro Unix General Interview Questions
Define "book value" as applied to accounting
List out the @functions?
What is the benefit of hibernate tools eclipse plugin?
Is arraylist better than array?
Explain bit masking in c?
How to remove the trailing spaces from a string?
How do you taskkill a program?
What is gcd in ios?
Why do we convert frequency domain to laplace domain?
Explain deep copy?
What is expression blend?
Why do we apply both Differential and REF (HV and LV) protection schemes on YNyn configuration of a transformer?
What are ansible vaults and why are they used?
What are the features of the new spring build system in use now days?
Sub link() Dim k As Integer Dim rand As Integer Dim URL As String Dim foldernum As Integer Dim folderstring As String Dim filenum As Integer Dim filestring As String k = 1 'for AC Numbers For i = 11 To 40 foldernum = 0 foldernum = 1000 + i folderstring = CStr(foldernum) folderstring = Mid(folderstring, 2, 3) folder = "ac" & folderstring 'folderstring = Sheets(2).Cells(i, 1) ' for Number of Random files For j = 1 To 10 rand = Int(Rnd * (200 - 1) + 1) filenum = 0 filenum = 1000 + rand filestring = CStr(filenum) filestring = Mid(filestring, 2, 3) 'URL = "http://ceobihar.nic.in/PSCDROM/ac" & folderstring & "/i" & folderstring & "0" & filestring & ".pdf" URL = "http://www.elections.tn.gov.in/pdfs/dt1/" & folder & "/" & folder & filestring & ".pdf" ' URL =http://www.wb.nic.in/wbeco/EROLLS/PDF/English/A001/a0010105 .pdf Cells(k, 1) = folderstring Cells(k, 2) = folder Cells(k, 3) = filestring Cells(k, 3) = URL k = k + 1 Next j Next i End Sub plz define it