Leaderboard

Have look at the attached demo. It does two things: First, it looks for the occurrence of known patterns in the given text. When any of the known patterns is found, the corresponding code is retrieved. This part is accomplished using a looping script. I could have used a custom function for this, but I am not sure how well this would perform with an unstored calculation going over a large list of patterns at every screen redraw.. The second step is highlighting the found patterns. This is done in a calculation field, so that the original is preserved. Here I am using a pair of custom functions (could be just one, but I also wanted to preserve the original case, so I did not use Substitute()). Most importantly, the file separates data and logic: the patterns and the corresponding codes are kept in a table and both the script and the calculation access them there, with no hard-coding of data in calculation formulas.. MultiPatternCount+Hilite.fmp12

Your formula is looking for a field named "filename" to get a value for the attributeName parameter from there. If you want to supply the value directly as a text constant, you must enclose it in quotes: GetContainerAttribute ( Document ; "filename" )

You can achieve a similar result by using the List() function and substituting the default ¶ delimiter with your own: Substitute ( List ( Field_A ; Field_B ; Field_C ) ; ¶ ; ";" ) This assumes the fields do not contain any carriage returns - otherwise there will be more work to do. Note that empty fields will be ignored. If that's not what you want, then just do a straightforward concatenation: Field_A & ";" & Field_B & ";" & Field_C

Dear Nick, It works perfectly !! Thanks a lot

Hello, Sorry for the delay in reply. I was able to reproduce your error with MirrorSync 5.0 on Mojave running Java 8u211. When we encounter UnmarshalExceptions, the solution is usually to clear the Java cache. You can do this by going to System Preferences, opening the Java control panel, clicking the Settings... button under Temporary Internet Files, clicking the Delete Files... button, select "Trace and Log Files" and "Cached Applications and Applets", then click OK to delete those files. I then downloaded a new Config Client for good measure, and I was able to step through to the page where you input your FMS creds for the dbDownload update option. Once I stepped through this page, I got an error saying my database was damaged and to run a recover on it. The database was actually fine. The issue was with the web publishing engine. I restarted that and was able to complete my configuration, so make sure to run 'fmsadmin restart wpe -y' in terminal on the machine where FMS is installed. Try those steps and let me know how that works for you.

It's a holdover from a time when there were PowerPC-based Macs and the function would return -1 for those.

I think the only reason why some developers create mirror TOGs (one set with "cascading deletes" enabled ) is by no means intended to limit the effects of this feature/function - but only has a memory /graph management so if you need to disable cascade deletion when doing mass data acrobatics you only need to toggle the check box these sets of TOGs and not have to open every other relationship or add text objects adjacent to each relationship as a note.

Hm. If you know that the current table contains a field named either "Roll Price" or "Roll Prc" or "RollPrc", you could determine which one is it by = FilterValues ( "Roll Price¶Roll Prc¶RollPrc" ; FieldNames ( "" ; Get ( LayoutTableName ) ) ) This is assuming the field is present on the current layout; otherwise you would use = ExecuteSQL ( "SELECT FieldName FROM FileMaker_Fields WHERE TableName=?" ; "" ; "" ; Get ( LayoutTableName ) ) to get the field names. You could then use the GetField() function to get data from the appropriate field. Even your method would be more elegant, if not more efficient, if you used = IsValid ( GetField ( $testFieldName ) ) as your test. However, it is difficult to imagine a situation where the developer writing the script would not know the names of the fields in the solution he or she is working on.

Dont use stream as the FOS name, its a reserved word.. What are you expecting to get back from the function??? I get something like base6417434013292067398887.txt Do you already know the path to this file?? What do you expect the contents to be? a byte array or something else?? tempFile = File.createTempFile('base64', suffix) fos = new FileOutputStream(tempFile) fos.write(Base64.getDecoder().decode(encodedString)) fos.close() return tempFile.toURL()

FM Migration tool allows you to easily migrate production data into a new version. There are commercial products that add file management and more to that tool.