How to use regex for excel column

Feedback Studio
, ,
1

Hii,

I wan to extract excel column data using regex
The excel column is :-1:

Invoice No Date
DF565BG 29 Mar 2023

Kindly suggest me how to use regex code for this scenario

3

@kailas_jadhav

If its in excel then each you come as separate column only…why do you need a regex again?

Cheers

4

Hi @kailas_jadhav ,

Can you please share the sample excel file or the screenshot of the excel?
And let us know the actual data you want to extract from it.

5

Hi @kailas_jadhav

Try this-

^(\w+)\s+(\d{1,2}\s+[a-zA-Z]{3}\s+\d{4})$

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.