How to use SPLIT_PART in a query for a Progress database via a Microsoft SQL Server Linked Server?

General Discussion
1

I have a SQL Server 2019 connected to a Progress Open Edge Database and I’m trying to query a column named abs_user from a table named abs_mstr and in this column there are strings separated by commas.

This is an example of what is in the column:
,505611,XXXXXXX,13M2,03294961,XXXXX,20220216183348,US,0000,’

I only need the 13M2 and the datetime which is 20220216183348.
Thanks

2

If you are using MSSQL 2016 or newer you can use STRING_SPLIT. Alternatively, you can query your data through scripting and use python split() on the resulting data set.