Map 2 input fields to the same output field

Map 2 input fields to the same output field

#35
Closed (won't fix) Opened

My only request so far is if we map 2 input fields to the same output field, they would be concatenated, ideally with a separator.

As it is, the second field mapped to output field x overwrites any previous.

This would allow us to grab more useful data into the memo field for example.

Kev*** Tue, 25 Mar 2014 - 22:08
CSV*** Wed, 22 Apr 2015 - 09:57

Would it work if you did this concatenation in Excel before converting the CSV?

CSV*** Tue, 15 Sep 2015 - 13:58
Mar*** Fri, 24 May 2019 - 22:51

The CSV file generates the OFX file with the date (dd / MM / yyyy) a day ago. Currencies type BRL (Brazil).

Ex. CSV input file Date: 12/05/2019 (correct) - OFX output: 11/05/2019 (wrong).

I have two options to fix this:

1- Adds a day to the dates of CSV worksheet transactions, like 13/05/2019, then the output OFX goes to 12/05/2019(correct) or

2 - Change the CSV file:

From: <DTPOSTED> 20190521

to: <DTPOSTED> 20190521100000 [-03: EST]

How can I make this process automatic?

Thank you