data separated by space

pavan_test · Post by **pavan_test** » Wed Mar 28, 2012 4:17 pm

Hi All,

I have incoming data coming in separated by space such as,

america italy spain india
america china britan japan

desired output:

america

i.e. I have to pick up only the 1 one and process it.

Can anyone please let me know how do I process data separated by single space. sometimes the data can also comin sepaarted by a single tab.

Thanks
pavan

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2012 4:48 pm

Field() function.

Convert tab to space.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 28, 2012 9:09 pm

Too complex. Field(Convert(svTab, " ", InLink.TheString), " ", 1, 1) would do it.