m -> minutes?

[Cammagno]

I have a field with content "9 m" (where m symbolizes meters)
In DataView table it is visualized as "9 minutes".
How can I get rid of this, showing "9 m" instead?

[AB1908]

Can you show us your query?

[AB1908]

Use double quotes around 9 m.

test:: "9 m"

```dataview
Table
test as test
WHERE Type = "Test"
```

[Cammagno]

Use double quotes around 9 m.

Thanks for your time!

If I define the field inline, with double quotes, it works.

But unfortunately I can't, it has to be defined in YAML, and there it does not work :(

[AB1908]

Are you sure? Double quotes are properly supported in YAML IIRC.

[Cammagno]

Are you sure? Double quotes are properly supported in YAML IIRC.

Sorry if I wasn't clear.
Double quotes are indeed supported in YAML, and I always use them
With "there it does not work" I mean that if the field is defined in YAML instead of inline, double quotes or not double quotes doesn't matter, DataView changes that "9 m" into "9 minutes".

So, since I can't define the field inline (for other reasons, I need to define it in YAML and only in YAML), unfortunately I can't use your suggestion for working around this peculiar behaviour of DataView.

EDIT: I've finally found a workaround, based on your suggestions :)

I've used that
number(Velocità) + "meters"
after all, but it only works if in YAML I input the field as " 9 m", with a space (or a letter or similar) before the 9 or after the m. If its only "number m", it gives that error I showed above. Really strange behaviour!

[AB1908]

Hmm it may be worth revisiting this later. I'll keep an eye out for this. Just so I'm capturing this correctly:

1. Define field as YAML.
2. Use "9 m" as value
3. Rage at not being able to use the original value in a DV query?

[blacksmithgu]

Hmm. I think the correct fix may actually be to remove "m" as an allowed way to define minutes, and use "min" instead. This also brings up the ever present problem of how to properly escape raw strings you don't want parsed.

Is this field defined in frontmatter, or in an inline field? (Thing:: Value)?

[blacksmithgu]

If it's in YAML / frontmatter than I need a way to allow escaping such fields. One option is to simply track the raw value of all such fields and let you reference that instead (raw(velocity)).

[Cammagno]

Is this field defined in frontmatter, or in an inline field? (Thing:: Value)?

it's in YAML frontmatter.
If it's inline, problem can be solved with doublequotes (see discussion with AB1908 for more details), but not when it's in frontmatter.
In frontmatter, only workaround I've found is to add to the field content a space (or another not numeric character) and then extract the amount with number() and rebuild the field with + "m".
Without the additional space/character, the number() function does not work, that is probably a related bug (see discussion above for the error message)

[Cammagno]

I think the correct fix may actually be to remove "m" as an allowed way to define minutes, and use "min" instead.

I agree with this, because people living in metric-using countries use m for meters a lot

[Cammagno]

One option is to simply track the raw value of all such fields and let you reference that instead (raw(velocity)).

This would be a good general solution!