MQSeries.net :: View topic - To Use 'TRIM with Trailing whitespaces' in msgset

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 » To Use 'TRIM with Trailing whitespaces' in msgset

To Use 'TRIM with Trailing whitespaces' in msgset

« View previous topic :: View next topic »

Author

Message

umaneesh

Posted: Wed Jul 22, 2009 11:23 pm Post subject: To Use 'TRIM with Trailing whitespaces' in msgset

Novice

Joined: 13 Apr 2009
Posts: 24

Hi

I have a requirement like this,

Message:

{AIRway caps INTL regular <CR><LF>
Ashoke dalmin lencher <CR><LF>
Amount:1000578,00 <CR><LF>
}

In this message, I am receiving unwanted trailing whitespaces [before delimiter 'crlf']. It may or may not occur in each lines. I have to remove these whitespaces using one msgset [as per the requirement!].

I know this is possible with ESQL. But what is the possibility of doing this with MRM's?

Remember each line consists of variable length fields not fixed!

Pls suggest ...

Thanks

jp_schiller

Posted: Thu Jul 23, 2009 4:37 am Post subject:

Newbie

Joined: 10 Dec 2008
Posts: 2

Hi,
you can use the property: "Trim on input" --> Trim padding characters in the TDS Format message set properties.

The whitespaces get there because your physical properties of each element formats it into it because the MessageDefinition e.g. file says: "Padding Character": SPACE (this is the section where you see the length of the field etc.)

You can change it globally in the MessageSet configuration for your TDS format: e.g. Text1 --> section "Character data settings".

Just set there: "Trim padding characters" or the other options.
See: http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ad09265_.htm

Hard to describe it via text. Screenshot would be easier

Cheers,
JP

umaneesh

Posted: Thu Jul 23, 2009 5:28 am Post subject:

Novice

Joined: 13 Apr 2009
Posts: 24

jp_schiller wrote:

Hi,
you can use the property: "Trim on input" --> Trim padding characters in the TDS Format message set properties.
You can change it globally in the MessageSet configuration for your TDS format: e.g. Text1 --> section "Character data settings".

Just set there: "Trim padding characters" or the other options.

Thanks for your valuable inputs JP!

I believe these options [trim on input] are for fixed length strings only! However I would like to test this again to confirm on this. I am looking for "Variable length elements" ...

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » To Use 'TRIM with Trailing whitespaces' in msgset

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