splitting strings

[JeroenBoon]

Hello,

I have the following problem: I have a field which can contain the next:

example 1: EX123456 or
example 2: EX123456/EX123457/etc or

so: the field can contain several EX-numbers, separated by '/'.

I want the next:
example 1: just EX123456, so nothing special
example 2: one record containing EX123456, one containing EX123457, etc.

Can this be done and how do I do this if it can?

Jeroen.

 

[beardenb]

Take a look at the split function. The F1 help text in CR is pretty clear.

 

[JeroenBoon]

to be more clear:

if the field contains two EX-numbers, separated by "/", I want two detaillines with on each line one EX-number, if the field contains three EX-numbers, I want three detaillines, etc.

Jeroen.

 

[mbarron]

If you only want to display the EX numbers on their own lines you can use the following formula and then format the field to "Can Grow"

replace("EX123456/EX123457/EX123456/EX123457","/",chr(13) )




Mike

 

[synapsevampire]

I think that Mike meant:

replace({table.field},"/",chr(13))

Using Split would be:

join(split({table.field},"/&quot,chr(13))

-k