224571_en-US

liliconcom

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.

Re: Delete row that contain alphabet but stay numeric

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

Is this what you are trying to do?

Re: Delete row that contain alphabet but stay numericIt worked for me. Thanks.