Under the "Select Expert" - Formula
In the first example it pulls "*a" from the "CK_BED_SPACE" field but in the second example it pulls "*A" and "*a" from the "CK_BED_SPACE" field. I don't want it to pull the "*A" (ex. 101A)...
For example sake I have put numbers within () to better explain my needs.
I need to sort table(1) by field(3) then compare SSN in field(1)from table(1) to table(2) field(2, also containing SSN). If match, in table(2), then delete entire row containing matching SSN in table(2).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.