Blob Convert Issue

Question

I have a process that reads a file in via the BLOB Input and i want to convert this to Text. This i have achieved by using the BLOB CONVERT tool, however, when it converts the BLOB its not fully converting the file (i cant share the process as it has sensitive data in it).

So when the blob loads it loads 290k bytes of data (which is the size of the source file), but when the BLOB CONVERT converts it its only converting 29K bytes of data.

The file contain 800 rows of data with between 10-600 bytes per row.

Can anyone advise what would cause this issue. The field sizes are:-

BLOB Before convert = 2147483647

BLOB After convert =  1073741823

lbardoe · Answer

Please ignore this post as i realise that the issue is with the Text to Columns process not splitting the data by a New Line properly. I still have the issue but if i put the Converted Blob to an Output it still outputs the full data.