Import cell into three fields

This topic is 5673 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Share on other sites

Wasn't this answered a few days ago?

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

LaRetta

Share on other sites

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.

Share on other sites

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.

Share on other sites

It WAS answered just yesterday, but it was here.

Share on other sites

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.

Share on other sites

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.

Share on other sites

This topic is 5673 days old. Please don't post here. Open a new topic instead.

Create an account

Register a new account