Retrieve a name from a database

Hi
When I retrieve the name from a database I get:

James Brown

but I’d like to save just the first name. Like this:

James

I am struggling to get it right.

Thanks a lot


Hello, I think this will help you =)

1 Like

Hi there, @floripaolo… if I understand your post correctly, this expression will do the trick (note that the split by character is a space, meaning you literally type a space into the Text separator field).

name

Hope this helps.

Best…
Mike

Edit: I see you updated your post, and the entire name isn’t capitalized anymore. If that is the case, you can stop after the :first item operator, like @goloshubov.ma is showing.

2 Likes

This topic was automatically closed after 70 days. New replies are no longer allowed.