[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 444
  • Last Modified:

Flat Text File Format

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
Burzhuin
Asked:
Burzhuin
  • 2
  • 2
  • 2
  • +2
1 Solution
 
Anthony PerkinsCommented:
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
 
BurzhuinAuthor Commented:
I confirmed it and it is CrLf.
0
 
Anthony PerkinsCommented:
Then I am afraid I have no idea what could be going on given all the information you have provided.

Good luck.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
AlexPaceCommented:
Make sure the text file is sent over FTP in ASCII mode instead of BINARY mode
0
 
ZberteocCommented:
How about the field terminator, what is it set for? Also can you attach a data sample?
0
 
Dave BaldwinFixer of ProblemsCommented:
@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
 
AlexPaceCommented:
@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
 
Dave BaldwinFixer of ProblemsCommented:
@AlexPace, good then, I wasn't sure.  Looks the poster agrees with you.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now