How can i remove middle "-" in my value.

[dunnalahk123]

Hi,

Can some one help me , how can i remove hypen which i am getting in my value

For Example: i have value like 2017-11 but i want it in 201711

how can i remove that hypen in middle.

Best Regards,

Hk

[dionverbeke · Accepted solution]

replace() is your friend

or

subfield(f,'-',1) & subfield(f,'-',2)

or

left and right

Kind Regards,

Dion

[Anil_Babu_Samineni]

You can do like this?

Replace(FieldName, '-', '') as FieldName

Date(Date#(FieldName, 'YYYY-MM'), 'YYYYMM') as FieldName

[dunnalahk123]

Hi All,

Thank You so Much 🙂

[YoussefBelloum]

Hi,

you can also use this:

PurgeChar(Field,'-') as Field