on 09-19-2007 7:18 PM
Hi
can anybody tell me how the pipe delimited file look like ?? If possible with example. What is the difference between tab delimited, pipe delimited, CSV, flat file, fixed with fomat file and text file ??
Thanks
Kumar
Hey
pipe delimited file will have a Pipe symbol(|) in the end.
example can be
Mark Anthony USA |
Susan Price USA |
see all these are flat files and difference will come into picture when doing FCC,other than FCC you won't find much difference
thanx
Aamir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey
here is the thing
you have two different words, <i>Delimited</i> and <i>Separated</i>
now if u go with the dictionary meaning then <i>Delimited</i> means in the end which means Pipe should be in the end,and going with the dictionary meaning of <i>Separated</i> means it should be in between .but since we are not English authors i guess u can consider Raj's reply as more authentic.
Its all Business jargo so don't worry too much about it,you have to handle these files in FCC so if u have Pipe in between the entries then give .fieldSeparator as Pipe(|) and if u have Pipe(|) only in the end give .endSeparator as Pipe(|).
Thanx
Aamir
Kumar,
In addition to Aamir's reply. Its not manadatory that Pipe symbol has to be in end, it can be like following
Pipe delimited
ABC|123|TEST
CDE|345|TEST
CSV
ABC,123,TEST
CDE,345,TEST
Tab Delimited
ABC [<b>TAB SPACE</b>] 123 <b>[TAB SPACE]</b> TEST
CDE [<b>TAB SPACE</b>] 345 [<b>TAB SPACE</b>] TEST
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
26 | |
10 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.