Euros a problem

[andersonimes]

Hello! I am getting the following error trying to process a file. I'm wondering if maybe this isn't designed to process a file with Euros, maybe? Here is the error:

ValueError: could not convert string to float: '€2656'

[andersonimes]

Oh. I think I know why. The values are all denoted with commas for decimals.

"€26,56"

Can you fix it or should I just regex the files before using the tool?

[andersonimes]

Nope - that did not fix it.

ValueError: could not convert string to float: '€26.56'

Must be the euro symbol maybe, but looking at the code, there appears to be currency matching going on so I don't think I can just change it to a dollar symbol or remove it without impacting something else.

[juftin]

🎉 This issue has been resolved in version 1.0.5 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

[juftin]

Let me know if this didn't resolve the issue 🤝

lunchable-primelunch/lunchable_primelunch/primelunch.py

Lines 220 to 222 in d2eab76

	exploded_totals["parsed_total"] = exploded_totals["parsed_total"].str.replace(
	",", ".", regex=False
	)

[andersonimes]

Pretty much the same result.

[juftin]

@andersonimes could you share a CSV with a few test records so I can debug on my end?

[andersonimes]

I hope I don't regret this :)

amazon_order_history.csv

[andersonimes]

Hello! Did you get a chance to take a look at this?

[juftin]

Yup, thanks for sending that! This was a tough fix but I believe I've got it. If you run into any issues try setting the LC_ALL=<your locale code> environment variable.

[juftin]

Let me know how the new version works 😅

[juftin]

🎉 This issue has been resolved in version 1.0.6 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

[andersonimes]

This did not resolve the problem.

[andersonimes]

@juftin sorry to say I think you should reopen this.