jknj72
asked on
Additional logic to answered question
This is based off of question ID: 28683827. I had a question on how to return the last value in a string after any variations of LCF in between company names. I want to add some additional logic to the function.
If the string ends with any of the variations of LCF and there is no company name after the last LCF I want to identify it somehow and I will write it to a table. Im thinking that if this happens I want something returned that I can look for(lets say the string '999' for now) and Ill write the bad value to a table.
Just so you know, the table with the bad records will be sent to the department that handles these names and they will enter the correct company and we will fix the data.
If the string ends with any of the variations of LCF and there is no company name after the last LCF I want to identify it somehow and I will write it to a table. Im thinking that if this happens I want something returned that I can look for(lets say the string '999' for now) and Ill write the bad value to a table.
Just so you know, the table with the bad records will be sent to the department that handles these names and they will enter the correct company and we will fix the data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, it WILL return a null... or at least I hope... since I can't type, I'm not sure. ;)
ASKER
Don't worry I know what you meant....And I think you nailed it. Let me do additional testing and will let you know.
Thanks
Thanks
ASKER
great job
ASKER
Did you mean that it will return a NULL? Which is fine because I can simply evaluate that.