How can I replace the value from the right column to current column and replicate the same

[Kartik21]

I have a column which is of type VWstring and contains both number and text.(refer "Gross Amount" column in screenshot attached) I want to filter the rows containing text and numbers separately. How can I do that? I tried using 'Isnumber' in formula tool but it is of no use as column type is VWstring.

Apart from that I also want to replace the value in the right column to current column, in the current column and repeat the same for the following columns. How can I do that?

[binu_acs]

@Kartik21 use the regex_match function

[davidskaife · Accepted solution]

Hi @Kartik21 

For your first query you can use the following formula in the Filter tool. This will filter where the field contains letters only:

regex_match([Gross Amount],'[a-z]+')

For your second query, an example might be helpful as I'm not quite sure I understand what you're after

[Kartik21]

Thank you both of you. Problem is now solved. 😊👍