Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,PFA,
I would like create a create another column called Country from the column Assessment. My expected result is
Assessment | Country |
AGLB - NBC Tanzania - CA | NBC Tanzania |
AGLB - Ghana - CA | Ghana |
AGLB - Kenya - CA | Kenya |
AGLB - Mauritius - CA | Mauritius |
AGLB - Tanzania - CA | Tanzania |
Trim(SubField(Assessment, '-', 2)) as Country
-Rob
The question and the answer would be applicable to both products.
-Rob