Author |
Message |
ramz003
Newbie
Joined: 15 Aug 2012
Online Status: Offline
Posts: 16
|
Topic: Split Delimiter Posted: 23 Aug 2012 at 5:02am |
I need to split a table (named {xxx__ITS_REPORT_SCHED.ITS_GROUPS} )
This field might only include one word or it might include multiple words separated by commas.
What would be the best way to split this words into its own field?
Thanks
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 23 Aug 2012 at 5:07am |
|
IP Logged |
|
ramz003
Newbie
Joined: 15 Aug 2012
Online Status: Offline
Posts: 16
|
Posted: 23 Aug 2012 at 5:24am |
Thanks for the reply.
That didnt work for me. The field I'm using is a group field. I got error messages on that code.
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 23 Aug 2012 at 5:35am |
please explain more exacly what the content is and how what you want to do with it. Being a 'group' does not explain any error as it still should just be text.
|
IP Logged |
|
ramz003
Newbie
Joined: 15 Aug 2012
Online Status: Offline
Posts: 16
|
Posted: 23 Aug 2012 at 5:43am |
I have a crosstab report that I'm working on. In one of the rows is a table that could have multiple selections in it. I want to break this down based off the comma between the data.
With the code from the link I got the follow error message.
Group specified on a non-recurring field.
Details: @its groups
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 23 Aug 2012 at 6:04am |
what do you mean you want to break it down?
The row will still only exist once and only fall into one grouping. Splitting it does not make it split into extra rows that can be grouped independently of each other. You can split it into multiple formula fields that reside on that smae row but it can only dall into oen group.
|
IP Logged |
|
ramz003
Newbie
Joined: 15 Aug 2012
Online Status: Offline
Posts: 16
|
Posted: 23 Aug 2012 at 6:49am |
Right now it groups it like this.
Application
Application, Business Solutions
Application, Business Solutions, DBA/Systems
Application, Business Solutions, DBA/Systems,Operations
Application, Business Solutions, DBA/Systems,Operations, Records
I want to break those down individually.
Application
Business Solution
DBA/Systems
Etc
etc
|
IP Logged |
|
ramz003
Newbie
Joined: 15 Aug 2012
Online Status: Offline
Posts: 16
|
Posted: 24 Aug 2012 at 10:50am |
Join (Split ({xxx__ITS_REPORT_SCHED.ITS_GROUPS}, ","),chr(13))
This works but puts in the same field and I want its own individual field so I can group.
Edited by ramz003 - 24 Aug 2012 at 10:50am
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 24 Aug 2012 at 11:17am |
I am still confused. You can break these into different fields but the row can only be assigned to one grouping so there is no value gained by splitting them.
Edited by DBlank - 24 Aug 2012 at 11:17am
|
IP Logged |
|
|