06-23-2016 03:46 PM
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?
06-23-2016 03:54 PM
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.