Remove unwanted linebreaks?

[Jackie Z.]

I have a field in my database in which job applicants paste the text from their resumes. It often comes through with random line breaks that I'd like to clean up. (see attached)

 

This isn't white space or carriage returns. Maybe it's a text wrap issue? Anyone have a function I could try? Thanks! 

[David Nelson]

TextFormatRemove(Self) 

 

After your fields are clean, you can then use this as an auto-enter.  Be sure to uncheck Do Not Replace Existing Value.

[comment]

This isn't white space or carriage returns.

 

Well, it does look like white space. Could you do the following? Right-click into the field and select Export Field Contents... Zip the resulting file (before you open it with any other application) and post it here.

 

 

 

TextFormatRemove(Self) 

 

This will remove formatting from the existing text - not modify the text itself (remove unwanted characters).

[Jackie Z.]

Here is the zipped file. Thank you. 

field contents.zip

[comment]

What I see is just plain carriage returns entered after the two "and" words by someone who thinks they need to break the lines manually (there's something you wouldn't expect to discover from a resumé, isn't it?).

 

If you make your field a bit wider, it will straighten itself out. Otherwise you'd just need to remove them manually, since there's no way to tell them apart from legitimate paragraph breaks.