Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Easy Fix for you FileMaker Guru's, I just cant figure it out!!!


jucream

Recommended Posts

I have a calaculation setup to determine the path of the current file "Get ( FilePath )" which returns:

 

file:/G:/xxxxxxx xxxxxxxxxx/REMINDERS 2.0/ReminderService.fp7

 

I need it to say:

 

G:/xxxxxx xxxxxxxx/REMINDERS 2.0/ReminderService.fp7

 

Could someone please help me with a calc. to get ride of file:/

 

Thanks a Million!!!! Justin

Link to comment
Share on other sites

Middle (YourMess, 7, Length (YourMess) )

 

or if you prefer

 

Middle (YourMess, Position (YourMess, "file:/", 1, 1)+Length("file:/"), Length (YourMess) )

 

or even

 

Substitute (YourMess, "file:/", "")

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use