1. Reading from Flat file (XML) and adding substrings as data to table

    Hi everyone , I need help.I want to use an UBE to read an XML as a flat file , and by using Fetch next Line from flat file , cut a substring between the <MS1:MsgId> to </MS1:MsgId> for example , and store it in a custom table , already built to match the type of the data we are going to...
  2. parse field with special characters

    I have a file (.csv) I need to import that is comma delimited, however one of the fields looks like this: DSI000417214258SF000182 189970JHOWZEDSISCAN32MCAQ00321 I don't know how to define the delimiter in this field to break out the individual...