Hello,

I have a field with 15 sections separated by commas. is there a way to extract the data between each comma separation???

Thank you,

Tom

Yes.

There are a few different ways to parse out the info but to give you the best way maybe a little more info.

You could use funtions such as Left, LeftWords, MiddleWords, RightWords, or LeftValues, MiddleValues, RightValues.

You would have to use a substitute () first to substitute your commas into ¶ or spaces if there are no spaces following the commas.

To extract the 4th section, for example:

Let ( [

n = 4 ;

t = "," & YourField & "," ;

start = Position ( t ; "," ; 1 ; n ) + 1 ;

end = Position ( t ; "," ; 1 ; n + 1 )

] ;

Middle ( t ; start ; end - start )

)

To extract any other section, just change the definition of the n parameter.

Hi comment

isn't nicer with a Trim ?

Trim ( Middle ( t ; start ; end - start ) )

Thanks!!!

That worked great!

Tom