Forum Discussion

Shree2280's avatar
Shree2280
Brass Contributor
Jan 27, 2021

extract http data

Hi expert, I am trying to extract http:// URL from given file but getting empty file in export here is the code $items = Get-ChildItem -LiteralPath "E:\Backup_Testinstance\" |          Where-Obje...
extract data
farismalaeb's avatar
farismalaeb
Steel Contributor
Jan 27, 2021

Shree2280 

OK, would you please post a sample of the text file you are reading from.

and also explain a bit more on how the result should look like

Just to give you a small hint, what you need to do is using Regex, but I will wait for your reply to confirm.

 

Shree2280's avatar
Shree2280
Brass Contributor
Jan 27, 2021

farismalaeb 

 

http://hdfcebank.com/jhgsfgdsf ;kkjhadsf;kjnsdf ;kkjhadsf;kjnsdf ;kkjhadsf;kjnsdf ;kkjhadsf;kjnsdf
http://hdfcebank.com/jhgsfgdsf ;kkjhadsf;kjnsdf ;kkjhadsf;kjnsdf ;kkjhadsf;kjnsdf ;kkjhadsf;kjnsdf ;kkjhadsf;kjnsdf
http://cart.com/jhgsfgdsf ;kkjhadsf;kjnsdf ;kkjhadsf;kjnsdf
http://hdfcebank.com/jhgsfgdsf kuhsdfkhdsf
http://hdfcebank.com/jhgsfgdsf uhsfdhkjlsfd
lksdfsdkndsf
;lnskfdkjnsdf
hblshdfkjhdfs

  • Shree2280's avatar
    Shree2280
    Brass Contributor
    Jan 27, 2021

    Shree2280 

     

     

    i run it on windows server power shell now it is showing empty file

      • farismalaeb's avatar
        farismalaeb
        Steel Contributor
        Jan 27, 2021

        Shree2280 

        I had created a file and add the sample you provide

        and using this code, was able to get the result with only http://websitename without spaces

        $items=(($x=Get-Content -Path C:\test.txt).split(";") | where {$_ -like "http://*"})

foreach ($item in $items){
($item.split(" "))[0]
   
    }