Hi Alteryx community,
The data in the field is separated by line breaks as following:
Test data 1
Test 2
Test 3
Test 4
However, in some of the rows, there is a line break before the data.
Line break
Test data 1
Test 2
Test 3
Test 4
Only in such cases, I want to remove the first line break and keep the subsequent ones. Is there a way I can do it. Regex_replace is removing all the line breaks which does not work for me.
Thanks,
Hey @TS2895,
Another option is to use the data cleansing tool with this setting:
Ira Watt
Technical Consultant
Watt@Bulien.com