Search the Community
Showing results for tags 'extracting text'.
Found 2 results
john777 posted a topic in Managing ScriptsHello Am trying to clean up the email field on a filemaker database. At the moment there are many records that contain more than one email address or an email address and text. what I want to do is delete everything in the field apart from the first email address In the vast majority of cases the required email address is the first thing in the field. So my thinking is that the script would have to read along until it found an "@" symbol and then truncate the text at the next space comma or backward or forward slash as they are generally the methods people have used to separate the email addresses. Apart from that am struggling - I would be delighted if someone could give me some pointers on this
jl2014 posted a topic in Calculation Engine (Define Fields)I am trying to figure out how to extract a portion of a filename from a field, when the filenames differ. It is for a file database. This would be easy if all the files are named the same, but we have multiple different filenames based on the type of file it is. So the idea is I have a "shot_name" field that pulls in the name from the file I am importing into FileMaker. For instance, here are two of the filenames...one is for a traditional shot and one is for a development shot. Traditional Shot: BOG8515_150731_Line-Up Development Shot: BDC_dev9150_150721_Line-Up Essentially the only portion of the shot I want is the following for each: Traditional Shot: BOG8515 Development Shot: BDC_dev9150 I believe there would only be these two variables I would encounter, however the end of the filename may change from _Line-Up to _Change from time to time. Is there a way to strip out only the shot name? Can't quite wrap my head around how I would do that in a calculation field. Any tips or advice would be greatly appreciated!