Skip to main content
  • EN

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

You can use a StringReplacer:

0684Q00000ArLUcQAN.png

Text to replace:

\n

For replacement text you can either leave it blank or use a space, depending on what you need.

You can use a StringReplacer:

0684Q00000ArLUcQAN.png

Text to replace:

\n

For 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.

Community Stats

31,954
Posts
121,348
Replies
39,566
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.