Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last 9 characters

Status
Not open for further replies.

Cpreston

MIS
Mar 4, 2015
972
GB
Hi

I am trying to get a formula that will show the last 9 digits of a block of text.

The reason being our system brings out delivery address as one block of text. I think they have carriage returns for each line.
However, the last 9 digits is always the Post Code which is what I need. I am trying to find Unique counts so need something like the postcode to do this.

I have played with the below but this is bringing out all sorts of result.

Right({148_vwjourneyplannerCP.DeliveryAddress},len ({148_vwjourneyplannerCP.DeliveryAddress})-40)

Could someone let me know the correct code to be using please.

Many Thanks

 
HI

All of managed to work it out

Right({148_vwjourneyplannerCP.DeliveryAddress},9)

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top