Expression issue

[#1]

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

[swuehl]

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.

[MayilVahanan]

hi,

Try this,

if(Right(Left(Field,3),1) = '.', Mid(Field,4), Field)

Hope it helps

[rwunderlich]

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