Substring formula not workable

TimLiao
TimLiao Registered Posts: 14 ✭✭✭✭

Dears:

i use below formula

substring('business_unit_code',6,3) or substring(business_unit_code,6,3)

want to pick up information from one string atttached.(I hope to get MCC or MSL)

but not workable. i have no idea what's wrong.

Thank you for the help.

raw data.jpg

Best Answer

Answers

Setup Info
    Tags
      Help me…