Excel script
Budget: $10 – $11 AUD
Hello,
We have an excel column with a lot of informations, also a price which we need to increase.
Here is sample from the text format found in a cell, there are more caracters then this actual sample. We need to find the value next to "price=", where we find a "-" increase the price with 25% ( on the bellow example would be 1210*1.25=1512.5) and replace the inial value. If after = there isn't a "-" we increase with 30%.
This should be done as a macro so we can run it anytime we need.
Before: 2 fara usi 80x15cm|name=Adauga dulapuri suplimentare,type=drop_down,required=1,price=-1210.000000,sku=,max_characters=0,file_extension=,image_size_x=0,image_size_y=0,price_type=fixed,option_title=Fara corpuri suspendate suplimentare
After: 2 fara usi 80x15cm|name=Adauga dulapuri suplimentare,type=drop_down,required=1,price=-1512.000000,sku=,max_characters=0,file_extension=,image_size_x=0,image_size_y=0,price_type=fixed,option_title=Fara corpuri suspendate suplimentare
We have an excel column with a lot of informations, also a price which we need to increase.
Here is sample from the text format found in a cell, there are more caracters then this actual sample. We need to find the value next to "price=", where we find a "-" increase the price with 25% ( on the bellow example would be 1210*1.25=1512.5) and replace the inial value. If after = there isn't a "-" we increase with 30%.
This should be done as a macro so we can run it anytime we need.
Before: 2 fara usi 80x15cm|name=Adauga dulapuri suplimentare,type=drop_down,required=1,price=-1210.000000,sku=,max_characters=0,file_extension=,image_size_x=0,image_size_y=0,price_type=fixed,option_title=Fara corpuri suspendate suplimentare
After: 2 fara usi 80x15cm|name=Adauga dulapuri suplimentare,type=drop_down,required=1,price=-1512.000000,sku=,max_characters=0,file_extension=,image_size_x=0,image_size_y=0,price_type=fixed,option_title=Fara corpuri suspendate suplimentare
Related categories:
Excel Macros