topic Replace issue in App Development

Replace issue

Nagaraj6 — Fri, 15 Nov 2024 21:51:59 GMT

Hello All,

I need a help

I getting wrong output below,ending with -from-

I need concatenate Destination and From city name.

expected output ex: andaman-and-nicobar-from-pune

I am using this formula I getting syntax error

if(Des='',if(From<>'',lower(Replace(Des&'-from-'&From), '-from-', '', 2),lower(Des)),'') as [Des-From],

Re: Replace issue

edwin — Wed, 26 Apr 2023 14:06:21 GMT

you can try a few things, try using isnull(Des) and for From or use len(Des)=0
sometimes using the test against 0 len string does not work depending on the data

Re: Replace issue

anat — Wed, 26 Apr 2023 14:16:39 GMT

Can you try to eliminate the records while load where From field is null

Re: Replace issue

Chanty4u — Thu, 27 Apr 2023 17:52:30 GMT

Try this

if(From<>'',

lower(Replace(Des&'-from-'&From, '-from-', ''), '-') as [Des-From]

)