| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| dfdl parsing |
« View previous topic :: View next topic » |
| Author |
Message
|
| sai kumar123 |
 Posted: Thu Jan 12, 2017 9:55 pm Post subject: dfdl parsing |
 |
|
Novice
Joined: 16 Dec 2016
Posts: 15
|
Hello..Iam able to parse the below data in record oriented(tds) by using separators,initaitors and terminators....
but I have 60 records I cannot go 60 times this procedure....plz give me hint in a dynamic way...then I will carry my work
UNIT:KWD;
DATE:19/11/2014;
PERIODS:SPOT;
TMM:9.785451882,9.785451882;
GHC:11.005340017,11.005340017;
AED:12.611070300,12.611070300;
AUD:3.925513914,3.925513914;
BDT:264.399353150,264.399353150;
BHD:1.291795840,1.291795840;
BRL:8.936702403,8.936702403;
CAD:3.878676761,3.878676761;
CHF:3.298483087,3.298483087;
CLP:2045.022186486,2045.022186486;
CNY:21.086088729,21.086088729;
CZK:76.036522440,76.036522440;
DJF:610.199703919,610.199703919;
DKK:20.440968977,20.440968977;
DZD:290.614155367,290.614155367;
EGP:24.516873027,24.516873027;
EUR:2.745496126,2.745496126;
GBP:2.191458807,2.191458807;
HKD:26.625695985,26.625695985;
HUF:840.943936908,840.943936908;
IDR:41820.828258222,41820.828258222;
INR:211.719039045,211.719039045;
IQD:3980.327260713,3980.327260713;
JOD:2.424027844,2.424027844;
JPY:398.977656721,398.977656721;
KES:308.819852313,308.819852313;
KRW:3770.579837470,3770.579837470;
KYD:2.849936917,2.849936917;
KZT:619.136578302,619.136578302;
LBP:5176.344481565,5176.344481565;
LYD:4.213046925,4.213046925;
MAD:30.329576171,30.329576171;
MOP:27.314521646,27.314521646;
MXN:46.540840435,46.540840435;
MYR:11.500283028,11.500283028;
NOK:23.209136322,23.209136322;
NZD:4.327074065,4.327074065;
OMR:1.321538817,1.321538817;
PGK:8.765454791,8.765454791;
PHP:154.256614387,154.256614387;
PKR:347.974274051,347.974274051;
PLN:11.604215180,11.604215180;
QAR:12.477931423,12.477931423;
RON:12.185607916,12.185607916;
RUB:162.231798187,162.231798187;
RWF:2361.393663042,2361.393663042;
SAR:12.881464668,12.881464668;
SDG:19.483115719,19.483115719;
SEK:25.407663391,25.407663391;
SGD:4.452947890,4.452947890;
THB:112.585254846,112.585254846;
TRY:7.656042349,7.656042349;
TWD:105.433357387,105.433357387;
TZS:5912.633630903,5912.633630903;
UAH:53.116534939,53.116534939;
UGX:9373.206773516,9373.206773516;
USD:3.433490000,3.433490000;
VND:73074.434621229,73074.434621229;
XAF:1800.230698650,1800.230698650;
ZAR:38.114611698,38.114611698;
 |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Jan 13, 2017 3:59 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
I only see 4 different record types here, and the 4th is a repeating type... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| timber |
| Posted: Fri Jan 13, 2017 4:19 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
| What does your DFDL model currently look like? What issues have you found? |
|
| Back to top |
|
|
| Deepak.k |
| Posted: Sat Jan 14, 2017 12:11 am Post subject: DFDL |
|
|
Novice
Joined: 18 Aug 2016
Posts: 22
|
Hi saiKumar
By seeing ur data it seems records are different,so do a dfdl based on the terminator(i.e ; and parse it. |
|
| Back to top |
|
|
| manoj5007 |
| Posted: Sun Jan 15, 2017 8:48 pm Post subject: |
|
|
Acolyte
Joined: 15 May 2013
Posts: 64
|
| What is the problem you are experiencing with your dfdl schema?? |
|
| 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
|
|
|
|
