Removing Padded Spaces from SQL Statements in Log Data

Database
Enthusiast

Removing Padded Spaces from SQL Statements in Log Data

Hi,

 I am trying to export sql statements from the TD log table data on TD 15. The sql_text column is 31,000 characters and it's padded. I want to extract the sql statement data into a simple text file using the TD extract utility - but I don't want the data padded. NOTE: The padding occurs even in the middle of the sql statement, it's not just at the beginning or end.

   Has anyone extracted the sql statement from the log table - and done it without the padding?

 

Thanks!!

Vmusic