Skip to main content
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.

  • January 10, 2023
  • 2 replies
  • 16 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
Contributor
Forum|alt.badge.img+23
  • caracadrianContributor
  • Contributor
  • 571 replies
  • January 11, 2023

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
Contributor
Forum|alt.badge.img+13
  • tomfriedlContributor
  • Contributor
  • 177 replies
  • January 11, 2023

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

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


Community Stats

32,066
Posts
121,745
Replies
39,692
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.