Topic: String Manipulation Posted: 25 Jul 2007 at 12:24pm
I have a field that contains the following types of string records:
0;7;3
3;18;21
744;44;544
70;887;337
524;721;921
638;68;448
The above six records represent just some of the data in the field. What I want to do is separate the values in each record in an expression that holds the characters seperated by the semi-colon as follows:
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 25 Jul 2007 at 5:07pm
You can use the Split() function to separate them into an array. Then use values in the array to do whatever you wish with them.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
