Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Can i include pre spaces in my specific value in inline load.
Where are you trying this? Can you help us to understand better
Something like this may be, I used @ symbol, you may use any other, not sure if there is other way
Load ITEM,Replace(WEEK,'@',' '), Sales inline [
ITEM, WEEK, Sales
"10001", @@@@WEEK1, 100
10001, WEEK2,0 ];
If you mean you want to load the data with the preceding or trailing blanks, then use the Verbatim system variable.
Set Verbatim = 0; // default
Causes QV to strip leading and trailing blanks from data fields (default behaviour)
Set Verbatim = 1;
Causes QV to not strip leading and trailing blanks from data fields