Fetch Data based on delimiter

dr.murthy · Post by **dr.murthy** » Mon Feb 20, 2012 9:30 pm

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..

kandyshandy · Post by **kandyshandy** » Mon Feb 20, 2012 9:40 pm

Almost there..

Convert all known/expected delimiters to single character & then select the first field using field function.

Kryt0n · Post by **Kryt0n** » Mon Feb 20, 2012 9:54 pm

Field(Field(x, ",", 1), "-", 1)

dr.murthy · Post by **dr.murthy** » Mon Feb 20, 2012 10:23 pm

Thanks kryton ..

chulett · Post by **chulett** » Tue Feb 21, 2012 7:52 am

So... resolved?