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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 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.
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
@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.