Forum Discussion

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

Shree2280

Brass Contributor

Jan 27, 2021

farismalaeb

I tried this but getting http plus some records i do not want records after space

Get-ChildItem -Path C:\check\two -recurse | Select-String -Pattern "http://" | ` Select-Object -Property Path,LineNumber,Line | ` Export-CSV "C:\check\ResultFile.csv"

Shree

Shree2280

Brass Contributor

Jan 27, 2021

Shree2280

output coming with space

http://hdfcebank.com/jhgsfgdsf kuhsdfkhdsf

farismalaeb
Iron 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
  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
    Brass Contributor
    Jan 27, 2021
    Shree2280
    
    i run it on windows server power shell now it is showing empty file