shrinivasmj
New member
- Joined
- Sep 18, 2012
- Messages
- 3
- Reaction score
- 0
- Points
- 0
hi,
I need to Reverse Name with some condition ,
need to break the name in half part and reverse the name with comma ,and need to take dot as one word like EG- shrinivas m.j. are 3 words .
1 to 3 words reverse last word
> 4 to 5 words reverse last 2 words
> 6 to 7 words reverse last 3 words
Eg shown below
INPUT NAME OUTPUT NAME
PLEASE FIND THE OLD FORMULA USED,BUT TAKING DOT IN REVERSE AND GIVING SPACE AFTER DOT.
=UPPER(LEFT(TRIM(RIGHT(SUBSTITUTE(TRIM(N68)," ",REPT(" ",99)),(1+(LEN(N68)-LEN(SUBSTITUTE(N68," ",""))>2)+(LEN(N68)-LEN(SUBSTITUTE(N68," ",""))>4))*99))&","&N68,LEN(N68)))
I need to Reverse Name with some condition ,
need to break the name in half part and reverse the name with comma ,and need to take dot as one word like EG- shrinivas m.j. are 3 words .
1 to 3 words reverse last word
> 4 to 5 words reverse last 2 words
> 6 to 7 words reverse last 3 words
Eg shown below
INPUT NAME OUTPUT NAME
N. Yulia Worbe | WORBE,N. YULIA | ( Need to take space after Dot N. ) |
Gerardin N. T. | T,GERARDIN N. | |
N. T. Andreas | ANDREAS,N. T. | |
n.t. Romain | ROMAIN,N.T. | ( No Space After Dot N.T. ) |
Marie Chupin P.L.N. P. | L.N. P,MARIE CHUPIN P. | |
P. L. O. P. Leon Tremblay | P. LEON TREMBLAY,P. L. O. | |
Marie Vidailhet N. | N,MARIE VIDAILHET | |
Olivier Colliot K. T. P. | T. P,OLIVIER COLLIOT K. | |
S.S. Arba | ARBA,S.S. |
PLEASE FIND THE OLD FORMULA USED,BUT TAKING DOT IN REVERSE AND GIVING SPACE AFTER DOT.
=UPPER(LEFT(TRIM(RIGHT(SUBSTITUTE(TRIM(N68)," ",REPT(" ",99)),(1+(LEN(N68)-LEN(SUBSTITUTE(N68," ",""))>2)+(LEN(N68)-LEN(SUBSTITUTE(N68," ",""))>4))*99))&","&N68,LEN(N68)))