I believe you want Replace Field Contents and not Find/Replace.
And Replace Field Contents allows scripting and setting with 'perform without dialog' so it will just do it. :-)
Hey LaRetta, Thanks so much! I didn't even know of that tool. That's why I like these forums, always learning new tricks :)
Now, if you could help me, the replace calculation I want to say = "Original Field Contents" minus ".jpg" . In the find/replace it finds just the part of the contents that are ".jpg" and replaces them with, well nothing, I am just trying to delete the ".jpg" without having to import/export to excel and back. Maybe I need to split the field contents somewhow first?
Any thoughts are appreciated!!
Left ( YourFieldGoesHere ; Position ( YourFIeldGoesHere ; "." ; Length ( YourFIeldGoesHere ) ; - 1 ) - 1 )
Or you can use:
Let ( T = YourFieldGoesHere ;
Left ( T ; Position ( T ; "." ; Length ( T ) ; - 1 ) - 1 )
) // let
Phil, Thank so much! That worked. Now, I am wondering if I understand correctly what actually happened. It seems the calculation is saying to keep everything to the left of the "." and thus it deletes the ".jpg" and I get the result I want. Am I understanding this correctly?
It works great I just think it's good to know what I did haha
You are correct. Any time you see an expression like this in the forum and you don't understand all the details, you can often figure it out by looking up the functions used in FileMaker Help.