Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Hi, I am running a workspace to transform my data into a .csv using pipe delimited characters to separate my data. The problem I am having is how to eliminate the pipe delimiters that are separating the rows. I showed an example below.

FME_PipesseparatingrowsI want to remove all the extra pipe delimiters after the data. I would do it manually by I have over 10000 records. Please help.

You can use a Tester to test if the first attribute (col0) has a value and filter out the ALLPIPE lines.

Test for pipe

I think is better to filter before you write data to CSV-file.

Reply


Community Stats

30,126
Posts
114,374
Replies
37,765
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.