hiii
i have data coming in a table separated by space . i wish to lookup each value from the lookup table individually and enter them in db separately
Input: abc ghi jkl def
Lookup table is like :
abc 1
def 3
ghi 4
jkl 2
Output should be like:
1
4
2
3
i am not getting how to do the separate the data and lookup individually.also the number of fields coming is not fixed
Lookup space separated values individually
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu Aug 09, 2012 4:55 am
- Location: bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: