seperate code from description

[#1]

I would like to remove a color code from its total description

Our color description is 001 Black and I would like to create a field only showing Black.

I tried to exclude this via the left function, but this leads not to the correct results.

thanks for your help in advance

Patrick

[rwunderlich]

If all colors follow that pattern: number followed by the text, you should be able to:

=mid(myfield, index(myfield, ' ')+1)

-Rob

[maxgro]

if ' ' is always there

=subfield('001 Black', ' ', 2)

replace '001 Black' with your field

[rwunderlich]

What if the color is "002 Dark Blue"?

[maxgro]

Dark

or

Error

?

[rwunderlich]

I meant to point out that the subfield() method wouldn't work with a multi-word color

-Rob

[sebastiandperei]

There are different posibilities, based on your data.

If your format is everytime: [code][space][color], I guess Massimo and Rob solutions are what you need (if you have multi-word colours, only Rob's one works)

If you haven't everytime ONE space between code and colour, you could use Mid(Purgechar(field,'0123456789'),1)

I think that if you send the different types of values you have, it wil be easier.

[maxgro]

yes, for a one word color my answer works, for a multi-word it doesn't, it's an Error

[#9]

Dear Rob,

this was very helpful input. It solved my problem.

Many thanks

Patrick