SAP Information

[pgalvezt]

hello, I need to know how Can I Read just 2 columns of this SAP File please. For example I need to read all information 4504518604 ZPI  990000790  DIVISION TRE 11.01.2011 With just have Code "ZPI" and Bring me just 4504518604 in 1 Column and the date 11.01.2011 in other. Is it possible?

Example the final result would be:

PO	Date
4504385984	9/27/2010
4504533448	1/21/2011
4504586412	3/3/2011
4504601903	3/16/2011
4504619550	3/31/2011
4504623766	4/4/2011
4504623777	4/4/2011
4504625063	4/5/2011
4504633649	4/11/2011
4504654342	4/28/2011
4504682161	5/19/2011
4504696586	5/31/2011
4504699342	6/2/2011
4504707345	6/8/2011

Thanks

[pgalvezt]

Anyone?

[disqr_rm]

MyTable:

LOAD @1:11 as PO,

     date#(right(@1:n, 10), 'DD.MM.YYYY') as Date

FROM C:\TMP\ME2NCL.xls (fix, codepage is 1252, header is 5 lines)

WHERE @1:3=45;

[pgalvezt]

How do you load and appear @1:11 . Just appear @.

Thanks!

[disqr_rm]

Not sure what you mean.

[disqr_rm]

Here is example. Place them in same folder and reload. Should work fine.