Replace function: Find Multiple strings and replace to blank

[#1]

As a part of cleaning my Big Data text, I have to replace multiple stings to blank (I have almost 40 characters/strings to replace blank).

I am using

LOAD

...

Replace(‘replace_field','string_A',’’) as ReplacedString,

...

FROM ...;

Can I replace all my strings (example: string_B, String_C, String_D etc) to blank in single command?

[Anonymous]

Hi,

Robert Mika post is good solution

Regards

Neetha

[#3]

Thank you so much again!!! Now our spaces are gone from the text filed and looks great for reading.

[Anonymous]

What's the significance of putting 'Directory;' in the script?