Pase keywords in text string

• Bruin

  SSCrazy

  Points: 2058

  More actions

  July 15, 2024 at 1:11 am

  #4436059

  I've been trying to find an example to parse a record that looks for a Beginning keyword then based on that finds another keyword on the same line then pulls the next x  values that are quoted.

  example:

  $data = @" this is a sample cstsums record with Values('xxxx','ppppp','45gheeet','pperere')

  $data = @" this is a sample cstdetails record with Values('xxxx','ppppp','45gheeet','pperere')

  output table   expected and columns(headers)

  tbl                 Value1 Value2       Value3       Value4

  cstsums        xxxx      ppppp    45gheeet

  cstdetails      xxxx      ppppp    45gheeet      pperere

  If the record contains cstsums I want the first 3 quoted fields after the word Values. If it's a cstdetails on the record I want the first 4 quoted fields after word values.

  Thanks.

   

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 16, 2024 at 2:10 am

  #4436439

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.