Changing Words in a Text File

Help
1

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…

2

@cem_kayaturk

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")
3

Hi ,
Welcome to UiPath Community !

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

Regards
Balamurugan.S