I'm looking to perform the following task in QV:
How can i achieve this ? I imagine there is a previous command involved. Just unsure as to how to frame the logic.
All suggestions are welcome. Thanks
My intentions were right, but I should have thought through or tested my code .
Peek('New Column') & Value & ',' as [New Column];
LOAD * INLINE [
Left([New Column], Len([New Column]) - 1) as [New Column]
DROP Table Table;