DSXchange

I agree that the point you have mentioned about solving it with efficiency rather just solve it. I have used CONVERT() Function and it works.

Thanks Again,

Pete

Hi All, Thanks for all your valuable information. I have used Field String function to eliminate Double Quotes from the Name Field, ie. If the name comes in as John 'Doe' the Result should be John Doe Solution is : Field(String,'"',1):" ":Field(String,'"',2) It Works :D Thanks

I have a source file with a columns namely, Id and Name. The name comes with First name and Last name with quotes. I would like to Trim the string by eliminating the double quotes. Input ID Name 101 John "Mathews" 102 Leander "Pius" Required Output ID Name 101 John Mathews 102 Le...