Dr Kyle

Ok comment, I downloaded your demo and it is beautiful!!! I imported the script to my file, but since I am an idiot and dont know much about scripting yet, I couldnt make all the changes necessary to get it to work with my table. In my last post I attached a .txt file with the field in question (and a ref. field). This time, I am attaching the whole file (in a zip file) with all records and fields. It is the "secondary_Id" field which needs the CG's removed, while the other fields remain the same. Sorry again that I am not very good with FM8 here... Flybase_Genelist.zip

Wow, you guys are really coming to my aid here... I appreciate it. As you suggested, I am attached a comma-seperated txt file containing just two fields... A record number field (so I can reinput the data) and the field which needs the CG's removed from it. If anyone wants to tackle it, I wish you the best and thank you very much. KYLE Flybase_Genelistv4.23.txt

Unfortunately, the CG's are dispersed among the FBgn's... so they could be at positions 1 thru N in the field. So your calc wont deal with that right? Sorry that I am so bad with FM guys... I really do appreciate the help here. I was thinking the suggestion to use a text editor (never heard of BBedit or textwrangler but I get the idea)... but the problem may be compounded by the fact that other fields in each record also contain CG numbers and need to keep them there. Just this field needs to get rid of them. Probably my last post for the night guys. I will keep playing with it for a few then start fresh in the AM at work. I will update you tomorrow about it... KYLE

LOL thanx for trying to help me here... I am pretty new to FM and a lot of things beyond IF calculations and doing lookups using relationships is beyond me right now. KYLE

The problem is that there are other entries in many of these records in the same field. Example: In the same field, I could have... CG1234 CG12345 FBgn1234567 FBgn8901234 Each entry in the field is followed by a carriage return however, so they can be individually "referrenced" or used to link/relationship. In the example above, I need a way to remove the CG1234 and CG12345 (and their carriage returns) while leaving the FBgn entries intact. I have ~14,000 records to do this for. KYLE

"and no other code contains CG, simple make a find of CG!" Do you mean that I should do a find/replace using CG! as the find part???

Reed: I have tried what you suggest, but I cant get it to work. What wildcards to I use to get it to recognize any occurences of CG followed by numbers? I realize I might have to do this replacement twice (once for cases with 4 numbers, once with 5) but that is fine. I have been using: Substitute (Field_ID, "CG****", "") It runs fine, but never finds any of the CG numbers and removes them. Same thing when I use # or @ instead of the *. Any ideas? Nope, I dont have access to anything but FM8 Pro. KYLE

Ok guys... since you came to my aid and solved my other question so quickly yesterday, I am gonna rely on you again... I have a field in a table which contains several entries of data in each record... Each entry is a series of letters and numbers, following three types of formats (# are digits). 1. FBgn######## 2. CG#### (eg. the letters CG followed by 4 digits) 3. CG##### (CG followed by 5 digits) I need to do a find/replace in this field to find all occurences of a CG with either 4 or 5 digits and remove it (replace with nothing). I have tried using wildcards in the find/replace function, but they dont find any of the CG's. Any ideas???

Thanx guys... It worked perfectly! KYLE

I have one field in a table which has many different values (text) separated by commas and a space. In order to be able to search each value in that field seperately, I need to replace the comma and space with a carriage return. Thus, instead of seeing: Dog, Cat, Rabbit I need to use find/replace to give me: Dog Cat Rabbit Can anyone tell me how to do this?

Thanx... I got it working now! KYLE

First off, I am new to this board and want to say "hello"! I have attached a .jpg pic of my current FM7 file. You will see Ten TEXT fields (highlighted in blue) which all contain the scientific names of genes in the Fruit Fly Genome. What I am trying to do is relate each one of these Ten fields back to the SAME FIELD OF ANOTHER FM7 FILE to lookup whether each gene name appears in the other file... and then to report the record number it appears in in the file. You can see me trying to test this out using the two sample fields "Peptide1_Rec#_In_Unannotated_List" and "Peptide2_Rec#_In_Unannotated_List". However, when I link anything more than one of the "Protein1, 2, 3, etc" fields to the same field in the second file, the Record number lookups either stop working altogether or lookup the same data for all cases (as seen in the current photo). This record number (in the photo) is right for Protein1, but Protein2 is just reporting the same as Protein1 is instead of reporting its own. If I make a relationship for Protein3 to the same field in the other file, they all stop working. Am I breaking some kind of rule here? I tried to just make ten "copy" fields in the file I am linking them all to, so each of the "Protein" fields would have its own relationship with a "clone-field" of the original one... But in this case I couldnt figure out an easy way to get the data in the original field to be "copied" into the other ten for all 223 records. I really need some help guys... KYLE

I will work my way through your last post and see what I come up with. I have to admit though, on first read threw I dont even understand 90% of your post. My fault, not yours. I really appreciate your time and effort on this. You are a wiz! I have another, seperate, likely MUCH EASIER question to ask about relationships, which I will post in a new thread though... Kyle

Unfortunately, the original Filemaker file is being generated by others, and involves ever changing gene names... so I dont think the option you suggest will work in my case. I really appreciate all your help on this. Maybe it just cant be done the way I want it to be. Oh well I guess... Kyle I am done screwing with it for tonight at least.

I dont know what I did wrong, but the summary field isnt working right. And when I checked out what the first "patternCount" field did, it is still only looking IN THAT SAME RECORD, NOT ACROSS ALL RECORDS AND ALL TEN FIELDS. Man, I must be really dense here... I think if the "PatternCount" was doing what I needed, then I wouldnt need the summary. Essentially, to restate the problem... I have 223 records in a file, all of which have ten text fields named Protein1, Protein2... Protein10. Each position in every record is either entirely blank, or has a gene name in it (the letters CG followed by several numbers). In each each, I want to create a new field corresponding to each of the ten gene fields which checks how many times the gene in say the Protein1 field occurs not only in the other nine ProteinX fields of THAT RECORD, but in all TEN ProteinX fields of the other 222 records. Essentially, I want to know how many times each and every gene occurs in the file, regardless of which position it appears in (Protein1-10). Thus, when I am looking at Record 134 for example, I want to see the gene names in the PrteinX fields, and how many times that gene occurs in the entire file (223 records) next to it in the "ProteinX_count" field. I have attached my work thus far, so you can look at it if you choose. Sorry i am a novice here guys. KYLE FlyWork.zip