Column 1: 250 names: Column 2 only the last 4 characters of

[Dinictus]

hi,

I want to create 4 character login names from a column with 250 adressen. Example:

column 1: Miss L. chackenbackerslacher
Column 2: acher

Column 1: mrs P. diddy
Column 2: iddy


The point is, not all names have the same length otherwise I could just pull a simple substring.

I tried working with the mid function but this only works from position 1. I looking for a "reverser" (start at end) mid function or something.


To be honest: If I`d put some effort in it, I could figure this one myself of course. But I know that there are users here who can just dream codes like these. It wil save me a lot of time so I owuld be gratefull if someone would help me out.

Cheers,
Dinictus.
This message was edited by Dinictus on 2002-03-27 02:13
This message was edited by Dinictus on 2002-03-27 02:27

 

[Dave Hawley]

Have you tried the RIGHT Function?

 

[Dinictus]

OMG,

I will go and be ashamed the rest of the day now. Sometimes you make things more difficult then they really are.

thanks.
Din.

 

[Chris Davison]

I dated a Miss L Achenbackerslacher, actually....


anyhow, :wink:

are you okay if you have 2 Mr Smiths or a number of Miss Whites etc etc etc....