Link to home
Start Free TrialLog in
Avatar of tomfolinsbee
tomfolinsbee

asked on

Modify script for transforming Excel spreadsheet to database format

This is follow up question to solution posted by faustulus:
https://www.experts-exchange.com/questions/28249913/Script-to-Transform-Excel-spreadsheet-into-tables.html?anchorAnswerId=39545380#a39545380

I would like to modify the script in this spreadsheet to take into account a new column (PartID) inserted into the Source sheet.

This PartID should be used in the other three output sheets, in the same way that the part name.

Thank you!
Avatar of tomfolinsbee
tomfolinsbee

ASKER

ASKER CERTIFIED SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Dear Faustulus, Many thanks for the excellent script. It worked perfectly first time on the full dataset. Apologies for the late reply, got tied up with other projects. Again, thank you!
Faustulus, could I trouble you to make one more change? In the script, I think there is some code that replaces hard returns within a cell with a " - ".   Is it possible to modify the script so that the part name remains exactly the same as the source document?  

p.s. The reformatting looks much better, but I'm going to ask my colleague to clean up his source file instead.

p.s.s.  Can I just comment out the part of the script that substitutes the hard return for " - "?

Thanks!
If there is no return there will be no effect.
If there is a return there will be a problem if it goes untreated.
I can remove the code that does the substitution, but the effect is unlikely to be an improvement.