Changing Words in a Text File

Hello Everyone,

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.

Thank You…


Welcome to our uipath community.

  1. First Assign that entire text to one String variable.

  2. And then Use ReplaceAll method to replace all strings at a time.

      requiredStr = inputStr.ReplaceAll("nan","null")

Hi ,
Welcome to UiPath Community !

Can you share some sample format of the json ? It would helpful to give the solution…