• 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.
Question

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.

  • 10 January 2023
  • 2 replies
  • 4 views
M

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.

2 replies

caracadrian
Rank
Badge +20

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

Test for pipe

tomfriedl
Rank
Userlevel 2
Badge +12

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

https://community.safe.com/general-10/fme-form-starter-20721

Reply


Community Stats

28,707
Posts
109,477
Replies
36,551
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.