the title is a phrase we had used a while back -- reminding us to not get smug on what we think we know .... lately we have no visions of excessive knowledge ... so many things to keep up to date with ... anyways here is a twist we had not seen ... updating our Marine line of X Line parts and had a hard time figuring out what the simple 'REPLACE' would not work -- CC Marine adds commas's in their description -- a sure death for the data ...since we use CSV format and the system will think it is time to move to the next column ... well ..answer --replace the ASTERISK first ... google replacing wildcards ( which is what Excel thinks an * is )New Marine prices - now ready to go --- all 22 thousand .... and ps -it didn't take the 24 minutes the image says .... but was a few minutes ... and I started typing this to pass the time.
Ps - have more time to type -- forgot to flag the bottom question --to UPDATE all descriptions ( not just the new parts ) ...why do we do this ... EXPLORIS ( Nexpart by eBay ) doesn't have any mechanism to flag parts that DID NOT UPDATE .... ( search this blog -- we have written about this glaring hole ) ... so you need to somehow identify parts that the supplier had dropped from their price list --but we still have in our system .... JCon did a pretty good job ...we think we have found a work around --as the YEAR as part of the description ...and the next time you dump the data --sort on the description to see what parts don't start with a '12-' ..then you need to MOVE these to a 999 PN CODE ( we use 999 as a trash bin for junk data in any ( and every !! )_ line .... as we await that wonderful day we can delete parts.
No comments:
Post a Comment