Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. return 'Date,Payee,Category,Memo,Outflow,Inflow\n' +
  2. documentContent
  3. .replace(/\t\n/gm, ',,,')
  4. // .replace(/,,,\$([\d\.\,]+)\s*USD/gm, ',,$$$1 USD,,$1')
  5. .replace(/,,,\$([\d\.\,]+)\s*USD/gm, function (match, p1) {
  6. var amount = (parseFloat(p1) * 9.4).toFixed(2)
  7. return ',,$' + p1 + ',' + amount + ','
  8. })
  9. .replace(/(\w{3})\s(\d{2})\s(\d{4})\s*/g, '$2/$1/$3,')
  10. .replace(/\/jan\//gi, '/01/')
  11. .replace(/\/feb\//gi, '/02/')
  12. .replace(/\/mar\//gi, '/03/')
  13. .replace(/\/apr\//gi, '/04/')
  14. .replace(/\/may\//gi, '/05/')
  15. .replace(/\/jun\//gi, '/06/')
  16. .replace(/\/jul\//gi, '/07/')
  17. .replace(/\/aug\//gi, '/08/')
  18. .replace(/\/sep\//gi, '/09/')
  19. .replace(/\/act\//gi, '/10/')
  20. .replace(/\/nov\//gi, '/11/')
  21. .replace(/\/dec\//gi, '/12/')
  22. .replace(/Purchase at /gi, '')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement