Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a data like
. ashrfg.23.sdfre.re34
.rewr.t443.trtr4.34.erwer.234.343fe
.we332.werwe343.sgs434.w4rwd.34gfh34gfh.ert34.rw
here i want to delete first delimiter (.) and i want the data like
ashrfg.23.sdfre.re34
rewr.t443.trtr4.34.erwer.234.343fe
we332.werwe343.sgs434.w4rwd.34gfh34gfh.ert34.rw
please help me
Regards,
Pradeep K
Try this.
if(Left(FieldName,1)='.', Mid(FieldName,2), FieldName) as F2;