AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
3.6K members online now
3.6K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

too many delimiters at end of txt file

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

maybe I will find some help here...

I created a data feed by exporting all the product of my online shop as .csv file. This file I save as .txt (tab delimited).

While importing the .txt file into the feed I get errors for the header and every product. It says to many delimiters.

I realized that I have two additional delimiters at the end of the header and at the end of every row. How can I delete them.

I have more than 400 products.

Thanks

Marco

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
September

too many delimiters at end of txt file

[ Edited ]
Top Contributor
# 2
Top Contributor

the best likely course is to contact whoever is supporting
the e-commerce website export feature, so that the issue
may be resolved at the source.

otherwise, try importing the .csv file into a spreadsheet; then,
in the spreadsheet, select and delete any offending columns --
such as the last two columns; then, re-save or export the file

as .txt tab-delimited, for upload into the merchant-center.

 

see also

https://support.office.com/en-us/article/Insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-...

https://support.google.com/docs/answer/54813

https://help.libreoffice.org/Writer/Adding_or_Deleting_a_Row_or_Column_to_a_Table_Using_the_Keyboard

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
September

too many delimiters at end of txt file

[ Edited ]
Top Contributor
# 2
Top Contributor

the best likely course is to contact whoever is supporting
the e-commerce website export feature, so that the issue
may be resolved at the source.

otherwise, try importing the .csv file into a spreadsheet; then,
in the spreadsheet, select and delete any offending columns --
such as the last two columns; then, re-save or export the file

as .txt tab-delimited, for upload into the merchant-center.

 

see also

https://support.office.com/en-us/article/Insert-or-delete-cells-rows-and-columns-6f40e6e4-85af-45e0-...

https://support.google.com/docs/answer/54813

https://help.libreoffice.org/Writer/Adding_or_Deleting_a_Row_or_Column_to_a_Table_Using_the_Keyboard