| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| eejar |
 Posted: Sun Sep 25, 2011 7:23 pm Post subject: problem |
 |
|
Novice
Joined: 05 Aug 2011
Posts: 14
|
hi friends,
I have an problem, i.e, i have an text file eg: Name satish Id 503 Add NewDelhi it is *.txt format, from this i want only Id 503 into *.xml .
how i will change text file in to xml and get that data, by using esql
code:
Declare i char;
Declare j char;
Set i = inputroot.____? '*.txt'; -- ( in this place how i will read the txt file, r like we should write it r not, what is the correct way, for this part which concept we will read in info center)
Set j = substring(i from 13 for 3);
please solve this one frnds. |
|
| Back to top |
|
 |
| Archu |
| Posted: Mon Sep 26, 2011 4:17 am Post subject: Cannot Just parse the text file |
|
|
Novice
Joined: 17 Jun 2011
Posts: 16
|
The text file cannot be read using any input nodes without Providing the Parsers. we need to use MRM parser with either Text or CWF Physical format.
Message set is required which defines the length, padding character of each field in text file. This Message set has to deployed along with message flow deployed & parse teh text file with this message set & then do transformation & write it to *.xml file |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Sep 26, 2011 5:32 am Post subject: Re: Cannot Just parse the text file |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Archu wrote: |
The text file cannot be read using any input nodes without Providing the Parsers. we need to use MRM parser with either Text or CWF Physical format.
Message set is required which defines the length, padding character of each field in text file. This Message set has to deployed along with message flow deployed & parse teh text file with this message set & then do transformation & write it to *.xml file |
Nice explanation. One which the OP would have known for themselves if they had bothered to get some decent training.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
