How we remove Quotes for a Numeric ' 00851'

[rohit782192]

Hello ,

I have a number  '00851'  How we remove these Quotes.

Note the file is a CSV files.

[DataNath]

If you use Replace([Field], “‘“, “”)

Does that help?

[rohit782192]

I want to remove. 

What should be in replacement.

Replace([Train No.], ' ', " ")
ReplaceFirst(String, Target, Replacement)

[DataNath · Accepted solution]

If this field should only contain numbers, you can also just drag on the Data Cleanse tool, tick the field(s) you want to apply it to and select the option to remove punctuation in the configuration.

[DataNath]

Would be Replace([Train No.], “‘“, “”)

Although this is a replace function, the fact that you aren’t putting anything between the last 2 quotes as a replacement means the ‘ will be replaced by nothing I.e. just removed. You’ll need to use double quotes around your ‘ so should be able to just copy and paste what I’ve posted above.