Luis, But only some rows will have the pipe symbol followed by carriage return not all. please see my commnets below

1|test|1234.45|testing|test123| ---|{CR}{LF} will work

2|test|1234.45|testing|test123| ---|{CR}{LF} will work

3|test|1234.45|testing|test123|

4|test|1234.45|testing|test123 ---|{CR}{LF} will NOT work

| -- error here

5|test|1234.45|testing|test123|

6|test|1234.45|testing|test123

|

7|test|1234.45|testing|test123|

8|test|1234.45|testing|test123|

Appreciate your responce