Anyway to account for hard carriage return in a data load file?

I had a similar problem at one point and had to remove a significant number of special characters (not all shown here). Try this in a Parser BR (sorry the tabs are not pasting in correctly):

Namespace OneStream.BusinessRule.Parser.Parse_Remove_Special_Characters
Public Class MainClass
Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As ParserDimension, ByVal args As ParserArgs) As Object
Try

  		If args.Value = "" Then
  			Return "Empty_String"
  			Else

  				Return args.Value.Replace(vbCr, "").Replace(vbLf, "")
  		
  		End If	

  	Catch ex As Exception
  		Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
  	End Try	
  End Function

End Class
End Namespace

For the sake of anyone else that might read this later, you then attach this Business Rule to the dimension in the Data Source that you’re having issues with by selecting it as the Logical Operator/Expression.