Dataport Import Problem From CSV File.

Purvesh_Maisuria

Hello All,

I have a problem in IMPORTING data from CSV file with the help of DATAPORT.

Data in .CSV File which i want to import in my table posecode1.


This are dataport fileds i set.
Enabled SourceExpr StartPos Width
Yes Code 0 0
Yes City 0 0
Yes "Search City" 0 0

This is Dataport's Property I setted. I Also try FieldSeparator = <,> or <TAB> or < >(Space).


Result Result After dataport execution in the Postcode table is like this,


i want data in like this as a regular format.

Code City Search City
A B C
D E F
G H I

If Anyone have solution, please help me to solve this problem.

Thanks in Advanced
Purvesh Maisuria.

cernst

A CSV file is separeted by ; so try that as FieldSeparator.

Purvesh_Maisuria

Hi cernst,

I Already do that but it is not working, infect i put <None>, <COMMA>, <TAB>, <,>, <;> it give me same output.

Thanks 4 Try & Reply.

Purvesh Maisuria.

matttrax

Unless it is the default, you only use the < and > in the FieldSeparator property to denote special separators like <TAB>. Otherwise you just use a comma. Your dataport is probably looking for the exact text of <,> and not finding it, thus treating the entire line as one field. So remove the < and >.

Purvesh_Maisuria

Hi Matttrax Sir,

Grand Salute To U. =D>. Its Working Just Fine Now, Thanks 4 Giving Such a Exact Solution. Actually I Tried With ; without < and > But forgot to try , without < and > bz i tried lots of option like <COMMA>, <;>, <,>, <TAB>, <NEWLINE>, ; , TAB, lots of but not try ,(simple comma). By the Way Thanks Once Again 4 Sach a Wonderfull Reply, Hope U will solve problems of mine in future. Thanks Sir. =D>

Thanks & Regards.
Purvesh Maisuria.