Hi,

There is a field in a table which contains a string of data, then two spaces, and then another string of data. I need the first and second strings of data to become separate fields. I believe, using a formula, this can be done. However, aside from selecting the field in the formula window, I'm not sure how it can be done. I need to know which function or operator to use. Basically "take the first 8 characters of field x and create field y" if that makes sense. Then I need another formula which says "take the last 7 characters of field x and create field z."

Thanks in advance


Edited by troverman - 13 Dec 2012 at 4:46am