Desktop productivity for business analysts and programmers

Text to Column using EG

Reply
Contributor
Posts: 20

Text to Column using EG

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?

Super User
Posts: 19,193

Re: Text to Column using EG

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. 

Contributor
Posts: 20

Re: Text to Column using EG

Perfect! That is what I was looking for Reeza. I need to remember the SCAN function...Thanks!!
Ask a Question
Discussion stats
  • 2 replies
  • 246 views
  • 1 like
  • 2 in conversation