I am new to webMethods and am trying to remove trailing zeroes from an 810 EDI document.
This is how the data looks coming in: 000000000853
What’s showing up in my map is 85300, I don’t know where the two extra zeroes are coming from and want to remove them, I am running webMethods Version 6.0.1
Any help, would be greatly appreciated.
If possible can you post your 810 edi data.And if we dont know about mapping details that you are handling its hard to trace.I believe there might be some thing wrong in the mapping itself.
Here is what I’m sending in using from an AS400 flat file using a JDBC adapter:
Here is the data from my map:
Not sure if this is needed, but here is the raw data I’m passing in:
0120040520435350 20040512689435 200406190030200406200031000000000853 This is the problem field
021% 30 NET 31 DAYS 20040416
07000000076800M MKETMARKET TRANSPOR BM0002150651
Thanks again for your help1
You need to remove the formatString from the EDI Schema.
The Schema is normally located in the wmEDIForTN package under the EDIFFSchema folder.
Determine which field is being referenced from the Dictionary in the Schema ie.213.
Locate the field in the Dictionary under Field Definitions and remove the formatstring for that field.
Thanks for elaborating,
yeh,following Chris suggestion will help in this case.
And also removing option is not recommended since when you move code to QA or Prod environments you have to do this procedure again or if you load any EDI fixes on the WmEDIForTN package chances are there to overwritten this change.
So contact wm support and get a fix for this problem and also they can suggest some flexible option.
Just my thoughts,
I did this for a client and they didn’t like it either. So they contacted Tech support!
Guess what? They suggested the same solution but i’d be curious to see if there’s a new solution.
Thanks to all for your comments, I will give it a try and will also contact support. If they give me an alternative solution, I’ll be sure to posted.