Line Breaks, extra delimiter and extra text qualifiers in Text File

Hi All

I am trying to create a solution for removing line breaks, extra delimiter and extra text qualifiers from text input file. But I am not able to figure that out. Can anyone help me resolve this.

Here,

Text Qualifier is double quotes

Delimiter is | (pipe)

Developer

Accepted answers

NikyN

Ah, okay I did not see it in you desired output. So basically, in output file you do not want to see any extra spaces/and punctuations besides | -- right?

Updated below --

Line Breaks, extra delimiter and extra text qualifiers in Text File.yxmd

NikyN

Not the most elegant solution but --- hope it helps

Line Breaks, extra delimiter and extra text qualifiers in Text File.yxmd

All comments

Qiu

@anuninan07
Can you provide a text format of input and desired output?

anuninan07

Hi Qiu

I have added the sample files.

Desired Output.txt

LineBreak.yxmd

NikyN

Hello @anuninan07,

please find attached workflow.

Let me know if it does work for you!

Best Luck!

Niky

Line Breaks, extra delimiter and extra text qualifiers in Text File.yxmd

anuninan07

Hi Niky

It works for line breaks but I also need to remove the extra delimiters, extra double quotes and i need a dynamic line break solution. I tried the regex functions but not getting the correct solution.