So I was able to split column based on specific substring length and export the data to my target source; at which point I noticed data contained Line Feed.

So is there a way to split column into multiple records based on Line Feed and excluding Line Feed char(10)

Thanks again in advance for your help.