extract value before a string regex

Question

i have a question, need to extract a value before a defined string, but i can't, for example need to extract the value "Pudahuel", this word (dinamic) It is before the word "Horario", any suggestions?

 Orden de Trabajo
                                                            N° 0200087663


                                                                 Pudahuel Horario Atención: LU a VI de 08:30 a 13:00 y 14:30 a 19:00
Datos de Recepción:

example link: https://regex101.com/r/zN2vG6/29

Community · Accepted Answer · 2017-05-23 12:08:03Z

1

Your (.*)(?=Horario) matches 0+ chars other than a newline (because you did not use the DOTALL modifier) before a Horario text. Note there is a linebreak between the words you need.

Use the following regex

(\w+)\s*Horario

See the regex demo

The value you need will be in Group 1. Instead of \w+ (one or more word chars, those from [a-zA-Z0-9_] range) you may use [a-zA-Z]+, or even \p{L}+ (any 1+ letters).

NOTE: When you have Unicode chars in the patter/string, you need to use the /u modifier:

/(\w+)\s*Horario/u

or your suggested pattern (a bit enhanced):

/N°\s+(\S+)/u
            ^

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Jul 27, 2016 at 14:05

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Camilo Ortúzar Over a year ago

bro you rock!!!!!!!! thanks, and if the value is "LA SERENA" instead of "PUDAHUEL" (because the text are dinamic), any idea? :'v

Wiktor Stribiżew Over a year ago

It depends on the criteria. If you want to match a chunk of space separated ALLCAPS words before Horario, use \b([A-Z]+(?:\s+[A-Z]+))\s*Horario.

Wiktor Stribiżew Over a year ago

Or, if you need to match the whole string free from the initial whitespace before an Horario word that appears at the start of the next line, use /^\h*(.*)\R+Horario/m.

Camilo Ortúzar Over a year ago

thanks!!, now i have a problem with the ordinal character (°), because need to extract the value (0200087663, the number is dinamic), but the cron doesnt recognize the char (°), any idea?

Wiktor Stribiżew Over a year ago

No idea what input you have. Please note that you may use the last pattern in the previous comment to just match anything. Also, you can always include any chars into character classes. Say, [\w°] will match a word char and a °.

|

RomanPerekhrest · Accepted Answer · 2016-07-27 14:36:47Z

0

Your initial string could contain vertical/horizontal tabs, use the following regexp:

(\b[\w ]*?)[\v\h]?(?=Horario)

DEMO link

answered Jul 27, 2016 at 14:36

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

2 Comments

Camilo Ortúzar Over a year ago

thanks!!, now i have a problem with the ordinal character (°), because need to extract the value (0200087663, the number is dinamic), but the cron doesnt recognize the char (°), any idea?

Wiktor Stribiżew Over a year ago

This is a case where one really does not need to use a lookaround.

Collectives™ on Stack Overflow

extract value before a string regex

2 Answers 2

9 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related