How to insert a blank in a date element ?

Document created by anton_serbanescu Employee on Apr 17, 2015Last modified by dave_lesshafft on Mar 2, 2016
Version 2Show Document
  • View in full screen mode
Have the following flat file XML data, delimited by pipe (|) :

 

<ns1:GetPerfVestResponse xmlns:ns1="http://tempuri.org/">
  <ns1:PerfVestData>
    <ns1:PerfVestStruct>
      <ns1:ParticipantId>501084946</ns1:ParticipantId>
      <ns1:GrantId>2013PSU055</ns1:GrantId>
      <ns1:VestDate>05/02/2016</ns1:VestDate>
      <ns1:TypeId>PSUM</ns1:TypeId>
      <ns1:TargetQuantity>13400</ns1:TargetQuantity>
      <ns1:MaxQuantity>26800</ns1:MaxQuantity>
      <ns1:MinQuantity>0</ns1:MinQuantity>
      <ns1:SharesCancelled />
      <ns1:AppliedDate></ns1:AppliedDate>
      <ns1:AppliedMultiplier />
      <ns1:AwardType>STANDARD</ns1:AwardType>
      <ns1:PCTDate></ns1:PCTDate>
    </ns1:PerfVestStruct>
  </ns1:PerfVestData>
</ns1:GetPerfVestResponse>

 

or

 

501084946|2013PSU055|05/02/2016|PSUM|13400|26800|0| || |STANDARD|| | |0| | | |05/02/2013|13400

 

Expected output :

 

501084946|2013PSU055|05/02/2016|PSUM|13400|26800|0| | | |STANDARD| | | |0| | | |05/02/2013|13400

 

What needs to be done ?
The map needs to be adjusted to have a set default to a space for the date elements that require a space.

 

The data format in the profile needs to be changed from Date to Character.

 

0EM40000000bowE

 

The target map elements:

 

0EM40000000bowJ

 

and the data formats in the filter:

 

0EM40000000bowO

 

Attachments

    Outcomes