String Format to remove last two records

[sagar91]

Hi , 

record id      Collumn1

1                  True,True,False,True,True,Some,No

2                  True,True,True,True,True,Most of it,No

i have these two records and trying to remove last two words Some,No & Most of it,No from collumn1. What would be the solution for it ?

i know regex is there but not sure what RE should I use

[Emil_Kos · Accepted solution]

Hi @sagar91,

Please check my really simple solution.

(\<\w+\>,\<\w+\>,\<\w+\>,\<\w+\>)

Basically It will show first 4 words

[Luke_C · Accepted solution]

Here's a no-formula solution that would work for any number of words. It essentially splits each word into a row, and removes the last 2 rows for each record.

[sagar91]

thank you for the solution 🙂