Author: | 62Bricks | Posted: | Jun 6, 2015 22:43 | Subject: | Re: Orders Download Feature | Viewed: | 38 times | Topic: | Suggestions | |
|
| In Suggestions, jeffmcclain writes:
| 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.
|
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 Brickstock XML into excel than to run regex on the Bricklink file.
|
|
Message is in Reply To: Re: Orders Download Feature - jeffmcclain (270) | [...] 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 [...] (110 months ago, Jun 6, 2015, to Suggestions) |
Message Has 1 Reply: Re: Orders Download Feature - jeffmcclain (270) | [...] Thank you! I need to spend some time with this, but this looks pretty helpful, actually. Might have saved me some time/money placing my custom sets orders. I think [...] (110 months ago, Jun 8, 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
|
|