We have a requirement where we have to parse impex file (CSV format) using webMethods . It is a semicolon delimited record .But there is a possibility that the fields can also have “;” as part of the data and not an a delimiter. How can the data “;” distinguished from field delimiter of the record
For example :
Sample Record :
;0001;10011;pieces;CAREXXXXXXXXXX;;The CAREXXXXXXXXXX DRX-1 System offers a quick, easy and affordable way to transition to digital radiography. Based on the unique X-Factor platform, a wireless DR detector simply slides into existing x-ray equipment and can be used with imaging systems throughout your facility. Some use word processor; others DR detector or x-ray equipment The detector is also the center point of the XXXXX Family–a complete line of innovative DR systems including full radiology rooms and mobile x-ray systems.;;
Here the highlighted line with “;” is part of the product description field and not a delimiter .
Kindly share your idea on how to handle this scenario using webMethods .