How to replace "" in a field

[rumpa]

I am new to Alteryx, need help with below issue.
My input CSV file has extra commas, so I am reading them as flat file. Then I am splitting the file into individual columns. But all the blanks are now stored as "". I am not able to use replace function to make it NULL or blank. any suggestions how to handle this. Thanks

 

[Qiu · Accepted solution]

@rumpa 
Try use the single quote like this

Replace([Field1], '"', '')

[Deano478 · Accepted solution]

@rumpa to set the second column with the "" to blank you can use the below formula:

Replace([ColumnName], '"', Null())