Text to Column using EG

[gregor1]

I ran a query that returns a column of data that I want to go from text to column (much like I can do in Excel).  For example, the returned data looks like this: "NV District 600" (all listed as one piece of data in a single column).  However, I really only want the "NV" as a single piece of data in it's own column, the "District" as another piece of data in it's own column, and the "600" as a single piece of data in it's own column.  What is the best way to accomplish this in EG?

[Reeza]

If you have a clear delimiter I'd use the scan function. 

You can create a calculated column in query builder and use scan function. 

If your data will have a variable number of items, a different method will be required. 

[gregor1]

Perfect! That is what I was looking for Reeza. I need to remember the SCAN function...Thanks!!