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.
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.
You can use a Tester to test if the first attribute (col0) has a value and filter out the ALLPIPE lines.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.