Step
-
Posts
3 -
Joined
-
Last visited
Everything posted by Step
-
TY all. I think the field that picks out needs amending (to lose not only the text before the first para mark, but also after the second one) but I am not sure how to do that. Nor the field to pick out the third line if it exists. Any ideas welcomed - ty.
-
Thanks very much. So I use that formula for Address 2? And then something similar for Address 3 (substituting Address 2 for Address 1 in the calculation). No danger of overwriting the Address 1 field? Replace sounds dangerous to me!!
-
Hi. I have an address field that often contains more than 1 line. I wish to split it into 3 separate fields (as no record has more than 3 lines). I have managed to get the first line out (see below for calculation - prob. v. clumsy) but can not work out how to do the other 2. Any ideas? Thanks If(Position(Home Address 1, "¶", 1, 1)=0, Home Address 1, Left(Home Address 1, Position(Home Address 1, "¶", 1, 1)))