Remove Hyphen from the database

[Anonymous]

Hello Everyone,

I have the data where it mention as,  i want to prepare a pivot table where dimension will be my design no with out Hyphen.

DESIGN_NO	SALES QTY
1425895-EE	1
14532861-FD	2
58462879999-FF	5
1425895-EF	4
1425895-EG	8
1425895-DD	9
14532861-FF	10
58462879999-FA	1

How to get the data without hyphen,

After Removing of Hyphen,  

Row Labels	Sum of SALES QTY
1425895	22
14532861	12
58462879999	6
Grand Total	40

[avinashelite]

You could use it in both the front end and script level ...Script end is the most preferred one

[its_anandrjs]

You can try this

On UI you can do

Dimension :- Subfield( DESIGN_NO,'-',1 ) 

Expression:- Sum( [SALES QTY] )

On Load Script

Load

Subfield( DESIGN_NO,'-',1 ) as DESIGN_NO,

[SALES QTY]

From Location;