parsing a text field

[harrietohs]

Crystal 8.5

Data (text) for one field is received as follows

jones,jim;smith,mary;potter,harry

What I need is to have each name appear separately.
Would it be possible to write a formula that would perhaps test for the first, then second, then third, etc, semi colon and parse out just the text between?

Harriet
Ottawa Humane Society

 

[synapsevampire]

Seperately isn't very descriptive, does this mean on seperate lines, alongside each other, or?

Here's a basic way to break them up in a formula:

(replace the "jones,jim;smith,mary;potter,harry" with your field)

split("jones,jim;smith,mary;potter,harry",";")[1]

The [1] denotes which name you want, so you can break them up.

Or you can use:

join(split("jones,jim;smith,mary;potter,harry",";"),chr(13))

Then format the formula to can grow to get them each on their own line.

-k

 

[harrietohs]

Sorry, by "separately" I meant each on it's own line.

 

[harrietohs]

Sorry, I sent last reply before I finished my whole thought about what results I need.

What I want to be able to do is to group on each of the names. Will this formula allow me to do so?

Harriet

 

[lbass]

Please see thread149-1154876.

-LB