Search the Community
Showing results for tags 'extracting text'.
Greets, all: I'm > this < close but just can't seem to nail it. I'm using a value list that concatenates from another table the values of city, state, and country--that's being used as a key--so it looks like this: Lewiston|ID|US Coeur d'Alene|ID|US Boise|ID|US As part of another calculation, I want it to extract whatever the two-letter state code is ("ID", in these examples) irrespective of the length of the city name. I got this far: Middle ( JOB::Company_City__lxt ; Position ( JOB::Company_City__lxt; "|" ; 1 ; 1 ) ; 3 ) ...but I can't figur
Hello 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 separat
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 p