output

pavan_test · Post by **pavan_test** » Wed Oct 27, 2010 12:19 pm

I have input data as , sony xxxxxx europe

desired output: sony xxxxxx europe

Can anyone please suggest me to accomplish this.

Thanks
Mark

anbu · Post by **anbu** » Wed Oct 27, 2010 12:24 pm

I dont find difference between your input and output

pavan_test · Post by **pavan_test** » Wed Oct 27, 2010 12:27 pm

input: , sony xxxxxx europe

desired output: sony xxxxxx europe (after eliminating comma and extra spaces)

anbu · Post by **anbu** » Wed Oct 27, 2010 12:42 pm

TrimF(TrimF(Str)[2])

pavan_test · Post by **pavan_test** » Wed Oct 27, 2010 12:57 pm

I received output as pe

desired output: sony xxxxxx europe (after eliminating comma and extra spaces)

Thanks
Mark

mobashshar · Post by **mobashshar** » Wed Oct 27, 2010 3:07 pm

Use the following:
TrimF(Convert(",", "", InputLink.Column))