Extract portion of strings based on the positions
KVBJun 3 2013 — edited Jun 3 2013Hi
My requirement is simple.I get the below data from the source file.
My data looks like this.Sometimes I get a space,one tab space,two tab space.It's ambiguous.
FIRSTWORD SECONDWORD THIRDWORD FOURTH (o/p=FIRSTWORD SECONDWORD THIRDWORD)
FIRSTWORD SECONDWORD THIRD WORD(o/p=FIRSTWORD SECONDWORD THIRD )
If it is something fixed,then I can write using INSTR and SUBSTR and it worked.But how we can handle multiple cases all at a time.
Thanks in advance
KVB