Hi,
I have a table in msaccess with the following data
Table1
IDDatabase
ID-1ABC^DB-1^MSSQL^PROD
ID-1XYZ^DB-2^MSSQL^PROD
ID-1DEF^DB-3^MSSQL^PROD
ID-1GHI^DB-4^MSSQL^PROD
ID-2HJIID-2POKILID-2YGTF
ID-2CCML
ID-3HYTD^DB-5^ORACLE^PROD
I am trying to split the data in database column in a new table Table 2 with the following columns
ID, DBName, DBID, DB, ENV
The common delimeter in database column in '^'
I have tried using the split function in side an arrary, but i am not able to get the result values from the split into multiple columns.
Any help would be appreciated.
I have a table in msaccess with the following data
Table1
IDDatabase
ID-1ABC^DB-1^MSSQL^PROD
ID-1XYZ^DB-2^MSSQL^PROD
ID-1DEF^DB-3^MSSQL^PROD
ID-1GHI^DB-4^MSSQL^PROD
ID-2HJIID-2POKILID-2YGTF
ID-2CCML
ID-3HYTD^DB-5^ORACLE^PROD
I am trying to split the data in database column in a new table Table 2 with the following columns
ID, DBName, DBID, DB, ENV
The common delimeter in database column in '^'
I have tried using the split function in side an arrary, but i am not able to get the result values from the split into multiple columns.
Any help would be appreciated.
Last edited: