Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thank you so much again!!! Now our spaces are gone from the text filed and looks great for reading.
What's the significance of putting 'Directory;' in the script?