I need to write a piece of code which splits out the data contained in the field “Contents” and either creates a new table with the data split out or appends the data to an existing table (TblOutput) in the relevant field
(Hopefully this makes sense - if it was in Excel this would be a Data>Text to Column action)
The data in the field “Contents” is separated by a “~” and looks like this:
~Ima Example~Example Co~Head of Exampling.
The Table (TblOutput) has 5 fields:
The data need to get mapped as follows
“Content” Field Name in TblOutput
1st Section = List
2nd Section = Email
3rd Section = Name
4th Section = Firm
5th Section = Role
And should end up looking like this in the table:
Can anybody Help?