Hello there.
I am reading in a CSV file and have found that where a field is null (empty) I need to replace this with a value, such as 0.
In an ideal world the following command would work:
stringName.Repl ace(",,", ",0,");
This does not work but I am wondering if there is a way to replace the double commas in the string with ,0, values?
The input file is very large so editing the file and find/replacing isn't suitable as ultimately this needs to be an automated process with very little intervention, save for browsing to and clicking a load button.
Any help would be very welcome, please.
Thank you.
Mark :o)
I am reading in a CSV file and have found that where a field is null (empty) I need to replace this with a value, such as 0.
In an ideal world the following command would work:
stringName.Repl ace(",,", ",0,");
This does not work but I am wondering if there is a way to replace the double commas in the string with ,0, values?
The input file is very large so editing the file and find/replacing isn't suitable as ultimately this needs to be an automated process with very little intervention, save for browsing to and clicking a load button.
Any help would be very welcome, please.
Thank you.
Mark :o)
Comment