Hello Again,
Part of our integration with out website we have been setting up sub-customers so individuals can use the company account to purchase online. Long story short we just found out that we have been setting them up wrong and it is not working correctly. We set every subcustomer up as a company instead of an individual. like 1600 of them so far. ?
I have been trying with a mass update and I have at least been able to target the correct customers, but switching them is another story. I can switch it appears to individual, but I need to have a formula that takes the company name and converts it to a first name and last name. It looks like it can be done with the formula "TRUNC(n1 [, n2 ])" but I don't know n1, or n2 to make first name/ last name.
Here is an example of a subcustomer name: "D & S Concrete Ltd. : David Sank"
David Sank is his name. The name always comes after :
Will someone please advise if this is possible or if there is another way? This has caused enormous issues as you can imagine.
Thank you,
Dallas