Hi.
I have the following string generated by a text type item:
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.
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
Any ideas how?
Thank you in advance!
Amit.