Double Quotes Issue convert xlsx to tab delimited (.txt file)

[Vicky_K]

Hi Friends i have issue while converting Excel to .txt file, Double quotes are appear in txt file.
you can see it in attached screen shot, Give me any idea to clear this problem.

Thanks in advance

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Vicky_K

You could read excel and use the output data table activity to convert data table to string and write it in a text file.

[Vicky_K]

Same issue happens while using your logic.

[Karan_Zaveri]

Hi @Vicky_K
after you read the excel file and store in datatable variable.
use output datatable activity to convert to string.
then use replace function to replace all " symbols with nothing.
Eg} strInput.Repalce(“”“”,“”)

Hope this will work and you find your solution.
Regards
karanzaveri

[Vicky_K]

Thanks for your help