Amend Text to RegEx

Welcome Forums General PowerShell Q&A Amend Text to RegEx

Viewing 2 reply threads
  • Author
    Posts
    • #268682
      Participant
      Topics: 2
      Replies: 5
      Points: 16
      Rank: Member

      I have the code below which produces the example below, ideally I would like to amend the output to produce a SQL command, as per the desired output.

      Is this possible?

      Output Example

      60002AC000000000000003F90001E726d0
      60002AC000000000000003FC0001E726d0
      60002AC000000000000003FD0001E726d0
      60002AC000000000000003FE0001E726d0
      60002AC000000000000005B70001E726d0
      60002AC000000000000005B80001E726d0

      Desired Output

      and wwn like ‘%60002AC000000000000003F90001E726d0%’
      or wwn like ‘%60002AC000000000000003FC0001E726d0%’
      or wwn like ‘%60002AC000000000000003FD0001E726d0%’
      or wwn like ‘%60002AC000000000000003FE0001E726d0%’
      or wwn like ‘%60002AC000000000000005B70001E726d0%’

    • #268901
      Senior Moderator
      Topics: 9
      Replies: 1422
      Points: 5,289
      Helping Hand
      Rank: Community MVP

      if your output example is already what you have, then its a matter of appending and prepending strings.

      • This reply was modified 1 month ago by kvprasoon. Reason: post correction
    • #269048
      Participant
      Topics: 2
      Replies: 5
      Points: 16
      Rank: Member

      Awesome! , thanks for your help!

Viewing 2 reply threads
  • You must be logged in to reply to this topic.