# Words per sentence **URL:** \ **Category:** Ask for Help\ **Created:** [January 30, 2022, 8:48pm UTC](https://community.glideapps.com/t/words-per-sentence/37896 "2022-01-30T20:48:52Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 31, 2022, 3:17pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/21 "2022-01-31T15:17:11Z")
Ya…It’s not super elegant. You’d need to define what a “sentence” is…perhaps a template column first to replace all ending punctuation with a `||` or something and then split column with `||` being the delimiter. ![CleanShot 2022-01-31 at 10.16.24@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/78d0fea23dba2b35d5a11d51d117f197b6897e18.png) ![CleanShot 2022-01-31 at 10.16.36@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/26968e962283e927fc0e08ab4f153c258b47ac2d.png) ---
**Author:** ![got10thumbs](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/got10thumbs/32/36638_2.png) [@got10thumbs](https://community.glideapps.com/u/got10thumbs)\ **Post date:** [January 31, 2022, 3:51pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/22 "2022-01-31T15:51:51Z")
Yes, it was a no-code route I was looking for (otherwise, why not just use Python?). That’s very impressive, thank you. I’ll follow it through carefully. Good viideo! ---
**Author:** ![got10thumbs](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/got10thumbs/32/36638_2.png) [@got10thumbs](https://community.glideapps.com/u/got10thumbs)\ **Post date:** [January 31, 2022, 5:24pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/23 "2022-01-31T17:24:20Z")
Thank ou. Very impressive, I hadn’t thought at all of that approach. I replicated it and it all worked beautifully, except that I didn’t understand how you make the initial set up. At 0:49 there’s only one row, and then by 0:50 there are loads of rows and the first row of column 1 is repeated all the way down. How did you do that? And the same with the rowNumber column; it’s a \<\> column, which seems to mean a code column, but I can’t find anything that generates the row number. In the video you appear to be pressing New Row repeatedly and the next row appears with the row number and the start text just appearing automatically. Everything else makes sense, except for bringing in the users: is that so that each user can do their own analysis? I hadn’t looked that far ahead. BTW about sentences: if you split on ‘period followed by space’ you presumably have a problem with sentences that end a paragraph and are immediately followed by return. Of course, you’re right about periods marking abbreviations like ‘Mr’, not to mention the other marks that you also mention. And then there are ellipses marked as three dots ‘…’. Nothing about language is easy! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 1, 2022, 6:07am UTC](https://community.glideapps.com/t/words-per-sentence/37896/24 "2022-02-01T06:07:45Z")
> [@got10thumbs](#): > > At 0:49 there’s only one row, and then by 0:50 there are loads of rows and the first row of column 1 is repeated all the way down. How did you do that? - Start with a RowID column - Add a Lookup column, that targets the RowID column. This will give you an array of all RowID’s - Add a [Find Element Index](https://www.glideapps.com/plugins/index-in-array) column, that searches for the RowID in the Lookup column. You should get an auto-incrementing number, beginning at zero. ---
**Author:** ![got10thumbs](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/got10thumbs/32/36638_2.png) [@got10thumbs](https://community.glideapps.com/u/got10thumbs)\ **Post date:** [February 1, 2022, 9:52am UTC](https://community.glideapps.com/t/words-per-sentence/37896/25 "2022-02-01T09:52:51Z")
That’s very ingenious. Thanks Darren! I would never have invented that. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 1, 2022, 12:49pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/26 "2022-02-01T12:49:34Z")
We didn’t invent it either…it was featured as a reply to a recent post of mine: > [@RowID is great. Could REALLY use Row Number](https://community.glideapps.com/t/rowid-is-great-could-really-use-row-number/16834): > > Yes, this can be added in Google Sheets…would rather have a native solution. Just a simple 1 through X where X is the number of rows in the table. This would work REALLY well with the Single Value column. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 1, 2022, 1:35pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/27 "2022-02-01T13:35:55Z")
yeah, this one is a bit of game changer. It’s been less than a week and I’ve already found several uses for it. All kudos to @11183 - a really simple and elegant solution 👍 ---
**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\ **Post date:** [February 1, 2022, 2:54pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/28 "2022-02-01T14:54:04Z")
Okay, does anybody know how to change username here?) I’m becoming famous)) ---
**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\ **Post date:** [February 1, 2022, 2:57pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/29 "2022-02-01T14:57:46Z")
Speaking seriuosly, i was thinking a lot about this problem, even though i personally don’t need it in my apps. That was just kind of an interesting challenge. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 1, 2022, 3:02pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/30 "2022-02-01T15:02:10Z")
It’s incredibly useful when used in combination with the array-transpose method. ---
**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\ **Post date:** [February 1, 2022, 3:05pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/31 "2022-02-01T15:05:40Z")
Yeah, i actually thought about it. Smth like: 1. Fetching JSON 2. Formatting it 3. Split to array 4. Transpose Sounds like dynamically self-filling table) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 1, 2022, 7:14pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/32 "2022-02-01T19:14:30Z")
> [@11183](#): > > Sounds like dynamically self-filling table) Exactly: > [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766): > > I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc) ---
**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\ **Post date:** [February 1, 2022, 10:12pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/33 "2022-02-01T22:12:05Z")
That method is truly pure miracle) So as all of your ideas and solutions. Big fan of your tutorial videos, watched them all) Keep going💪🏻 ---
**Author:** ![Valdir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valdir/32/37658_2.png) [@Valdir](https://community.glideapps.com/u/Valdir)\ **Post date:** [February 19, 2022, 5:04pm UTC](https://community.glideapps.com/t/words-per-sentence/37896/34 "2022-02-19T17:04:57Z")
Really 👏👏👏 ---
**Author:** ![habao213](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/habao213/32/33067_2.png) [@habao213](https://community.glideapps.com/u/habao213)\ **Post date:** [March 26, 2022, 9:42am UTC](https://community.glideapps.com/t/words-per-sentence/37896/35 "2022-03-26T09:42:01Z")
Hi, How to separate into different rows when using joined list? I want to join different comments from users, and show them in the report screen. Exp: Turn this " abc, def, ghi" to abc def ghi @ThinhDinh @Darren_Murphy @Robert_Petitto Thanks. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 26, 2022, 9:51am UTC](https://community.glideapps.com/t/words-per-sentence/37896/36 "2022-03-26T09:51:12Z")
Just change the separator when you create your joined list. Instead of using a comma, use a CRLF (carriage return line feed). ---
**Author:** ![habao213](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/habao213/32/33067_2.png) [@habao213](https://community.glideapps.com/u/habao213)\ **Post date:** [March 26, 2022, 9:59am UTC](https://community.glideapps.com/t/words-per-sentence/37896/37 "2022-03-26T09:59:58Z")
I try this but It did not work. What’s separator I need to type in? Thanks @Darren_Murphy ![break new line](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/b/1b725d01f6249e8f55a041dd56a2ddcad28d61fa.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 26, 2022, 10:16am UTC](https://community.glideapps.com/t/words-per-sentence/37896/38 "2022-03-26T10:16:51Z")
No, just use the enter key. So it will look something like this: ![Screen Shot 2022-03-26 at 6.16.00 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/2/72cf5cf27da551654decf55d92445d8d7a8cf0fc.png) ---
**Author:** ![habao213](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/habao213/32/33067_2.png) [@habao213](https://community.glideapps.com/u/habao213)\ **Post date:** [March 26, 2022, 10:28am UTC](https://community.glideapps.com/t/words-per-sentence/37896/39 "2022-03-26T10:28:24Z")
Thank you. I did it, such a simple solution :)) ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 27, 2022, 10:28am UTC](https://community.glideapps.com/t/words-per-sentence/37896/40 "2022-03-27T10:28:28Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed. [Previous page](https://community.glideapps.com/t/words-per-sentence/37896.md?page=1)