Strip Away Extra Character

[jmonroe918]

How do you strip away a character that precedes the data in a field? Example: Item_No field has items, all in the format *12345. I want to remove the * at the load.

Thanks.

Jeff

[Anonymous · Accepted solution]

use purgechar() function

purgechar(Item_No, '*') as Item_No

[#3]

See attached.

subfield(YourFieldName, '*', 2)

[jmonroe918]

Thank you Michael.

[Anonymous]

No problem, here is another way, just starting from the 2nd position of the string:

mid(Item_No, 2) as Item_No