StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PORegex - How to search for singular or plural version of word
primarykey
Id
11405660
data
AcceptedAnswerId
11405957
AnswerCount
3
ClosedDate
2016-04-12T01:15:43.213
CommentCount
9
CommunityOwnedDate
CreationDate
2012-07-10T02:00:53.843
FavoriteCount
2
LastActivityDate
2015-02-02T02:14:53.080
LastEditDate
2012-07-10T02:34:17.930
LastEditorUserId
247316
OwnerUserId
247316
ParentId
0
PostTypeId
1
Score
3
ViewCount
12556
LastEditorDisplayName
text
Body
I'm trying to do what should be a simple Regular Expression, where all I want to do is match the singular portion of a word whether or not it has an s on the end. So if I have the following words <pre><code>test tests </code></pre> EDIT: Further examples, I need to this to be possible for many words not just those two <pre><code>movie movies page pages time times </code></pre> For all of them I need to get the word without the s on the end but I can't find a regular expression that will always grab the first bit without the s on the end and work for both cases. I've tried the following: <pre><code>([a-zA-Z]+)([s\b]{0,}) - This returns the full word as the first match in both cases ([a-zA-Z]+?)([s\b]{0,}) - This returns 3 different matching groups for both words ([a-zA-Z]+)([s]?) - This returns the full word as the first match in both cases ([a-zA-Z]+)(s\b) - This works for tests but doesn't match test at all ([a-zA-Z]+)(s\b)? - This returns the full word as the first match in both cases </code></pre> I've been using <a href="http://gskinner.com/RegExr/" rel="nofollow">http://gskinner.com/RegExr/</a> for trying out the different regex's. EDIT: This is for a sublime text snippet, which for those that don't know a snippet in sublime text is a shortcut so that I can type say the name of my database and hit "run snippet" and it will turn it into something like: <pre><code>$movies= $this->ci->db->get_where("movies", ""); if ($movies->num_rows()) { foreach ($movies->result() AS $movie) { } } </code></pre> All I need is to turn "movies" into "movie" and auto inserts it into the foreach loop. Which means I can't just do a find and replace on the text and I only need to take 60 - 70 words into account (it's only running against my own tables, not every word in the english language). Thanks! - Tim
Tags
<regex><sublimetext>
Title
Regex - How to search for singular or plural version of word
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USTim
UserOwnerUserId
1. USTim
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.