Ability to split up a text field
Posted by Columbusuk on August 16, 2001 3:47 AM
I want to be able to sift through a long columm of e-mail address and recognise what comes after the "@" sign. ie Field is "jonathan@gosure.com" I want to split off "gosure.com" into a separate field thus creating a new column.
While we are about it, I also want to identify those addresses which do not have an "@" sign or do not have <something>.<something> and flag these so they then in a further operation be transferred.
Thx Jonathan