Forum Discussion

MikeKral's avatar
MikeKral
New Contributor
3 years ago

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

SOURCE: ONESTREAM CHAMPIONS Company has a hard carriage return in their file for a couple of description fields. They are struggling to fix it on their side. Is there code that can be written for t...
Connectors
ckattookaran's avatar
ckattookaran
VIP
3 years ago

I don’t think you can. When the file comes in the column you are trying to fix is already in the second line. This needs to be done at the source. I cannot think of a different way to solve it.

  • MikeKral's avatar
    MikeKral
    New Contributor
    3 years ago

    Thanks Celvin! I tend to agree as that it is what I see when I look at the data in Notepad++ The line is already showing up in 3 separate lines within the data file. I will push back on the and try and get them to resolve on their side or determine that this field is not critical to bring into stage. Thanks, Mike