Removing a character from the field values

[Anonymous]

I have a field with Sales values like 1.5 M, 2.5 M etc.,

How to remove M suffix from a field?

The reason for the removal is, Qlikview automatically takes the M character and converts it into some values. Instead I need 1.5, 2.5 as it is.

[tresesco]

Mid(Sales, Len(Sales)-1)

And note, 'M' might be for Million

[PrashantSangle]

Hi,

Use purgechar()

try like

purgechar(fieldName,'M')

Regards

[ChennaiahNallani]

Replace(YourFiledName,'M','''')

[prma7799]

Hi ,

As Tresesco said 'M' might be for Million.

can you please check with chart properties Number format >million symbol

Thanks

[nagarjuna_kotha]

PFA..and If not enough u can use Replace Function also.

[sujeetsingh]

Replace function will do your work.

[krishna20]

Hi,

Try Subfield(). It may works.

[Gabriel]

Hi,

Please use PurgeChar(FieldName,'M')

[amit_gupta]

Hi Koushik,

In case of Just removing character from String you can use this:

PurgeChar(text, remove_chars)

Example Result:

PurgeChar ( 'a1b2c3','123' ) Returns 'abc'

PurgeChar ( 'a1b2c3','312' ) Returns 'abc'

In your Case:

PurgeChar ( '1.5 M','M' ) Returns '1.5'

For all values

PurgeChar ( Sales,'M' )

Note: It will remove the perticular char from your string.

However, I feel that in your case Sales is measure data, you need to put condition you convert into million by multiplying 1000000.

I hope, it will help you