kpradeep5610
Contributor III
2020-06-26
02:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Tags:
- the
471 Views
1 Reply
settu_periasamy
Master III
2020-06-26
02:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this.
if(Left(FieldName,1)='.', Mid(FieldName,2), FieldName) as F2;
461 Views