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.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
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.