
Announcements
I think I know how to build the automation, but need help with getting the office and/or confirmation that I'm not crazy in thinking I can do this. I am trying to take some data from SQL that is stuffed into a delimited list all in one column (see below) and needs to be dumped into excel and then split into individual columns, the number of columns will vary based on the number of records in the root SQL query, so I can't define it in any paginated or power bi or query report. I was thinking I could pickup the SQL results with the delimited data from a paginated excel export, then run an office script with a text to columns function.
So does anyone have a good code reference for how to do text to columns with office scripts in excel?
Sample Data:
| MAJOR_TYPE~TD~SAV~SAV~CK~SAV~CK~CK~CK~SAV~SAV~CK~TD~SAV~SAV~SAV~CK~CK~SAV~CK~SAV~~SAV~TD~SAV~TD~TD~TD~TD~TD~SAV~TD~TD~TD~TD~~~~CK~CK~SAV~TD~TD~TD~TD~TD~SAV~TD~TD~TD~SAV~CK~CK~TD~TD~TD~CK~CK~TD~CK~TD~CK~SAV~TD~TD~TD~CK~TD~TD~CK~SAV~CK~CK~SAV~CK~CK~SAV~SAV~TD~CK~SAV~SAV~SAV~SAV~SAV~SAV~SAV~~SAV~SAV~CK~SAV~SAV~CK~SAV~SAV~SAV~CK~SAV~SAV~SAV~SAV~SAV~SAV~CK~CK~CK~SAV~SAV~SAV~~CK~CK~SAV~SAV~SAV~SAV~SAV |
| Membership_New_Existing~Existing Member~Existing Member~New Member~New Member~New Member~New Member~New Member~New Member~New Member~New Member~New Member~Existing Member~Non-Member~New Member~Non-Member~Non-Member~Non-Member~Non-Member~Non-Member~New Member~Non-Member~Existing Member~Existing Member~Existing Member~Existing Member~Existing Member~Existing Member~Existing Member~Existing Member |
| PERSIDTYPDESC~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License~Unexpired Photo Non-Driver's~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License~Unexpired Driver's License |