What is your goal?to get the initials of last name
What is the problem?I can’t get the split to work, I might be doing something wrong
What have you tried so far?everything.
I’ve tried with a tools module, but can’t seem to get it working
Welcome to the Make community!
To do this, you can use these built-in functions:
These functions may have also been covered in the Make Academy tutorials — refer to the Make Academy Course Overview to learn more.
Here’s an example of how you can use these functions together:
{{ last(split("Your Name"; space)) }}
Make Input Markup: Copy-paste the above into the field, including start/end curly brackets for it to import as intended
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
From my understanding of the query, you can use the below approach to extract the last name and the initials of the last name, as shown in the screenshots I’ve shared.
Example used: Peter K Anderson
• To extract the last name, you can use:
{{last(split(1.name; space))}}
(This will return: Anderson)
• To extract the initials of the last name, you can use:
{{substring(last(split(1.name)); 7; 9)}}
(This will return: A)
Please note that the second approach is not fully dynamic. If you clarify exactly what you’re trying to achieve, we can help make the logic dynamic and better aligned with your actual requirement.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
I got a bit further and succeeded in splitting my lastname into parts, now my next step would be to get first letter of all parts and join them.
In my example below my result should be VDB
Hello,
To merge the first letters of each string in an array, you can use a combination of Iterator and Text Aggregator.
Iterator by providing the split() function as an arrayText Aggregator to use the Iterator’s output, and in the text field, use the substring() function:{{substring(1.value; 0; 1)}}
Example:
Have a nice day,
Michal
You can achieve this by using an Iterator to loop through the array, and then applying a Text Aggregator to combine the values.
Inside the Text Aggregator, you can use the following formula to get the desired output:
{{upper(substring(9.value; 0; 1))}}
This will extract the first character of each item and convert it to uppercase.
For your reference, I’ve also included some screenshots illustrating the setup and configuration.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
