Parsing a really long catchall log string

[BHScripter]

Hi:

I have a column which I need to parse out one value from a really long string. The column contains log file information which holds information regarding when a table receives an insert statement. The string looks like the string below just a lot longer. I need the value that says "testvend". It should always be the second item in the VALUES parantheses group.

Sample of log entry in column:
INSERT INTO Sample(HPerson, UCODE, ULASTNAME) VALUES ( 921582, 'testvend', 'Test')

thanks for any help in advance.

 

[markros]

Find the value 'VALUES' and get the string following the VALUES
E.g.
(921582, 'testvend', 'Test')

Then you need to get a string between two commas.

So, do your work in steps using substring and charindex functions.

PluralSight Learning Library

 

[simian336]

If all your data looks like that just use charindex to find the first and second sigle quote and substring to get everything between.

Simi

 

[BHScripter]

Found the first single quote and then used substring. Thank you!!!