Dots in csv file

Gauthami_Viswanathan · June 25, 2021, 10:22am

Hi,

When i open a csv file which i generated using the Spreadsheet and Write Binary file nodes. I see 3 dots in the first line. This is causing a problem with one of my other applications. Can you suggest how i can remove them.

Thanks

harshil1712 · June 25, 2021, 7:43pm

Hey @Gauthami_Viswanathan!

Can you share your workflow? Feel free to replace any sensitive data from your workflow

Gauthami_Viswanathan · July 6, 2021, 11:43am

I got it resolved thanks

harshil1712 · July 6, 2021, 1:56pm

Hey @Gauthami_Viswanathan!

That’s wonderful! Can you please share the solution? This will help others with the similar problem

Gauthami_Viswanathan · July 6, 2021, 2:36pm

Hi

used the below command in execute node
sed -i ‘1s/.//’ filename
then i was able to remove the dots

harshil1712 · July 6, 2021, 2:38pm

Thank you for sharing the solution