Search Results

Thanks so much for the helpful reply!

Yes, field 4 is terminated by ; and not merely separated.

Yes!

This looks great! Thanks so much!

This code was giving a record for each ID plus a blank field 4 line after the records with data, so I changed


for(i = 1; i <= n; i++)

to

...

Thanks for the reply!

There is no need to modify the commas if the second awk statement could split the lines on the pipe characters.

The <newline> should be replaced by a single space.
...

Thanks for the reply.

The data file is a large data file from the Federal government.

I would like to read the data using stat software packages.

The lines end with \r\n .

Field 4 is a...

I have a messy, pipe-delimited ("|") input dataset.

I would like to create a file of ID plus each component of field 4 which is delimited by ";" into a long, skinny shape for easier processing.
...