Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I have a Sap report and I would like to know how extract just 2 values and left them in another columns, like Col1 Col2. I put an Excel Example.
Just I need to extract the first value within the date (In yellow).
Thanks!
Hi,
you can try this reload source code.
Directory;
Temp:
LOAD
Left(@1,10) as Order,
Right(@1,10) as Order_Date,
If(Alt(Right(@1,10),date#(Right(@1,10),'DD.MM.YYYY' ),0 ) <> 0,'X','') as Header_Flag
FROM
[..\EX1.xls]
(biff, no labels, header is 4 lines, table is [ME2N CR ENE12$]);Orders:
LOAD
Order,
Order_Date
Resident Temp
Where Header_Flag = 'X';DROP Table Temp;
kind regards
Mario
Any Help?
Anyone?
Thanks!
Anyone?
Thanks!
Hi, is the report a SAP standard transaction?
So that I can rebuild it?
regards
Mario
Yes, if you can look my example is an Excel with the data standar report from SAP.
So please give me the name of transaction, like MB11 or what else!
ME2N
Hi,
you can try this reload source code.
Directory;
Temp:
LOAD
Left(@1,10) as Order,
Right(@1,10) as Order_Date,
If(Alt(Right(@1,10),date#(Right(@1,10),'DD.MM.YYYY' ),0 ) <> 0,'X','') as Header_Flag
FROM
[..\EX1.xls]
(biff, no labels, header is 4 lines, table is [ME2N CR ENE12$]);Orders:
LOAD
Order,
Order_Date
Resident Temp
Where Header_Flag = 'X';DROP Table Temp;
kind regards
Mario
Hi,
did the code solve your problem?
regards
Mario