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.
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:
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:
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.
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:
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.
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:
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.
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 it could use some more features for combining orders and delta operations
from a "wanted" list, but I need to play with it first. Thanks!!!
USA, Idaho
