how to concatenate a string and make another string

vemisr · Post by **vemisr** » Mon Aug 30, 2010 9:31 am

HI experts.

i have an source values like this:

443022-PHPHOSP-1
41927-PHPHOSP-1
43155-PHPHOSP-1
444300-PHPHOSP-1

then i need to trim the first portion and re arranre the numbers like:

223044
27194
55314
004344

after trimming the first portion. then

this is the format i need:

last 2 numbers - next 2 number - next 2 number

thx
vemisr

anbu · Post by **anbu** » Mon Aug 30, 2010 9:45 am

You can use Field() and then substring function

arunkumarmm · Post by **arunkumarmm** » Mon Aug 30, 2010 10:32 am

Or you can use Substring alone...