how do i split my text into separate data so I have my ACTIVE, ABANDONED, REMOVED, NOT IN USE, etc
I used text match to create a true false list, then run that thru cull pattern on the list and you get the resulting list. This also helps if you need to know which index number matches which pattern you want.
If you post your (partial) data, it’ll be a lot easier to help you.
ive posted the whole data and an example of my outcome in another post here:Circular data Visualization