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
Solved! Go to Solution.
Hi @sagar91,
Please check my really simple solution.
(\<\w+\>,\<\w+\>,\<\w+\>,\<\w+\>)
Basically It will show first 4 words
thank you for the solution 🙂