Avatar

Level 2

Hi, 

Context: "Cost allocation and charge back mechanism" on using no of events or no of Lan id's.

Req: Generate a fixed-file length format file and transfer via SFTP.

Fixed-length file: Fixed-length format files use ordinal positions, which are offsets to identify the location of fields in the record. 

 

Following is a sample data record:

20011228YF2001122814313425 Forest St Marlborough MA017525083828200600

 

The record is defined by the following column layout:

  • Columns 1 - 8: Date format YYYYMMDD. Null when value is '99991231'.
  • Column 9: Boolean Y/N. Null when value is space (' ').
  • Column 10: Boolean T/F. Null when value is space (' ').
  • Columns 11 - 24: Time stamp format YYYYMMDDHHMMSS. Null when value is '99991231000000'.
  • Columns 25 - 39: Character address. Null when value is all spaces.
  • Columns 40 - 52: Character city. Null when value is '****NULL*****'.
  • Columns 53 - 54: Character state. Null when value is '##'.
  • Columns 55 - 59: Number postal code. Null when value is all zeros.
  • Columns 60 - 68: Character phone. Null when value is all zeros.
  • Columns 69 - 72: Number(3,2). For example, 600 is 6.00. Never null.
  • Column 73: Newline end of record.

I have tried using data extraction activity, but not helpful and struck there, requesting all the experts to provide a solution on this if it can be done in Adobe campaign classic.