Data separated by ~'s

		Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Data separated by ~'s

Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

September 22nd, 2009, 08:44 AM

llunde

Registered User

Join Date: Sep 2009

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Data separated by ~'s

When I get the data for shop load from my database it separates the information with a ~.

Example

Job Load hours Load days Start date
1548 2.5~5~5~2.5 3909~3910~3911~3912 9/14/09
1236 3~5~5 3910~3911~3912 9/15/09
1357 1 3912 9/17/09

I need to be able to separate the load out by day and then total the hours for each day.
Also I need to convert the load days number to a normal date.
I am a novice with Crystal so any help will be greatly appreciated!
LL

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
splitting up items separated by semicolon	Condor76	XSLT	1	March 17th, 2008 05:14 PM
Comma Separated values	aldwinenriquez	SQL Server 2005	3	June 1st, 2007 08:52 PM
comma separated list	MunishBhatia	SQL Server 2000	11	March 21st, 2007 03:56 PM
Comma Separated Column Value thru T-SQL	subhendude	SQL Server 2000	2	December 12th, 2006 01:42 PM
Select from Comma Separated Values	sasidhar79	SQL Server 2000	2	March 28th, 2005 06:58 PM