I want to extract multiple matchs ( Account Code) in excel seperate column.
Account Code.pdf (155.0 KB)
Please guide me about it.
I want to extract multiple matchs ( Account Code) in excel seperate column.
Account Code.pdf (155.0 KB)
Please guide me about it.
Hi @fairymemay,
Use this patern —> "(?<=Account Code:).*"
Follow the steps below
MatchesAcc = System.Text.RegularExpressions.Regex.Matches(Text,"(?<=Account Code:).*")
System.Text.RegularExpressions.Match
, then you can use item
in your further sequence or for testing use message box with value item.Check attached, This will write account code side by side
BlankProcess12.zip (174.9 KB)
Mark as solution, if this helps you
Thanks