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
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
