Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[haylo75]

I'm trying to display Sample Rate in an Expression Column as kHz rather than Hz.  I tried Math([Sample Rate] / 1000) with the intent of wrapping a formatting function around it.  Apparently [Sample Rate] is evaluated as a string as any Math whatsoever returns 0.  Am I missing something simple?  If not, can MC be modified so that Math may be applied to [Sample Rate]?

Thanks!

[haylo75]

I see now why I cannot perform Math on [Sample Rate] as it's formatted like so, "44100 Hz".  Stripping non-numerics did the trick.  I have a solution sorted out.  It's not the prettiest, but it got me what I needed.  The expression:

Code: [Select]

If(IsEmpty([Bit Depth]),?,[Bit Depth])//FormatNumber(Math(Regex([Sample Rate],/#([0-9]+)#/,1)/1000),1)
The output:
16/44.1
24/96
24/88.2
24/176.4

... or Bit Depth/Sample Rate, in kHz, 1 decimal place precision when required.

Expression Language FTW once again!

[MrC]

Use [Sample Rate,0] and [Bit Depth,0].  The ,0 means to output raw, rather than formatted.

[haylo75]

MrC, thank you, that's good to know!  I may have missed that in the wiki entry.  That simplified my Expression:

Code: [Select]

If(IsEmpty([Bit Depth]),?,[Bit Depth])//FormatNumber(Math([Sample Rate,0]/1000),1)

[ferday]

Thanks for this, I was looking to do the same thing but hadn't got as far as trying yet