Form JSON type to String

Automation Studio
1

Hello there,

i have a problem in the read file activity. My problem is that i want to read a .txt file and write the output to an excel file.
My First problem is that i need the JSON output as a String.

Second problem the .txt file has name, surname, City, Street and is separated by “,”. I must write all data in an own excel row. how can i split these from each other.

I hope theres somebody who can help. Thanks a lot.

2

Hi,

Once you get read file then you will get json. You will have too parse json using JSON Activity Getter Action and output it to a argument. You can write argument value then to excel

Regards,
Amit Anand

1 Like
3

Thanks for the answer. I will try it immediately.