DSXchange

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

Field() function.

Convert tab to space.

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