Guys who are expert in creating flat file ,please ignore this.
Delimited Flat File Settings
Schema Level- Properties
Schema Editor Extensions = Flat File Extension
Default Child Delimiter Type = None
Default Child Order = Conditional Default
Root level Properties - It identifies /n or /r/n Character
Child Delimiter = 0x0D 0x0A ( for unix 0x0A )
Default Child Delimiter Type = Hexadecimal
Default Child Order = Postfix
Child Delimiter = 0x0D 0x0A ( for unix 0x0A )
Default Child Delimiter Type = Hexadecimal
Default Child Order = Postfix
Record level Properties - It identifies , Character for records
Child Delimiter = ,
Default Child Delimiter Type = Character
Default Child Order = Infix
Example : Save below data into Abc.txt
1,John,5600,A
1,John,5600,A
2,Alister,5800,B
3,Philip,5600,A
Let me know if you need any more clarifications , you can reach me at raj.webjunky@yahoo.com
No comments:
Post a Comment