BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Flat file Delimiter question


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
Nimu
Principal Member
Principal Member



Joined: 26 Apr 2004

Posts: 244



PostPosted: Fri Mar 18, 2005 3:23 pm 
Post subject: Flat file Delimiter question

Hi All,

My source file for ETL has '|' as the delimiter, but when I try to create a file format in DI my whole file appears as one field with single garbage value.

Can anyone suggest where I am going wrong?

Thanks,
Daisy
Back to top
Nicolas Hadj-Blaha
Principal Member
Principal Member



Joined: 10 Mar 2005
ASUG Icon
Posts: 481
Location: New Zealand


flag
PostPosted: Fri Mar 18, 2005 3:33 pm 
Post subject: Re: Flat file Delimiter question

Hi Daisy,

Did you try changing the new line delimiter as well as the column delimiter | ?

Maybe you could narrow down the problem using a small file with only a couple of lines to see whether this is a problem with your DI file format or with the file itself (i.e. the format not being consistent).

Sounds like a file format issue ...

Nicolas

_________________
Lead Data Architect, Synchrony Global
Back to top
Nimu
Principal Member
Principal Member



Joined: 26 Apr 2004

Posts: 244



PostPosted: Fri Mar 18, 2005 3:40 pm 
Post subject: Re: Flat file Delimiter question

Hi Nicolas,

I created a smaller subset of the file with only 4 line and tried changing both column as well as new line delimiter but nothing happens.

Thanks,
Daisy


Last edited by Nimu on Fri Mar 18, 2005 3:51 pm, edited 1 time in total
Back to top
Nicolas Hadj-Blaha
Principal Member
Principal Member



Joined: 10 Mar 2005
ASUG Icon
Posts: 481
Location: New Zealand


flag
PostPosted: Fri Mar 18, 2005 3:47 pm 
Post subject: Re: Flat file Delimiter question

What kind of file is it? just a simple Text file?
_________________
Lead Data Architect, Synchrony Global
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0805 seconds using 17 queries. (SQL 0.0561 Parse 0.0009 Other 0.0236)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo