Skip to Content
0
Former Member
Nov 20, 2012 at 03:53 PM

split one column into two columns

587 Views

Dear all,

I am using Crystal report 2011,I am getting values in column like

Column

6XXXXX

4XXXXX

6XXXXXX

6XXXXX

4XXXX

.

.

.

and so on...

I want to split this column into two columns; First column should have values starts with 6xxxxx and second column should have values starts with 4xxxx

Can someone please assist me how can I split??

Regards

Srinivas.