Page 1 of 1
output
Posted: Wed Oct 27, 2010 12:19 pm
by pavan_test
I have input data as , sony xxxxxx europe
desired output: sony xxxxxx europe
Can anyone please suggest me to accomplish this.
Thanks
Mark
Posted: Wed Oct 27, 2010 12:24 pm
by anbu
I dont find difference between your input and output
output
Posted: Wed Oct 27, 2010 12:27 pm
by pavan_test
input: , sony xxxxxx europe
desired output: sony xxxxxx europe (after eliminating comma and extra spaces)
Posted: Wed Oct 27, 2010 12:42 pm
by anbu
output
Posted: Wed Oct 27, 2010 12:57 pm
by pavan_test
I received output as pe
desired output: sony xxxxxx europe (after eliminating comma and extra spaces)
Thanks
Mark
Posted: Wed Oct 27, 2010 3:07 pm
by mobashshar
Use the following:
TrimF(Convert(",", "", InputLink.Column))