CSV Imported Transactions with tags ending with comma not imported
B
Benjamin Watkins
I've noticed that when importing a CSV file of transactions, if in the Tags column the tag text ends in a comma, that transaction wont get imported. I didn't have any problem importing my other transactions not including and including tags, but I noticed in Excel as I was editing my data to save as CSV file, if the tags in the Tag Column end in a comma such as : [tag1, tag2,] . Or [tag1,]. Then that transaction wont get imported by Lunch Money.
Log In
J
JP Shipherd
Hi Benjamin Watkins. A CSV (comma-separated values) file uses commas to delineate a new column. Are the columns that have tag names with commas in them enclosed correctly in quotes, to ensure that it doesn't look like the data belongs to the next column?
Could you post an example of a file with the initial header row and at least one row showing the tag types? You can also email me at jp@lunchmoney.app.