cancel
Showing results for 
Search instead for 
Did you mean: 

new line character need to be removed

Former Member
0 Kudos

Hi All,

when i am creating csv file using file adapter, i am getting file with end of line characters as small boxes, which needs to be removed.

i have tried with below options..

File Type: Text

File Transfer :Text

can some one give me suggestions on this..

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Madhav,

Try to use one of these..

NameA.additionalLastFields=ignore

or

NameA.lastFieldsOptional=YES


baskar_gopalakrishnan2
Active Contributor
0 Kudos

IMO, the editor using to view the text file might be showing like this.. example notepad.  Hope that you use NameA.endSeparator = 'nl'.  Try to open in wordpad and see the same thing happening?

Former Member
0 Kudos

i have used 'nl' only as end seperator. if i use Word pad, i can see data in lines.

in the notepad i am able to see new line with boxes.. i dont want those boxes to be appreared at end of each line when open in the note pad.

Thank You,

Madhav