topic Re: Custom code / Format Data - split full name property in Data Hub

Custom code / Format Data - split full name property

ShlomiGani — Wed, 11 Jan 2023 14:05:03 GMT

Hi everyone,

Unfortunately I didn't find any split command in the format data option.

We do pay for OPS enterprise and I would like to keep this action in house instead of exporting it to Make.com / Zapier.

Has anyone ever tried to create custom code for this split and can share it with me? (I usually work with no code / low code platforms)

Re: Custom code / Format Data - split full name property

ChrisoKlepke — Wed, 11 Jan 2023 14:50:21 GMT

Hey @ShlomiGani ,

what is it that you need to split and what results do you need. For example, in this short Python code for a custom code action, we use an input field (assuming it is a string) and split it at spaces. The result then would be a list. So if the input string is:

"Never gonna give you up Never gonna let you down"

The result would be:

['Never', 'gonna', 'give', 'you', 'up', 'Never', 'gonna', 'let', 'you', 'down']

Here is the code:

def main(event): input_string = event.get("inputFields").get("input_string") output_list = input_string.split(" ") return {"outputFields": {"output": output_list}}

But I assume there might be more to it depending on what your input data is and what output you expect.

Cheers,

Chriso

Re: Custom code / Format Data - split full name property

ChrisoKlepke — Wed, 11 Jan 2023 14:56:50 GMT

Just noticing the title of the thread 😅 Here it is for full name getting first and last name.

def main(event): full_name = event.get("inputFields").get("input_string") name_list = full_name.split(" ") first_name = name_list[0] last_name = name_list[-1] return { "outputFields": { "first_name": first_name, "last_name": last_name, } }

Re: Custom code / Format Data - split full name property

ShlomiGani — Wed, 11 Jan 2023 15:50:01 GMT

Hi Chrisotoph, Tnx for your quick answers.

Should I replace the green quets with the property lables?

As it is I get an eror .

[ERROR] AttributeError: 'NoneType' object has no attribute 'get'
Traceback (most recent call last)

Re: Custom code / Format Data - split full name property

ChrisoKlepke — Thu, 12 Jan 2023 08:25:16 GMT

Hey @ShlomiGani ,

sure, let me show you how to set up the custom code action with some screenshots.

The most important stuff is the following:

Language: Python 3.9
Properties to include: Choose the property that holds your Full Name values and give it key input_string
Code: Copy and paste the provided code
Data output: Create two data outputs as string values and call the first_name and last_name

You then can test it with a contact.

To use it in the First Name and Last Name properties, create two additional workflow actions with Copy Property Value. Here you can copy the value from the output strings to the respective property.

If you found this post helpful, consider helping others in the community to find answers faster by marking this as a solution. I'd really appreciate it.

Cheers,

Chriso

Re: Custom code / Format Data - split full name property

ShlomiGani — Thu, 12 Jan 2023 10:22:43 GMT

Amazing.

Thank you very much 🙂

I really appreciate it

Re: Custom code / Format Data - split full name property

ShlomiGani — Thu, 12 Jan 2023 12:44:04 GMT

@ChrisoKlepke
There are some names that have more than one word, so I changed the code so the first name will be the first word, but the last name will be the rest

last_name = full_name.replace(first_name, "")

Re: Custom code / Format Data - split full name property

ChrisoKlepke — Thu, 12 Jan 2023 12:57:49 GMT

@ShlomiGani yeah, I was expecting such a problem. The issue I see is that you never know if it is two first names or last names. Maybe depending on the culture you're operating in, one or the other is more likely. But in any case: The way you're suggesting makes sure nothing gets lost.

The other approach could be to write an if condition in the code that returns the main function and notifies a team member to take care of that manually. Of course, doesn't scale that well.

What I'm trying to say is that no solution is entirely foolproof and there are advantages and disadvantages to everything. Thank you for the feedback and conversation, though.

Cheers,

Chriso

Re: Custom code / Format Data - split full name property

LRiley32 — Wed, 17 May 2023 19:08:46 GMT

@ChrisoKlepke

when implementing the code and "first name" contains only one name, it duplicates the first name to the last name.

Is there a way to prevent the code from running if there is no space and last name?

Re: Custom code / Format Data - split full name property

MHarp — Fri, 05 Jan 2024 23:27:03 GMT

Hi Christoph, I have done as you show in the screenshots and get this error message :

Property to include in code is input_string
My two outputs are first_name, last_name
Language is python 3.9 and I have the property correctly mapped to include in code. Copied and pasted verbatim from above.

[ERROR] AttributeError: 'NoneType' object has no attribute 'split'
Traceback (most recent call last):
  File "/var/task/hubspotHandler.py", line 4, in hubspot_handler
    return file.main(event)
  File "/var/task/file.py", line 5, in main
    name_list = full_name.split(" ")
Memory: 37/128 MB
Runtime: 10.59 ms

Re: Custom code / Format Data - split full name property

Pferrara — Tue, 20 May 2025 22:16:45 GMT

hi do i need operations hub for this?

Re: Custom code / Format Data - split full name property

kennedyp — Mon, 02 Jun 2025 22:07:02 GMT

Yes. Custom code workflow actions require Operations Hub - Professional or higher.