Remove 1st Character 1

[YANKRAY]

Using CR10.

I have a field which contains Item Numbers.
At some point, item numbers were entered with a ^ preceeding the actual Item Number.

How can I create a formula that will remove the ^ from the beginning of an item number (only if there is one) and giving me the remainder of the string as the item number?

Examples:

Current Item Number result:

802167-29DLT
80317-ATT
^80414-DL4
^90225989-3

Requested Item Number result:

802167-29DLT
80317-ATT
80414-DL4
90225989-3

 

[IanWaterman]

@Trim

If left({YOurfield}, 1) = "^" then mid({YOurfiled}, 2, 20) else
{YOurfield}

Replace 20 with max size of your field

Ian

 

[YANKRAY]

Ian - Exactly what I needed. Thanks!