COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: tneogy1 on 17 Apr 2012 03:47:21 AM

Title: Source File Line Delimiter
Post by: tneogy1 on 17 Apr 2012 03:47:21 AM
I have a source file with line delimiter '&'. Sample file data :
------------------------------------------
2455467,26,184,718,14284,0,"",0,0&
2454889,26,185,719,14312,0,"",0,0&
2450986,28,203,776,14780,1," because i like the color that one i love the green one seem look like easy to read..
that why  i chosse it.. i did read privacy policy..
thank you",1,1&
-------------------------------------------
What sould be the definitation of the DEF file?

VERSION 7
CHARSET 'windows-1252'
HEADERLINES 1
TRAILERLINES 0
ROWERROR 'ERROR'
QUOTECHAR 'DOUBLE'
DECIMALSEP '.'
THOUSANDSEP ','
LINEDELIMITER '????'
RECORD ','

What i have to write in the LINEDELIMITER part