Hi,
I need a some solution to achieve the below output.
my source data like
Hyderabad-HYD,scb
New Delhi,NDA,Ghs
O/p
---
Hyderabad
New Delhi
Here i need to fetch only the before first delimiter characters, it should be ignored after the -/, characters.
i have some solution to handle this
1)find the characters positions of (,-)
2)use field function to fetch the required characters by using min character position
is there any other simple way to implement this???
Thanks in advance..
Fetch Data based on delimiter
Moderators: chulett, rschirm, roy
Fetch Data based on delimiter
D.N .MURTHY
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore