Jump to content

Seperating contents within a field.


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

Recommended Posts

Hi,

I was wondering if anyone knows how to seperate something like:

12:00-7:00pm MWTRF

into

12:00-7:00pm as one field

MWTRF as another field using a script. I'm new to Filemaker so I don't have alot of experiences with Scripmaker.

Thanks

[This message has been edited by Kermy (edited February 28, 2001).]

Link to comment
Share on other sites

Hey Kermy,

If the information entered will always be the same length - you could use the LEFT, MIDDLE and RIGHT functions. Have the information entered into a temporary field and use these commands to copy out the information and place it in the field you need.

For example - using the data you gave

12:00-7:00pm MWTRF

You could pull the "MWTRF" using the RIGHT function by saying RIGHT(<fieldname>,5).

If the data is not always the same length, use the LENGTH function to find out how many characters are in the field.

Hope this helps. Good Luck.

Steven B

Link to comment
Share on other sites

If the time will always end in am or pm, I would use that to figure out where to break the field. You can use:

BreakPosition = Max(

Position(InputField,"am ",1,1),

Position(InputField,"pm ",1,1))+1

Field1 = Left(InputField,BreakPosition)

Field2 = Middle(InputField,BreakPosition+1,100)

Link to comment
Share on other sites

This topic is 8429 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
×
×
  • Create New...

Important Information

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