How to solve delimiter issue

[Adarsh_R3]

Hi I got a file in which certain rows have delimiter issues and is causing line breaks. 

Can someone help me solve this issue?

Field 1	Field 3	Field 2
2022	this is ok	abc
2022	this line breaks into
next line	abc
2022	this is ok	abc
2021	this line breaks into
next line	abc

This is how it should be

Field 1	Field 3	Field 2
2022	this is ok	abc
2022	this is ok	abc
2021	this is ok	abc

Also new line always starts with year and the delimiter in the raw file is tab

[binuacs]

@Adarsh_R3 Would you be able to share your input tool configuration? 

[Adarsh_R3]

@binuacs  this is not an issue with input as i checked the raw file using notepad and the shift issues happened while writing/saving the data.

Is it possible to use Regex to solve this

[binuacs]

@Adarsh_R3 Have you tried using the Data Cleansing tool to remove the new line characters? Regex should also work. Try DataCleansing tool if that is not working we can work on the Regex Part

[Adarsh_R3]

sure let me check

[BS_THE_ANALYST]

@Adarsh_R3 can you try this workflow, it might be what you're after: