Parse Clipboard Data with Python
Budget: $30 – $250 USD
Seeking honest, English speaking and experienced Python programmer for this easy project.
To prevent automated bid bots, please mention the work "Bluebird" in your bid! If you do not mention this word "Bluebird", your bid will be deleted. Reasonable Bids ONLY!!
If you have any questions, problems or suggestions, please let me know. Thanks!!
Successful completion can lead to future py projects! Thanks for your consideration!
I would like a py program to parse the clipboard input (see attached files) and save ouput to a .txt file entitled appOutput.txt(see attached files) onto the desktop. I have listed some observations and guidelines below:
1) The source page input (and the clipboard input) has up to 100 rows and seem to be divided into three tables:
a) SKU column data (see screenshot in attached file and #3 below).
b) Listing Title thru Condition data (multiple columns) (see screenshot in attached file and #4 below).
c) Status column data (see screenshot in attached file and #5 below).
2) All output data should be separated by a comma ',' .
3) The Sku column data should be saved as:
a) 7500-43-03-817,
b) B003F674AU,
c) MFN or FBA
d) saved to output example: 7500-43-03-817, B003F674AU,MFN,
4) The second section Listing Title thru Condition columns should be saved as:
a) Cost if 'Not Set', should be saved as 'none'. If there is a Cost listed, please remove the 'THB' and save as a decimal.
b) Save Min as a decimal without the $ or Manual attached.
c) Save Max as a decimal without the $ or Manual attached.
d) Save Your Price as a decimal without the $ attached.
e) Save Velocity as an integer. If 0, save '0'.
f) Save Stock as an integer.
g) For Condition, prepend used conditions with 'u'. Examples are save: used like new as 'ulike new', used very good as 'uvery good', used good as 'ugood', and used acceptable as 'uacceptable'. For New items, prepend with 'n', so output example would be 'nnew'. For collectible items prepend with 'c'. Examples are save: collectible like new as 'clike new', collectible very good as 'cvery good', collectible good as 'cgood', and collectible acceptable as 'cacceptable'.
h) saved to output example: None,23.29,27.29,31.48,0,1,ulike new,
5) Save the status string.
a) saved to output example: Live
6) The first row of the page/ input would be saved to the file as:
7500-43-03-817,B003F674AU,MFN,None,23.29,27.29,31.48,0,1,ulike new,Live
(this can also be seen in the first row of the attached output file sample along with the second and third row of output).
If you have any questions, problems or suggestions, please let me know. Thanks!!
To prevent automated bid bots, please mention the work "Bluebird" in your bid! If you do not mention this word "Bluebird", your bid will be deleted. Reasonable Bids ONLY!!
If you have any questions, problems or suggestions, please let me know. Thanks!!
Successful completion can lead to future py projects! Thanks for your consideration!
I would like a py program to parse the clipboard input (see attached files) and save ouput to a .txt file entitled appOutput.txt(see attached files) onto the desktop. I have listed some observations and guidelines below:
1) The source page input (and the clipboard input) has up to 100 rows and seem to be divided into three tables:
a) SKU column data (see screenshot in attached file and #3 below).
b) Listing Title thru Condition data (multiple columns) (see screenshot in attached file and #4 below).
c) Status column data (see screenshot in attached file and #5 below).
2) All output data should be separated by a comma ',' .
3) The Sku column data should be saved as:
a) 7500-43-03-817,
b) B003F674AU,
c) MFN or FBA
d) saved to output example: 7500-43-03-817, B003F674AU,MFN,
4) The second section Listing Title thru Condition columns should be saved as:
a) Cost if 'Not Set', should be saved as 'none'. If there is a Cost listed, please remove the 'THB' and save as a decimal.
b) Save Min as a decimal without the $ or Manual attached.
c) Save Max as a decimal without the $ or Manual attached.
d) Save Your Price as a decimal without the $ attached.
e) Save Velocity as an integer. If 0, save '0'.
f) Save Stock as an integer.
g) For Condition, prepend used conditions with 'u'. Examples are save: used like new as 'ulike new', used very good as 'uvery good', used good as 'ugood', and used acceptable as 'uacceptable'. For New items, prepend with 'n', so output example would be 'nnew'. For collectible items prepend with 'c'. Examples are save: collectible like new as 'clike new', collectible very good as 'cvery good', collectible good as 'cgood', and collectible acceptable as 'cacceptable'.
h) saved to output example: None,23.29,27.29,31.48,0,1,ulike new,
5) Save the status string.
a) saved to output example: Live
6) The first row of the page/ input would be saved to the file as:
7500-43-03-817,B003F674AU,MFN,None,23.29,27.29,31.48,0,1,ulike new,Live
(this can also be seen in the first row of the attached output file sample along with the second and third row of output).
If you have any questions, problems or suggestions, please let me know. Thanks!!