Ad Widget

Collapse

How to remove first line of a string?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • high-t
    Member
    • Dec 2014
    • 68

    #1

    How to remove first line of a string?

    Hi.

    I have the following string generated by a text type item:
    Code:
    [ISQL]INFO: SQLExecute returned SQL_SUCCESS_WITH_INFO
    DB1,     13.94 MB,NT AUTHORITY\SYSTEM,24,Dec 30 2019,Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=869, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled,140
    DB2,      6.00 MB,NT AUTHORITY\SYSTEM,25,Dec 30 2019,Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=869, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled,140
    DB3,   3836.19 MB,NT AUTHORITY\SYSTEM,20,Dec 30 2019,Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=869, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled,140
    I need to remove the first line to be able to further translate this CSV to JSON.

    Any ideas how?

    Thank you in advance!
    Amit.
Working...