dropping a comma from a string variable

[Former Member]

Hi,
I would appreciate your help please in dropping a comma

I've created a string variable in the "Variable Editor" which goes like this:

        =Year([due_date])+"-"+"Q"+Quarter([due_date])

        *[due_date] is a date variable

I was wondering how can I drop a comma from year segment of the result

instead      2,016-Q4

to receive  2016-Q4

Thank You

[Former Member · Accepted solution]

Hi,

Try the following formula: =FormatNumber(Year([due_date);"#") +"-"+"Q"+Quarter([due_date])

Didier

[Former Member · Accepted solution]

thank you so much

[vinita_kasliwal]

HI Devteam

Try to do this :

REPLACE ALL OCCURENCE of lc_comma in lv_string with space and see if it helps

Regards

Vinita

[Former Member]

Hi Vinita,

I am not sure I understood what you meant.
And Didier MAZOUE comment really helped.

Thank you for your reply

[vinita_kasliwal]

haha ok I meant this ..

REPLACE ALL OCCURENCE of ',' in '2,016-Q4'  with space.