Solved

Clean line breaks from Excel file? (Reader)

  • 18 December 2018
  • 3 replies
  • 9 views
E
Badge

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
icon

Best answer by david_r 18 December 2018, 14:50

View original

3 replies

david_r
Rank
Userlevel 4

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.

E
Badge

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
Rank
Userlevel 4

@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

28,670
Posts
109,366
Replies
36,531
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.