How Extract Sentence Before Specific Word

Help StudioX
,
1

Hi !

I am trying to Extract sentence before the DWG# word but unfortunately, its extract the whitespace as shown in the below image. Could anyone help me please? Thanks

image
image1444×423 32.8 KB

2

Hello @Teaf,

Do you need to get all before the word DWG?

3

No i need item No

5

Hi @Teaf ,

Could you try this instead?

.+(?=\r?\nDWG#)

image
image878×378 23.9 KB

Kind Regards,
Ashwin A.K

6

\w+(.*)\w+(?<=:)

7

unfortunately the output same

image
image1451×493 37.3 KB

8

Sorry, I meant to type in this

.+(?=\r?\nDWG#)

Kind Regards,
Ashwin A.K

9

Thanks !!!

1 Like
10

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