can we replace chr(10) to ' '

[SunilChauhan]

Can we replace  chr(10) in a column

i have tried

Replace(FieldName,chr(10),' ')

its not working

[its_anandrjs]

Do you have any sample data for this.

Regards

Anand

[anbu1984]

May be you might have carriage return (13)

Replace(FieldName,chr(13),' ')

[SunilChauhan]

its not working

[SunilChauhan]

Hi ,

Data i can't share but see below sample code

Load * inline

Fieldname

SED Escalation

outside of time

High>3 Days

Med>3 Days

Low>10 Days

];

BUT Remember that 

SED Escalation

outside of time

High>3 Days

Med>3 Days

Low>10 Days

is a single value

which i want as

SED Escalation outside of time High>3 Days Med>3 Days Low>10 Days.

[anbu1984]

What is your input? Excel or Inline load?

In Inline load, these are different rows.

[SunilChauhan]

its from sql server

[jagan]

Hi,

Check this script

Temp:

Load Concat(Fieldname, '', Order) AS NewField

inline

[Order, Fieldname

1, SED Escalation

2,outside of time

3, High>3 Days

4, Med>3 Days

5, Low>10 Days

];

Regards,

jagan.

[jagan]

Hi,

Little bit improvised

Temp:

Load Concat(DISTINCT  Fieldname, '', RecNo()) AS NewField

inline

[Fieldname

SED Escalation

outside of time

High>3 Days

Med>3 Days

Low>10 Days

];

Regards,

Jagan.

[anbu1984]

Try sql server function REPLACE ( Field , char(10), ' ' )

Try with Char(13)