Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
I have a table loaded from an excelfile with some text columns, in which som cells have blank spaces before or after the cell text. This is deliberate and needed for further use. However, in the debugger, I can se that blank spaces are removed from the variable when using peek() to retrieve values from the cell.
I am not sure if this is done by the peek function or upon load, but in either case, is there a way to retain the blank spaces in the cells?
Regards
Rasmus
Hi
SET verbatim =1;
Table:
Load * from xyz.xlsx;
Hi
refer this for the explanation.
regards
Pradosh