If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Source File Line Delimiter

Started by tneogy1, 17 Apr 2012 03:47:21 AM

Previous topic - Next topic

tneogy1

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