Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have BR_Code such as RA but I need to make it as RA00, The changes that were mage in the script as follows but I wont get the expected output. Cn some one help me on ths.
LOAD Text( BR_CODE) AS BR_CODE,
AMOUNT
FROM
D:\TET.xlsx
(ooxml, embedded labels, table is Sheet1,filters(Replace(2,top,StrCnd(null));
Neville
try
LOAD Text( BR_CODE) & '00' as AS BR_CODE,
AMOUNT
FROM
D:\TET.xlsx
(ooxml, embedded labels, table is Sheet1,filters(Replace(2,top,StrCnd(null));
try
LOAD Text( BR_CODE) & '00' as AS BR_CODE,
AMOUNT
FROM
D:\TET.xlsx
(ooxml, embedded labels, table is Sheet1,filters(Replace(2,top,StrCnd(null));
Thank Vijay,
That is what I looked forward to. I tried applying the same formula adding two zeros in front as well then the answer comes as 00RA.
Neville