Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=replace('abc-123-w312','-','')
Please use this.
Load
replace('Column','-','') as Column1
;
Replace is fine. Another option is purgechar:
purgechar(FieldName, '-')
Hi Pooja2010 ,
try like this..
LOAD
subfield(ColumnName,'-',1) & subfield(ColumnName,'-',2) & subfield(ColumnName,'-',3) as NewColumName
FROM SourceFile;
Thanks all for your quick replies.wow..there are so many ways to do this.