Joined: 22 Jan 2013
Online Status: Offline
Posts: 89
Topic: Stripping Charachters Posted: 20 Aug 2018 at 11:25am
I have a field that I want to do a formula on to strip the field to only giving me back 3 characters that are within the field.
It is not in the same place at all times.
Example:
00CH006&&&
20%CH004
I want to always return only the 3 values 'after' the H in this field so that my result looks like 006 on the first record and 004 on the second record.
I know I have seen this done before and cannot find it anywhere so your help is much appreciated.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum