Get values with calculated column

Nov 4, 2008 at 9:28 PM
FYI, here are the formulas to retrieve the first 3 columns of the DCL string with a calculated column:
=MID([DCL],1,FIND(";",[DCL],1)-1)
=MID([DCL],FIND(";",[DCL],1)+1,FIND(";",[DCL],FIND(";",[DCL],1)+1)-FIND(";",[DCL],1)-1)
=MID([DCL],FIND(";",[DCL],FIND(";",[DCL],1)+1)+1,LEN([DCL])-FIND(";",[DCL],FIND(";",[DCL],1)+1))
I'll let you figure out the others if you need more columns.
GB