|
-
August 25th, 2009, 08:32 AM
#1
Extracting parts of a string
I have a string like the following...
00009 / Ivory / 3-5
00009 is the style
Ivory is the color
3-5 is the size
I need to create a Color and a Size formula. I can easily get the style by LEFT({icitem.desc},5) BUT...
How would I get the color? The size? How would I create a formula that would use the "/" as the delimiter and extract after it?
As always, any help here is GREATLY appreciated!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|