MQSeries.net :: View topic - Manipulations in esql involving file nodes

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 » Manipulations in esql involving file nodes

Manipulations in esql involving file nodes

« View previous topic :: View next topic »

Author

Message

beatrice

Posted: Mon Dec 15, 2014 8:14 am Post subject: Manipulations in esql involving file nodes

Newbie

Joined: 26 May 2014
Posts: 2

My requirement is to prefix and suffix "$" symbol at the start and end of every record .

I have file nodes here
I have used record detection as delimited in fileinput node and record is delimited data for fileoutput node

My file looks this way

1789879
14567890
123456
12345

and it has to be this way
$1789879$
$14567890$
$123456$
$12345$
.
.
.
.
.
.n

pls

as I am new to this .....

Vitor

Posted: Mon Dec 15, 2014 8:44 am Post subject: Re: Manipulations in esql involving file nodes

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

beatrice wrote:

pls

as I am new to this .....

Help with what? You've said in the title you want to do this in ESQL and concatinating values is about as easy as it gets in terms of code. Inability to do this bodes badly for more complex tasks.....

If you're that uncomfortable with code, consider asking WMB / IIB to do it for you by defining the prefix & suffix values in the DFDL / MRM definition.
_________________
Honesty is the best policy.
Insanity is the best defence.

beatrice

Posted: Mon Dec 15, 2014 9:07 am Post subject:

Newbie

Joined: 26 May 2014
Posts: 2

Thanks for ure reply ....the question was posted for help as I didn't know ...if you would know the answer ....reply or else .....just leave it ...and do not reply this way ....

mqjeff

Posted: Mon Dec 15, 2014 9:16 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

beatrice wrote:

Thanks for ure reply ....the question was posted for help as I didn't know ...if you would know the answer ....reply or else .....just leave it ...and do not reply this way ....

You can spend a lot of time sitting here waiting for a reply that you think is correct.

Or you can spend a little bit of time reading the answer you've already been given.

Or spend a little bit of time reading the documentation on the product you are trying to use, and experimenting.

It's your time. Spend it how you like.

Best of luck.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Manipulations in esql involving file nodes

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