Remove carriage return

[Anonymous]

I have some data in excel

as

COMPLETE ECR-0001479

COMPLETE ECR-0002435

COMPLETE ECR-0002780

COMPLETE ECR-0003223

COMPLETE ECR-0003670

where there is carriage return(Alt+enter) in the values.

Any idea how to remove it via subfield.....

Regards

Nitin

[giakoum]

Could you please post a sample excel file?

[Anonymous]

PFA the sample excel file

[giakoum · Accepted solution]

LOAD Replace(DATA, Chr(10), ' ') as data

FROM

C:\Users\user\Downloads\sample1.xls

(biff, embedded labels, table is [Sheet1$]);