BookmarkSubscribe
Choose Language Hide Translation Bar
almighty22
Occasional Contributor

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.

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
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
0 Kudos
2 REPLIES 2
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
0 Kudos
Highlighted
almighty22
Occasional Contributor

Re: Delete row that contain alphabet but stay numeric

It worked for me. Thanks.
0 Kudos