BuddyPress.org

@nielspilon I really do think substr( strstr( u.display_name, ' ' ), 1 ) is your answer. You say there’s definitely no members returned with that in place?

@shanebp Maybe just remove the first word from the string? i.e.

strstr( 'Robin van Persie', ' ' )

which gives  van Persie. Then you just need remove the initial space:

substr( ' van Persie', 1 )

@nielspilon if the sorting is fine (van, de etc) then that is down to luck 🙂

@shanebp Maybe just remove the first word from the string? i.e.

strstr( 'Robin van Persie', ' ' )

which gives  van Persie. Then you just need remove the initial space:

ltrim( ' van Persie', ' ')

@nielspilon if the sorting is fine (van, de etc) then that is down to luck 🙂