Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
Not applicable

Formatting

I have a varchar2 field which is like 'abc-123-w312'.I want to dispaly it as ''abc123w312'.Kindly let me know what syntax needs to be used in the qV load to get this format.

Thanks,pooja

5 Replies
Not applicable

Formatting

=replace('abc-123-w312','-','')

Please use this.

Not applicable

Formatting

Load

replace('Column','-','') as Column1

;

mov
Esteemed Contributor III

Formatting

Replace is fine. Another option is purgechar:
purgechar(FieldName, '-')

Not applicable

Formatting

Hi Pooja2010 ,

try like this..

LOAD

subfield(ColumnName,'-',1) & subfield(ColumnName,'-',2) & subfield(ColumnName,'-',3) as NewColumName

FROM SourceFile;

Not applicable

Formatting

Thanks all for your quick replies.wow..there are so many ways to do this.

Community Browser