Map 2 input fields to the same output field

Submitted by Kev Martin on

Issue summary: 

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.

Tags: 
concatenated
fields
Component: 
Code
Reporter: 
Kev Martin
Created: 
Mon, 03/24/2014 - 10:12
Updated: 
Tue, 09/15/2015 - 13:58

Comments

admin replied on

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

admin replied on

Issue changes: 
Project: CSV Converter »
Status: Active » Closed (won't fix)

Marcio Pavesi replied on

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