Level 75
@geerizzle I think it could be
$items = $items->sortBy(function ($item) {
return str_replace("'", '', $item->yourField);
});
Just replace yourField with your property.
Apr 29, 2020
9
Level 2
Doing a sort/orderBy but ignoring an apostrophe at the start?
I want to sort data from my model in alphabetical order, but ignoring an apostrophe if it's at the start:
e.g. Alan 'Bob' Clare currently puts Bob at the start. How can I modify my query or sort on the collection to ignore apostrophes?
I thought this would work but it doesn't:
$items= $items->sortBy(function ($item) {return str_replace(''', '', $i['item']);});
Level 54
Before worrying about how to sort dirty data... why do you have dirty data in the first place?
Level 75
Is Alan 'Bob' Clare 3 separate field, or one field?
And an ORDER BY will put Alan 'Bob' Clare before Bob White.
I do not see how 'Bob' is first unless you ORDER BY middle name.
And what is that sortBy? Just write an sql query and ORDER BY.
Level 2
No doesn't do it unfortunately
Level 2
It's not dirty even if it looks like it, a few things need to be in quotes when they're output.
Level 75
What field are you using.
Level 2
Three separate fields, I just put names for my examples, actually its:
Alanine
'Bad' Cholesterol
Cocaine
But the default orderBy puts 'bad' cholesterol at the top.
Level 75
ORDER BY TRIM(BOTH "'" FROM yourfield)
If that doesn't work use the actual ascii for apostrophe.
1 like
Level 2
Awesome, I went with: orderByRaw('TRIM(BOTH "\'" FROM name)')
Works perfect thanks
Please or to participate in this conversation.