Read A Word Doc with Lines

[Kyleb91 (Kyle Brown)]

Hi Guys,

I’m trying to get text from a word doc.

The whole doc is formatted in a table with lines.

I have managed to use matches to find what I’ve needed so far, but now I need a line of text but can’t seem to Split the string.

So I have Read Text of the docx and output is a wordstr.

I am trying to pull out “CELEBRATE THE WEEKEND WITH A WINNING OFFER!” But this text could vary.

I have tried splitting after "Name and before “Subtitle” ; Split(out_Brief, “Promotion Name”)(1)

But I can’t grab all of the text. I have checked the output in the log message and the string at this stage is “\r\a\r\aCELEBRATE THE WEEKEND WITH A WINNING OFFER!\r\a\r\a”

I have tried to split then further, but these characters from the lines in the doc prevent this from working…

Any help would be great, thanks!

[bcorrea (Bruno Correa)]

Does YourText.Replace("\r\a\r\a","") works for you?

[Kyleb91 (Kyle Brown)]

Hey man - no; I’ve tried that too…

[Kyleb91 (Kyle Brown)]

@bcorrea

Replace("\r\a\r\a","")

I have tried both but the output is different in the output pane and the variable:

I’m not entirely sure which is exactly the one…

[bcorrea (Bruno Correa)]

Hi, i dont seem to follow exactly what the problem is, do you have a sample word doc for us to try?

[Kyleb91 (Kyle Brown)]

Test.docx (25.6 KB)

Here a sample; there are some dropdowns with content which are likely causing complications.

Thanks!

[mitesh_parmar]

HI @Kyleb91
Have you tried using Match with Regex ?

[Kyleb91 (Kyle Brown)]

Hey!

I have tried, and use it successfully to grab other data on the Test doc I hae attached above, but can’t seem to grab that particular bit of text…

[mitesh_parmar]

If you can user
Regex then apply below code:

Regex.Match(yourVariblehavingTableDataInString,"(?<=Promotion Name)[\s\S]*(?=Subtitle)").Value

[bcorrea (Bruno Correa)]

Please see if this helps you:
textFromDocx=textFromDocx.Replace(Chr(7),"").Split(vbCr.ToCharArray, StringSplitOptions.RemoveEmptyEntries)

[ppr (Peter | MVP)]

yes, i did in parallel

[Kyleb91 (Kyle Brown)]

Brilliant @bcorrea ; not 100% sure how it works but it does

[Kyleb91 (Kyle Brown)]

Hi @bcorrea I was hoping I could get some further help from you… thanks again for Friday’s help!

Test.docx (26.9 KB)

This is another edited doc, and what I am trying to do is check the contents under the Additional Tags? Sections

What I’m trying to do is if there is text in here, grab the string, and add this to a variable and use in a selector. There may be one word here, or multiple though…

I can’t seem to grab just the 'onboarding, prc" text, and I’m not sure how to separate by the comma, if there is a comma there (because there may only be one word here) and then ‘for each’ through the text received for use later.

Any help would be great!