Exporting a table to Fixed Width Text File 1

[jondel81]

I have a table full of customer information I need to be in a fixed width text file. I can export it just fine. When looking at the file, there seems to be extra line feeds in some of the records. The data output looks something liket his

http://www.carealotpets.com/ebay/examples.txt

Not sure whats going on in the data. Is there a way I can see if the line feed is in the data it self. Perhaps filter the line feed?

------

http://www.carealotpets.com

 

[lespaul]

I would have to say that there are a LOT of blank spaces at the end of the address information or the beginning of the city information of this record:

66445 Anderson David 23 Lazy Summer Way
Keasbey NJ 08832

The rest of the records look like they are exporting fine. Have you tried a TRIM function to remove the extra spaces?

Leslie

 

[jondel81]

Yes, all cells have the trim function being ran on them.

------

http://www.carealotpets.com

 

[jondel81]

Its not spaces, but something else. Like a line feed. How do I search for line feed character in the field?

------

http://www.carealotpets.com

 

[PHV]

Try something like this:
newValue = Replace(Replace(oldValue, vbCr, " "), vbLf, " ")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jondel81]

vbCr and vbLf are acting like params.

------

http://www.carealotpets.com

 

[PHV]

Use Chr(13) and Chr(10) instead.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jondel81]

Char(13) and Char(10) works like a charm. Thank you for your help.

------

http://www.carealotpets.com