Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have following data as
00
01.01
01.02.01
02.02.02
02.02.03
but i want see this kind of output
00
01
02.01
02.02
02.03
Please help me out
Probably you can simplify it a bit, I tried to create a more generic approach:
=Left('01.02.03.04.05',2)&mid('01.02.03.04.05',3,3*(SubstringCount('01.02.03.04.05','.')-1))
resp.
=Left(FIELD,2)&mid(FIELD,3,3*(SubstringCount(FIELD,'.')-1))
edit:
Need to get my eyes checked. Just noticed that my expression will return the left part of your sample data, that's not what you asked for.
hi,
Try this,
if(Right(Left(Field,3),1) = '.', Mid(Field,4), Field)
Hope it helps
How about:
=mid(X, index(X,'.')+1)
You'll probably want to wrap a text() around it so the results display left justified.
=text(mid(X, index(X,'.')+1))
-Rob