Hello,
I have a TEXT column in a table and I have a flat file that is ^^ delimited. There are some situations where that data look something like this
^^1^^06/03/2021^^100.00^^This is a multiline
not and it needs
to remain as a multiline note^^1^^0^^
^^1^^06/03/2021^^100.00^^This is a multiline
not and it needs
to remain as a multiline note^^1^^0^^
But bulkwriter for some reason does not like that even though I specified that the ^^ is the delimiter.
I have used Reformat to strip out the "\n" and it works fine but boss does not want to lose the multilines.
^^1^^06/03/2021^^100.00^^This is a multiline note and it needs to remain as a multiline note^^1^^0^^
^^1^^06/03/2021^^100.00^^This is a multiline note and it needs to remain as a multiline note^^1^^0^^
Any solution?
Thanks!
I have a TEXT column in a table and I have a flat file that is ^^ delimited. There are some situations where that data look something like this
^^1^^06/03/2021^^100.00^^This is a multiline
not and it needs
to remain as a multiline note^^1^^0^^
^^1^^06/03/2021^^100.00^^This is a multiline
not and it needs
to remain as a multiline note^^1^^0^^
But bulkwriter for some reason does not like that even though I specified that the ^^ is the delimiter.
I have used Reformat to strip out the "\n" and it works fine but boss does not want to lose the multilines.
^^1^^06/03/2021^^100.00^^This is a multiline note and it needs to remain as a multiline note^^1^^0^^
^^1^^06/03/2021^^100.00^^This is a multiline note and it needs to remain as a multiline note^^1^^0^^
Any solution?
Thanks!
Comments (2)