Separating a string

[Slickwilly9]

I have a field that is imported with a title and a URL (ie The Alamo, http://www.thealamo.org) I have imported the records into a field then used two fields to calculate the necessary information.

Title - MiddleWords(Substitute(impAtt;",";" ");1;2)

URL - MiddleWords(Substitute(impAtt;",";" ");4;2)

The problem is that the Title field has a variable amount of words. How do I separate between the comma no matter how many words on each side. Thanks.

Edited May 30, 2006 by Guest

[mz123]

Hey there!

You could use a calculation as follows, for the title:

Left(impAtt; Position(impAtt; ","; 1; 1) -1)

and then for the URL:

Right( impAtt; Length(impAtt) - Position(impAtt; ","; 1; 1)-1 )

Hope that helps!