Excel Automation: Practice Book Sales Report
You’ll notice that the extracted price contains the “£” symbol. This will result in an error when trying to do mathematical calculations. You will need to modify the extracted values to remove the symbol. There’s an activity just for that called Modify Text . You can find it under Common activities.
I do no have this in StudioX. Is anyone else having the same issue? Or a suggestion on a work around? I am currently trying to use replace text.