Import cell into three fields

[Slickwilly9]

I have a spreadsheet that has three values separated by commas. I want to import those into three separate fields in FMP. Is that possible? I am guessing it would take some sort of deliminating script. The format is like this: 23.00, 55.00, 150.00. Some fields only have 23.00 or 23.00, 55.00. So I need one field to eqaul the first value before the comma and the next field eqaul the second value before the next comma and the third field to equal the last value in the cell. Thanks.

Edited May 26, 2006 by Guest

[LaRetta]

Wasn't this answered a few days ago?

Or have you been staring at recursion calcs too long? Been there - done that.

LaRetta

[Slickwilly9]

It is a different issue but similar to that question yes. I guess what I am asking for is a calculation to count the number of characters before a comma. I am using Middle(impRates; 1; don't know what goes here) I don't know how to get that. I've been trying to use a count but hasn't been working.

[Slickwilly9]

Got it. I used the calculation Middle (impRates ; 1 ;Position(impRates; ",";1;1) ). Thanks for any effort. I'm sure I'll have tons of questions before the night is over. Thanks again.

[comment]

It WAS answered just yesterday, but it was here.

[Slickwilly9]

Umm not quite. I need to find the position of the comma. So I need to use the position function. I am using Middle(impRates; Position(impRates;",";1;1)-1 to display the first rates.

Displaying the rates after the first comma and before the second is what I am having trouble with. I am using

Middle ( impRates ; Position(impRates;",";1;1) ;Position(impRates;",";1;2)-Position(impRates;",";1;2))

But it isn't working. Or if you have a better suggestion I would love to hear it. Thanks.

[comment]

I need to find the position of the comma.

You could do that. Or you could use the shortcut I linked to:

MiddleWords (Substitute ( impRates ; "," ; " " ) ; 2 ; 1 )

returns "55.00" using your sample data above.