Print Page | Close Window

Split Delimiter

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17398
Printed Date: 05 May 2024 at 2:23pm


Topic: Split Delimiter
Posted By: ramz003
Subject: Split Delimiter
Date 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


Replies:
Posted By: DBlank
Date Posted: 23 Aug 2012 at 5:07am
http://crystalreportsbook.com/Forum/forum_posts.asp?TID=17377 - http://crystalreportsbook.com/Forum/forum_posts.asp?TID=17377

Posted By: ramz003
Date 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.

Posted By: DBlank
Date 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.

Posted By: ramz003
Date 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

Posted By: DBlank
Date 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.

Posted By: ramz003
Date 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

Posted By: ramz003
Date 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.

Posted By: DBlank
Date 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.



Print Page | Close Window