nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Delete row that contain alphabet but stay numeric

Hi guys,

How to delete the row that contain unwanted alphabet and the time (example: 8:35AM), stay only the numeric. There are thousand of data, so I can't specify which row is it.

Accepted answers

For Each Row(
If( Right(:Time,2) == "AM",
     :Time = substr(:Time, 1, Length(:Time) -2
);

Is this what you are trying to do?

All comments

For Each Row(
If( Right(:Time,2) == "AM",
     :Time = substr(:Time, 1, Length(:Time) -2
);

Is this what you are trying to do?

It worked for me. Thanks.

Quick Links