topic Formatting in QlikView

Formatting

Wed, 30 Mar 2011 22:32:57 GMT

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

Formatting

Wed, 30 Mar 2011 22:50:53 GMT

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

Please use this.

Formatting

Wed, 30 Mar 2011 22:53:29 GMT

Load

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

;

Formatting

Anonymous — Thu, 31 Mar 2011 00:48:01 GMT

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

Formatting

Thu, 31 Mar 2011 06:25:46 GMT

Hi Pooja2010 ,

try like this..

LOAD

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

FROM SourceFile;

Formatting

Thu, 31 Mar 2011 22:40:13 GMT

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