I'm sorry if i'm in a wrong subject for the topic since is the first time I write.

I have a field with text, e.g. "CSSS". Each character of the string is a number acording to a code. How can I create a script to automatically convert that text into is number.

example:

CSSS - 1 000

BSS - 300

CLS - 150

PS: sorry for my English ;)

Each character of the string is a number acording to a code.

Is it a number or a digit? Your examples don't make it clear enough. If it's a digit, you could use the Substitute() function (with 10 substitution pairs) to reconstruct the original number.

---

P.S. Please update your profile to reflect your version.

Is it a number or a digit? Your examples don't make it clear enough. If it's a digit, you could use the Substitute() function (with 10 substitution pairs) to reconstruct the original number.

---

P.S. Please update your profile to reflect your version.

I'm sorry, The version is FM10.

It's quite simple - CEBOLINHAS - stands for 1234567890.

I will try Substitute, and I'm tormenting myself not to remender that.

Thank you.

Do it in your Profile please. Here is a quick link to your Profile