This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Text Qualifier is double quotes
Delimiter is | (pipe)
Go to Solution.
Go to Solution.
@anuninan07 Can you provide a text format of input and desired output?
I have added the sample files.
please find attached workflow.
Let me know if it does work for you!
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.
Thanks in advance
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 --
I need the output with delimiter as pipe character (|) and text enclosed in double quotes (") and need to remove the extra double quotes in between the fields
For example - "Field1"|"Field2"
And the input file may not be also in this structure so I need to remove all this dynamically
Not the most elegant solution but --- hope it helps :)
This logic helped me.
Happy to hear that!
@anuninan07 if you accept solution -- please mark as solved!
Enjoy your weekend!