Replace String In String and Parse Delimited String

Hi Team,

We use the Business function Replace String In String to read the flat file , to replace the blank(Delimiter as blank) in flat file with |(Pipe) , so where ever blank is there the Pipe(|) symbol is getting inserted.

So if the values  123 456 890 167 will be converted to 123|456|890|167 and now by using the Business function Parse Delimited String , i will be able to get the segment as 0,1,2,3 and  in table i will insert as Column 1 = 123,Column 2 = 456,Column 3 = 890,Column 4=167.

But for the same case if value comes as 123     890 167 (where 456 is missing), i want in table to get inserted as Column 1 = 123,Column 2 =