Jump to content

Import cell into three fields


Slickwilly9
 Share

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
Link to comment
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.

Link to comment
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.

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.