Hi I am trying to figure out how to load data into variables using PLSQL. I have been using substr to load the data into each variable. For example,
vStockNum := substr(vBuffer,1,instr(vBuffer,vTab,1,1));
vBuffer is a line from what the UTL_FILE variable is reading in. The problem I am having is the part named vTab. How do you search for a tab. If it was a comma, it would be ',' but since we are dealing with a tab rather than a punctuation mark its more challenging. I've tried doing the manual way of ' ', but that doesn't work either. Any ideas on what I could try?