Add a Starting Record to a file

Question

I have a file that contains all the info below - the header files need to be first and then the rows with the data come after but the first line needs to be LEDES1998B by itself.  Any idea how to do this?  I have it all except how do I get this first line that just says LEDES1998B?

LEDES1998B

19990225|96542|00711|0528|1684.45|19990101|19990131|For services rendered|1|F|2.00|-70|630|19990115|L510||A102|22547|Research Attorney’s fees, Set off claim|24-6437381|350|Arnsley, Robert|PT|423-987

19990225|96542|00711|0528|1684.45|19990101|19990131|For services rendered|2|F|2.00|0|700|19990115|L510||A102|22547|Research attorney's fees, Trial pleading|24-6437381|350|Arnsley, Robert|PT|423-987

ArnaldoSandoval · Answer

Hi @ewassell

One way to strip those |s from the output CSV files is by splitting the stream, the first record with LEDES1998B is written by itself to the output csv, the remaining records are appended to the output csv. but because Ateryx CSV output does not support appending, so we need a macro to achieve the appending,

I found the AppendtoCSV here in the Alteryx's Community (I lost its link), I modified it to output pipe | separator.

While testing I found that your fields LINE_ITEM_DESCRIPTION and TIMEKEEPER_NAME contains commas, so I replaced their commas with spaces NOTE: I am using the latest version of Alteryx, one of the workflows posted here do not need the comma replacement, who knows why?

Hope this helps,

Arnaldo

2023_04_11_Add_Starting_Record.yxzp

ewassell · Answer

Thank You! This is almost it but if I save the outgoing file as a .csv file with a delimiter of |, it shows the pipes after the LEDES1998B in the same line. How do I get rid of them?

cititest.csv

ewasell wf_.yxmd

RobertOdera · Answer

Hi, @ewassell

Kindly consider the below.

I hope you find it helpful - Cheers!

For_ewasell.yxzp