Yes, it sounds weird but the request is for txt data output with fields all run together, no commas but retaining the blank fields as blank space. It seems so simple but none of the simple things I've tried have worked so far, such as data cleansing to remove punctuation (but the commas are not in the fields). I tried removing the delimiter on the output step but that didn't solve it. I then tried setting the delimiter to a blank space but it won't let me do that unless I allow quotes which I don't want. If there were a way to output to a txt file instead of a csv file I would think I would be all set but I can't see how to do that.
I'm getting this:
A, 20190101,20190131,5605,00000000000500, ,XA11
But I need this:
A 2019010120190131560500000000000500 XA11
Solved! Go to Solution.
Set the delimeter to \0 and it should do what you want
Perfect, thanks jdunkerly!
User | Count |
---|---|
59 | |
26 | |
24 | |
22 | |
21 |