Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kpradeep5610
Contributor III
Contributor III

delete first delimiter in a data

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

 

1 Reply
settu_periasamy
Master III
Master III

Try this.

if(Left(FieldName,1)='.', Mid(FieldName,2), FieldName) as F2;