4 Replies Latest reply: Jan 8, 2016 12:14 PM by Ron Payne RSS

    Trimming Data Out of Inconsistent Character Lengths

    Ron Payne

      Hello All,

       

      Any ideas on how I can cut the numbers starting with '62*' out of these multi-character length strings? the field is "The Key" in the attached qvw. There is a lot of inconsistencies in these strings, and i was hoping there was another way other than trim() or len() to determine where to start cutting. The result should look like what's found in the field "The Answer" with just 6 digits. I used the Mid() Excel function to get "The Answer". Any help would be much appreciated.

       

       

       

      Thanks a lot!