
-dp-
Members-
Content Count
41 -
Joined
-
Last visited
Community Reputation
3 NeutralAbout -dp-
-
Rank
member
FileMaker Experience
-
Skill Level
Intermediate
-
FM Application
18
Platform Environment
-
OS Platform
Mac
-
OS Version
Catalina
-
Extracting first name from Last, First MI
-dp- replied to -dp-'s topic in Calculation Engine (Define Fields)
Well, we keep telling the students that they need to be life-long learners.... : ) Got it! The light just came on. Thank you. -
Extracting first name from Last, First MI
-dp- replied to -dp-'s topic in Calculation Engine (Define Fields)
This works perfectly. Thank you very much. I'm trying to wrap my mind around the calculation and make this a learning experience. Here's my best shot. - Search FullName for the comma. - Set the target length to FullName minus the comma. - Select the right content of FullName - Put all of the above into a variable named "tail". - Select the left words in tail, with the number of words set to tail minus 1. The last part doesn't make sense to me. Would you mind elaborating? -
Extracting first name from Last, First MI
-dp- replied to -dp-'s topic in Calculation Engine (Define Fields)
Ah, I see. Aside from what can be discerned visually, I don't know the rules of organization. A system over which I have no control generates a screen-only report, which I highlight, copy, and paste into a text editor. Then I'll import it into FileMaker for further processing. What I'm attempting is sync between two systems that have no intention of communicating with each other. The source does contain hyphenated last names and double-barreled first names, so your calculations have been enormously helpful. I can't rule out double middle initials, but a visual scan doesn't spot any. Thanks. -
Extracting first name from Last, First MI
-dp- replied to -dp-'s topic in Calculation Engine (Define Fields)
Thank you. This is very helpful, even though I don't fully understand it yet. The last name function returns the last name. Perfect. Both of the other functions return both the first name and middle initial. So, for "Doe, John Q" it returns "John Q". How can I get it to return simply "John"? -
-dp- started following Extracting first name from Last, First MI
-
I need to process a tab-delimited file. The source is "Adams, John Q". I need to parse it into two fields: nameLast and nameFirst. (I don't need the middle initial.) nameLast is a straightforward LeftWords calculation. But I'm stuck on how to ignore the comma and and the middle initial to extract the first name. Can anyone help? FMPA 18 macOS 10.15.6
-
Parsing delimited data in a single field on import
-dp- replied to -dp-'s topic in Importing & Exporting
I just adapted your script into my solution, and it worked perfectly. Thanks very much. -
Parsing delimited data in a single field on import
-dp- replied to -dp-'s topic in Importing & Exporting
Tempting, but every time I've done something like that in the past, it has eventually come back to bite me. I'll need to produce some charts, so I think that spinning off a separate table is the way to go. But thanks for the idea. -
Parsing delimited data in a single field on import
-dp- replied to -dp-'s topic in Importing & Exporting
It's good to know that I was on the right track, but this is much cleaner than where I was going. I was not aware of the ValueCount function. Thank you for educating me. -
I need to import data from a Google Forms survey. One of the fields is a text field containing multiple semi-colon-delimited values (e.g., "basketball;football;track & field;volleyball"). I need to break these out into separate records in a related table. The only idea I've come up with is to capture the field contents into a variable, count the values (using a method I have not yet figured out), create a related record with the leftmost value (the method of identifying which I have not yet figured out, given that some values contain multiple words and spaces), delete the leftmost value ,
-
Keyboard control of Script Workspace?
-dp- replied to -dp-'s topic in Script Workspace and Script Triggers
These are helpful, as far as they go. And I'm using only about half of them consistently. Perhaps I should focus more on habitually using what IS available. Thanks for your help. -
I prefer to use the mouse as little as possible. I have tried unsuccessfully to find keyboard controls for Script Workspace. For example, if I want to enter a Sort Records step, I can enter the command by typing s-o-r, then Return. But then I have to reach for the mouse to turn off the dialog and click the cog icon to get to the specifics. Once I get to the field list, I can use the keyboard for only a few strokes. For example, if I have fields nameFirst nameLast nameMiddle namePreferred entering n-a takes me to nameFirst, but it stops filtering at that point. Entering n-p, or
-
Trouble with Month and MonthName functions
-dp- replied to -dp-'s topic in Calculation Engine (Define Fields)
Problem solved. As comment suspected, the problem was with the date field. The dates appear to be correct, but changing the format corrects the problem in the other fields. Thanks to both of you for your replies. -
Trouble with Month and MonthName functions
-dp- posted a topic in Calculation Engine (Define Fields)
I have a tool with the following fields. studentDOB - a date field tracking birthdate studentDOBMonthName - a calculation field returning text result - MonthName (studentDOB) studentDOBMonthNumber - a calculation field returning number result - Month (studentDOB) The DOB field works fine. But the other two fields return question marks. This is an FMPA 17 file, hosted on FMS17, accessed on macOS 10.14.2. Any help would be appreciated. -
I have a solution that includes student photos. The standard display is 4.5cm x 5.0cm. I would like to include a popover that displays an enlarged photo. But no matter how large I make the container, the photo remains 4.5x5.0. If I export the photo and open it in Preview, it's much larger. Any suggestions? Thanks. macOS 10.3.6 FMA 17.0.2.205 Photos are JPGs
-
Wow. How did I overlook this? The path of least resistance! Thank you, Josh.