filopastrymaker

Find quantity of each string in a textfield or variable

Discussion created by filopastrymaker on Jan 14, 2017
Latest reply on Jan 22, 2017 by user19752

Using FileMaker Pro 9/10/11

 

If I have a single text field or variable with values such as:

 

2271;

2272;

2273;

2274;

2275;

2276;

2271;

2271;

2274;

2275;

 

How can I extract the information that shows there are:

 

3 x 2271

1 x 2272

1 x 2273

2 x 2274

2 x 2275

1 x 2276

Outcomes