Search the Community
Showing results for tags 'extracting text'.
Found 3 results
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 figure out a way to dump the pipe ("|") character so I don't end up with "|ID". Also, since the calculation will always result in the format, "|two-letter state|two-letter country", would using the Right text function be more elegant/effective to grab the state code? Cheers, Rich
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 separate the email addresses. Apart from that am struggling - I would be delighted if someone could give me some pointers on this
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!