Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Loading text file in xMII

Hi Experts,

I have an requirement to load text file into xMII and process(reading fields from text file) it. I'm using Text

Loader to load the text file and am linking the StringContent property to input of flat file parser.

Now the output that am getting from flatfile parser is the content of my input file in one single row as string

without any spaces or delimiters.

  <?xml version="1.0" encoding="UTF-8" ?> 
- <Rowsets DateCreated="2008-04-11T13:51:32" EndDate="2008-04-11T13:51:32" StartDate="2008-04-11T13:51:32" Version="12.0.2 Build(88)">
- <Rowset>
- <Columns>
  <Column Description="LineNumber" MaxRange="0" MinRange="0" Name="LineNumber" SQLDataType="5" SourceColumn="LineNumber" /> 
  <Column Description="Line" MaxRange="0" MinRange="0" Name="Line" SQLDataType="1" SourceColumn="Line" /> 
  </Columns>
- <Row>
  <LineNumber>1</LineNumber> 
  <Line>500reels\200803\004770.0104770ReelLength263602StartTime1204379532ReadyTime1204384880NoCommentsFormationPictures180000000EdgePictures11000079315101SnapShots00000000000012759549562000956615295643800000000001FormationData44929070178000000000EdgeData63270500000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000AAAAAAAAAAAAAAAAAAAAAA8037</Line> 
  </Row>
  </Rowset>
  </Rowsets>

Am not able to read the file contents based on end of line or any other delimiters.

Please suggest me a way to load a text file without changing it from original format and also able to parse it.

my source file is in *.txt format and am using xMII 12.0.

Regards

Ravi shankar

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question