I have a problem and I would like to know if the solution is possible with UIPath.
I have a text file containing JSON data collected from various sensors. I need to convert this JSON data to a CSV file in order to store and manipulate it in a hierarchic database. However, when the sensors are being programmed there was a mistake been made about the way it outputs null data. Basically it sends “nan” instead of “null” and I need a way to search for every “nan” in the text and change it into “null”.
Is there a way I can do this on UIPath? I am intermediate in this program. If you can show me the way, I believe I can do it on my own.