Improve company productivity with a Business Account.Sign Up

x
?
Solved

Flat Text File Format

Posted on 2013-01-21
8
Medium Priority
?
445 Views
Last Modified: 2013-01-21
I got a new Vendor and FTP the flat text file. However for some reason  <carriage return> and <linefeed> does not work and instead of structured data (seven fields per row I got one string. In my package the row terminator is set to {CR}{LF} but seems cannot find it in the text. Did anybody have this problem before? Any suggestions? Thank you.
0
Comment
Question by:Burzhuin
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38801827
Are you show the row delimiter is CrLf?  Perhaps it is just Lf.  You can confirm this with a Hex editor otherwise you can post a sample here and we can verify for you.
0
 

Author Comment

by:Burzhuin
ID: 38801855
I confirmed it and it is CrLf.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38801978
Then I am afraid I have no idea what could be going on given all the information you have provided.

Good luck.
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
LVL 16

Accepted Solution

by:
AlexPace earned 2000 total points
ID: 38802001
Make sure the text file is sent over FTP in ASCII mode instead of BINARY mode
0
 
LVL 27

Expert Comment

by:Zberteoc
ID: 38802105
How about the field terminator, what is it set for? Also can you attach a data sample?
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 38802370
@AlexPace, ASCII mode normally does line-ending translations, BINARY mode does not.  In addition, it does it going both ways so even if it gets translated when uploaded, it will be re-translated when downloaded so it will look like nothing was changed on the server when it was.
0
 
LVL 16

Expert Comment

by:AlexPace
ID: 38802550
@DaveBaldwin, yes that's why I suggested it.  It is possible that the new host is not a windows box so using ASCII mode will "fix" the line endings as far as SQL Server is concerned.
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 38802616
@AlexPace, good then, I wasn't sure.  Looks the poster agrees with you.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question