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.

2 years ago
January 10, 2023
2 replies
14 views

mmcmahon
2 replies

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

+23

caracadrian
Contributor
571 replies
2 years ago
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

+13

tomfriedl
Contributor
175 replies
2 years ago
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

Reply

Rich Text Editor, editor1

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

Cookie settings

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos + marketing

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.