Author: | jeffmcclain | Posted: | Jun 6, 2015 22:08 | Subject: | Re: Orders Download Feature | Viewed: | 26 times | Topic: | Suggestions | |
|
| In Suggestions, chetzler writes:
| In Suggestions, jeffmcclain writes:
| Hello,
It would sure help out a LOT if in the "download orders" list, you could separate
out the "Item Description" to be 3 separate columns: Type (brick, plate, tile,
slope, etc), Description (1x3, round, etc.), and Color, rather than it all combined.
This would make it MUCH easier to pivot by item number, type, color, etc.
Thanks!
Jeff
|
I've had the same difficulty. I even asked about it here a while back but
surprisingly, I didn't get a single response:
http://www.bricklink.com/message.asp?ID=899185
|
I'm going to just have to put it through a perl REGEX match on that field
(duplicated) and match everything up to the color: s/^(.*?)(black|white|tan|blue|gray|red|yellow|orange|green).*/$1/i
As an example (that should get even "Light Bluish Gray" and "Dark Red", "Trans-Black",
etc...Then I'll match the first word left for the "item type" and leave the
rest.
|
|
Message is in Reply To: Re: Orders Download Feature - chetzler (2352) | [...] I've had the same difficulty. I even asked about it here a while back but surprisingly, I didn't get a single response: (URL) (110 months ago, Jun 6, 2015, to Suggestions) |
Message Has 1 Reply: Re: Orders Download Feature - 62Bricks (1455) | [...] Not sure what your exact needs are, but Brickstock fills in the color and type when you import orders, and all fields are sortable. Might be easier to import/export the [...] (110 months ago, Jun 6, 2015, to Suggestions) |
5 Messages in this Thread: Msg 1 - jeffmcclain (270) 110 months ago Jun 6, 2015 to Suggestions Msg 2 - chetzler (2352) 110 months ago Jun 6, 2015 to Suggestions Msg 3 « - jeffmcclain (270) 110 months ago Jun 6, 2015 to Suggestions Msg 4 - 62Bricks (1455) 110 months ago Jun 6, 2015 to Suggestions Msg 5 - jeffmcclain (270) 110 months ago Jun 8, 2015 to Suggestions
Entire thread on one page This message and all its replies on one page
|
|