Choose Language Hide Translation Bar
Highlighted
almighty22
Level II

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

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?

Jim

View solution in original post

2 REPLIES 2
Highlighted
txnelson
Super User

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?

Jim

View solution in original post

Highlighted
almighty22
Level II

Re: Delete row that contain alphabet but stay numeric

It worked for me. Thanks.
Article Labels

    There are no labels assigned to this post.