Hi
my data is like this
abc~#asdf~#hdsajds
the delmiter is ~# how do we read this I tried giving the delimiter as ~# but it is reading #also how to avoid this
Thanks
M
sequential file reading with ~# delimiter
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
sequential file reading with ~# delimiter
Last edited by marpadga18 on Thu Jul 05, 2012 8:18 am, edited 1 time in total.
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's no need to do anything external if you use Arnd's solution.
The solution from srinivas.g requires that the file be pre-processed - it does not matter where.
The solution from srinivas.g requires that the file be pre-processed - it does not matter where.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.