Incorrect date format
We are try the approach of creating a text comma delimited file then importing into excel. I am having a problem in that all the schema fields are defined as string. I need to match our current output exactly – the problem is our current dates are outputted the csv file in this format
="08/11/1984".
I cannot get this to work using Adeptia – the combination of =” will not output. I tried various concat(s) but the only output that I could get to display was the = sign proceeding the value ex <Term_sp_Date>=01/19/1984</Term_sp_Date> cannot get = double quote to work
I cannot figure out the correct way to do this. Advice would be appreciated.
-
According to our understanding you are not able to get the desired output value ="08/11/1984" in the target csv file. So to get the desired output try applying the below concat function in the data mapper:
concat(' = ' , concat(' " ', $Input_Source_Schema/Root/Record/FieldName), ' " ' ).
0
Post is closed for comments.
Comments
1 comment