Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am trying to concatenate two fields as
[Payer.Name] &'('& [Payer.Number] &')' as Payer.Name1
this expression is not working for me
Iget output as - ABC(1760)
whereas it should be ABC(1760)
i tried using purgechar(Payer.Name,'-') it replaces ' - ' with ' ' '
trim gives same output as origanal expression one .
can anybody help?
Try this may be:
Replace([Payer.Name] &'('& [Payer.Number] &')', '- ', '') as Payer.Name1
Hi
Just tried your expression and it looks ok
Data:
Load * Inline
[
Payer.Name, Payer.Number
ABC, 1760
];
Data2:
Load
[Payer.Name] &'('& [Payer.Number] &')' as Payer.Name1
Resident Data
;
Output =
Have you checked your payer.name data? Can you post the source data?
Andy
TextBetween( [Payer .Name],'-','') &'('& Payer.Number &')' as Payer.Name1
doesnt work for me
in source Payer Name is - 'ABC'
i tried all functions to get rid of quotes but not working
Will you be able to share a sample?
Try
PurgeChar([Payer.Name],'-'&Chr(39))
Regards,
Antonio
Hi Arusanah,
If the source contains is definitely - 'ABC' then use below as a work around. Let me know if this works
Load mid(Payer.Name,4,3) & '(' & Payer.Number & ')' As ConcatenatedPayer;
V.