locked
howto cut specific character or line RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    policy 1-TFS-DB-SQL\, schedule Default-Application-Backup,10/31/2019 02:57:31 - Info nbjm(pid=7116) requesting STANDARD_RESOURCE resources from RB for backupTFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.~.7.001of001.20191031025712..C,1,9136,MSDP-POOL-STU,access-bkp.accessonline.com,1572472651,0000000337,1572472988,0,the requested operation was successfully completed,TFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.~.7.001of001.20191031025712..C,1,9136,MSDP-POOL-STU,access-bkp.accessonline.com,1572472651,0000000337,1572472988,0,the requested operation was successfully completed,

    We only want to pick TFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.a from above paragraph

    Any comment will be appreciated. Thanks. Zahid Haseeb.


    • Edited by ZahidHaseeb Friday, November 1, 2019 11:04 AM
    Friday, November 1, 2019 11:03 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    What have you tried so far? Please show your code. We do not deliver ready to use solutions on request.

    And please format any code or sample data as code using the code posting tool: How to Use the Code Feature in a TechNet Forum Post

    Live long and prosper!

    (79,108,97,102|%{[char]$_})-join''

    Friday, November 1, 2019 11:57 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Select-String -Path "c:\FILEPATH" -Pattern 'TFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.'

    Also tried

    Get-ChildItem -Path C:\FILEPATH -Recurse | Select-String -Pattern ''TFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.'' -CaseSensitive


    Below example is for reference. It picks all paragraph.


    PS C:\Users\zahid.haseeb\Documents> Select-String -Path "C:\Users\zahid.haseeb\Documents\test.txt" -Pattern 'TFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.'

    test.txt:1:policy 1-TFS-DB-SQL\, schedule Default-Application-Backup,10/31/2019 02:57:31 - Info nbjm(pid=7116)
    requesting STANDARD_RESOURCE resources from RB for backupTFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.~.7.001of001.20191031025
    712..C,1,9136,MSDP-POOL-STU,access-bkp.accessonline.com,1572472651,0000000337,1572472988,0,the requested operation was
    successfully completed,TFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.~.7.001of001.20191031025712..C,1,9136,MSDP-POOL-STU,access
    -bkp.accessonline.com,1572472651,0000000337,1572472988,0,the requested operation was successfully completed,



    Any comment will be appreciated. Thanks. Zahid Haseeb.


    • Edited by ZahidHaseeb Friday, November 1, 2019 12:12 PM
    Friday, November 1, 2019 12:06 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Please format any code or sample data as code using the code posting tool: How to Use the Code Feature in a TechNet Forum Post

    Live long and prosper!

    (79,108,97,102|%{[char]$_})-join''

    Friday, November 1, 2019 12:29 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Try this:

    $str = "policy 1-TFS-DB-SQL\, schedule Default-Application-Backup,10/31/2019 02:57:31 - Info nbjm(pid=7116) requesting STANDARD_RESOURCE resources from RB for backupTFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.~.7.001of001.20191031025712..C,1,9136,MSDP-POOL-STU,access-bkp.accessonline.com,1572472651,0000000337,1572472988,0,the requested operation was successfully completed,TFSDB.MSSQL7.TFSDB.db.TFS02_Warehouse.~.7.001of001.20191031025712..C,1,9136,MSDP-POOL-STU,access-bkp.accessonline.com,1572472651,0000000337,1572472988,0,the requested operation was successfully completed"

if ($str -match "(TFSDB\.MSSQL7\.TFSDB\.db\.TFS02_Warehouse\.)"){
    Write-Host $matches[1]
}

    --- Rich Matheisen MCSE&I, Exchange Ex-MVP (16 years)

    Friday, November 1, 2019 4:02 PM