Hello, I tried to bring in a Notepad file and while delimiting , specific records are not properly delimited. How to resolve this? Regards, Priya
Hi @rpriyada
Can you provide some sample input notepade file and expected output it will help us get a better understanding of the usecase.
@rpriyada
I am sure @atcodedog05 would give a better solution. 😂
Hi @rpriyada
Here is my take. @Qiu has already done a pretty good job with his solution 🙂. I reduce it a little bit.
Workflow:
Changes:
1. Regex is different.
2. @Qiu has taken column name dynamically but in this case, it's not that much helpful according to me. The reason being Regex is static and will work only to extract these columns which are fixed(not dynamic). And reducing your workflow will decrease runtime 😅. Other than that @Qiu method is definitely a pretty good solution.
PS: @Qiu I will be on vacation for a while and won't be posting any solutions 😅. Hoping you and other solution authors will do your best like always to help people 🙂
Hope this helps : )
Hi @rpriyada
Definitely an interesting approach @HomesickSurfer 🙂
@atcodedog05
Enjoy your vacation. 😁