Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If all colors follow that pattern: number followed by the text, you should be able to:
=mid(myfield, index(myfield, ' ')+1)
-Rob
if ' ' is always there
=subfield('001 Black', ' ', 2)
replace '001 Black' with your field
What if the color is "002 Dark Blue"?
Dark
or
Error
?
I meant to point out that the subfield() method wouldn't work with a multi-word color
-Rob
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.
yes, for a one word color my answer works, for a multi-word it doesn't, it's an Error
Dear Rob,
this was very helpful input. It solved my problem.
Many thanks
Patrick