Dineedshelp
Technical User
Hi,
I don't know how I am going to explain this one easily but I will give it a go!!!
I have a database linked to a sql database. Within this is a field that holds information that is set to hold the same information for every record, but might not as it isn't relevant.
For example:
Record 1 returns: has proof a , has proof b, has proof c
record 2 returns: has proof a , has proof c,
What I need to do is split this string down into different columns, but if a field is missing ie record 2 has no proof b, I need it to jump to the next column.
Commas seperate the info within the sting, and I have a list of all the column names I need.
Does anyone understand this?
I don't know how I am going to explain this one easily but I will give it a go!!!
I have a database linked to a sql database. Within this is a field that holds information that is set to hold the same information for every record, but might not as it isn't relevant.
For example:
Record 1 returns: has proof a , has proof b, has proof c
record 2 returns: has proof a , has proof c,
What I need to do is split this string down into different columns, but if a field is missing ie record 2 has no proof b, I need it to jump to the next column.
Commas seperate the info within the sting, and I have a list of all the column names I need.
Does anyone understand this?