Removing only first line break in the field

[TS2895]

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,

[gabrielvilella]

Hi @TS2895, you can try this RegEx expression:

(\w+.+)

[IraWatt]

Hey @TS2895,

Another option is to use the data cleansing tool with this setting:

Ira Watt
Technical Consultant
Watt@Bulien.com 

[MarqueeCrew]

@TS2895 ,

regex_replace([field],"(.*)?[\n\r](.*)",'$1 $2')

i replace the first new line or carriage return with a space.