MQSeries.net :: View topic - How to Remove blank lines from a .csv file 2 use in DFDL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to Remove blank lines from a .csv file 2 use in DFDL

How to Remove blank lines from a .csv file 2 use in DFDL

« View previous topic :: View next topic »

Author

Message

pswmb

Posted: Mon Dec 26, 2016 7:32 am Post subject: How to Remove blank lines from a .csv file 2 use in DFDL

Newbie

Joined: 26 Dec 2016
Posts: 1

Hi All,

Can somebody help me , how to remove " blank lines from a .csv file to use in DFDL".

I have an input structure like this

DataLine1
<Blank Line>
DataLine2
<Blank Line>
<Blank Line> may be more than 1
DataLine3
<Blank Line>

DataLine4
DataLine5

DataLine6

How to remove above Blank lines to get the output structure like below

DataLine1
DataLine2
DataLine3
DataLine4
DataLine5
DataLine6

Thanks in advance.

timber

Posted: Wed Dec 28, 2016 1:37 pm Post subject:

Grand Master

Joined: 25 Aug 2015
Posts: 1280

Use the %WSP*; mnemonic.

You can get a good example of how to use it if you create a throw-away CSV model using the CSV wizard. It generates a terminator with this definition:

Code:

dfdl:terminator="%NL;%WSP*;"

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to Remove blank lines from a .csv file 2 use in DFDL

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP