Hi all,
After some investigation I found out my Excel reader file contains "line breaks" causing FME to write the content of a single Excel cell to multiple lines.
Is there a way in FME to clean line breaks?
Thanks,
Ed
Solved
Clean line breaks from Excel file? (Reader)
Best answer by david_r
You can use a StringReplacer:
Text to replace:
\nFor replacement text you can either leave it blank or use a space, depending on what you need.
- Best Answer
You can use a StringReplacer:
Text to replace:
\nFor replacement text you can either leave it blank or use a space, depending on what you need.
david_r wrote:
You can use a StringReplacer:
Text to replace:
\nFor replacement text you can either leave it blank or use a space, depending on what you need.
@david_r
Thanks David, that did the trick!
These "invisible" characters kill me every time.
Cheers,
Ed
edhere wrote:
@david_r
Thanks David, that did the trick!
These "invisible" characters kill me every time.
Cheers,
Ed
You're not the only one struggling with those...! Glad to hear it worked out.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.