[CLOSED] hi Remove "-" from data

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4067075016

October 03, 2011, 02:06 AM

Deepu

[CLOSED] hi Remove "-" from data

Hi

i have field data like this
col_data(A120v)
1000548-00000-0000
0000000-00023-1258
0000000-12564-1188

i want to remove "-" from data
output data
1000548000000000
0000000000231258
0000000125641188

can any one help me plz

This message has been edited. Last edited by: Kerry,

WebFOCUS 7.6
Windows, All Outputs

October 03, 2011, 05:07 AM

atturhari

Use STRREP function

WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML

October 03, 2011, 08:38 AM

George Patton

This is really basic stuff. All the dashes occur in the same place.

RTFM and look up the EDIT command.

OUTFIELD/A16=EDIT(INFIELD, '999999$99999$9999')

This message has been edited. Last edited by: George Patton,

WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP