This can be done in many different ways. Below are fairly interactive methods
Starting table
![jthi_0-1706549582527.png jthi_0-1706549582527.png](https://community.jmp.com/t5/image/serverpage/image-id/60682i2CF0CD6FB008F70F/image-size/medium?v=v2&px=400)
Quick formula:
Right click on your column and take first word
![jthi_5-1706549850188.png jthi_5-1706549850188.png](https://community.jmp.com/t5/image/serverpage/image-id/60687i4F049B7EA5C3042E/image-size/medium?v=v2&px=400)
![jthi_6-1706549861282.png jthi_6-1706549861282.png](https://community.jmp.com/t5/image/serverpage/image-id/60688i44C1BDB1DEDE9EFE/image-size/medium?v=v2&px=400)
Using recode:
Select your column and go to Cols/Recode, find extract segment (could also use First word)
![jthi_1-1706549606414.png jthi_1-1706549606414.png](https://community.jmp.com/t5/image/serverpage/image-id/60683iED444FD6C209D45E/image-size/medium?v=v2&px=400)
Use slider to pick correct parts and check from bottom that you are getting correct result
![jthi_2-1706549641792.png jthi_2-1706549641792.png](https://community.jmp.com/t5/image/serverpage/image-id/60684iC536A3B4A5E0EF8B/image-size/medium?v=v2&px=400)
and you will end up with column like
![jthi_3-1706549668191.png jthi_3-1706549668191.png](https://community.jmp.com/t5/image/serverpage/image-id/60685iA17FDABFF10A2CFA/image-size/medium?v=v2&px=400)
Getting the text:
You can then repeat the recode process to create other column or create a column which substitute the newly created values from original column with missing string (might want to add extra space there or wrap it with Trim Whitespace() function)
Substitute(:Column 1, :Column 1 2, "")
![jthi_4-1706549784298.png jthi_4-1706549784298.png](https://community.jmp.com/t5/image/serverpage/image-id/60686i1B45D08F45D97A66/image-size/medium?v=v2&px=400)
-Jarmo