Community

Hi,

I use regular expression to find string in one column number but, now, I must to do a search on two criterias which are in different columns (same line):

Example :
1234569A54000000000000XXDAZERTQWERTTY

In column 8 search for "A" AND in column 25 search for "D"

I have tried something like this :
(^.{8}A54)(^.{25}D)

But without results..., I guess I misunderstood something in use o f regular expression

Thank you very much for your help,

Thierry

Try
^.{7}A54.{14}D

This matches

ben_josephs wrote:Try
^.{7}A54.{14}D

This matches

Code: Select all

^      the beginning of a line
.{7}   any 7 characters
A54    the literal text: A54
.{14}  any 14 characters
D      the literal text: D

Hi ,

That's I wanted!

Thank you very much.

Have nice day,

Thierry