Hello, I have a data step with LENGTH/FORMAT/INFORMAT/INPUT components that imports a CSV file. It's a big piece of code as it has close to 200 fields and yes, I copied it from the import wizard. I've been using this for a while and it's been working fine. However, I just needed to add another variable to import, Comment, and now I'm having all kinds of issues. The comment variable could and does have all kinds of characters in it and the ones that I think are causing me a headache are new line characters and commas. So what happens when I run my code only part of the comment will be displayed in the Comment field and then all the following fields will get messed up (for example, Comment is supposed to say '$10,000 was paid to the customer' and the CommentDate field that follows should say 3/5/2019 - instead the Comment field is showing $10 and the CommentDate field is showing .). My question is, is there a way to clean the data coming in somewhere in the INPUT section. For example, where I have: INPUT Comment : $CHAR275. I could have something like Comment = TRNWRD(Comment, ".", "") :$CHAR275. and/or something similar to remove new line characters. Btw, I tried this and it's not working. Any ideas? Thanks!
... View more