Use Regex Expression

Help
, , , ,
1

Hello,

I have an excel file that contains lines contain a string: Designation Value Price.
What I want is to write a regular expression that will seek to retrieve the first two or three letters of each word. line by line
For example: desig val pri.

as soon as it finishes it must search in a new file the corespendence.

I remain at your disposal for any other information.

Thanks,

Best regards,

2

@ifranity Can couple of lines of sample data and ur expected output?

1 Like
3

Try this:

\b\w{2,3}(?=\w*[\s.])

1 Like
4

Thanks buddy for the quick answer
please find attach the files DesignationClient.xlsx (8.8 KB)
DesignationVDR.xlsx (18.3 KB)
Output.xlsx (7.8 KB)
If match display all the rows from File DesignationVDR.

Thanks a lot,
best regards,