Extract the word from String using Regex

Question

I have the following

Input:

 abc_account2621_activity_20161116_20161117_030627_311999667.csv
 xyx_account2622_click_2016111606_20161116_221031_311735299.csv
 sed_account2623_impression_2016111605_20161116_221808_311685411.csv
 abc_account2621_rich_media_2016111606_20161116_192542_311735300.csv
 vbc_account2622_match_table_activity_cats_20161116_20161117_0311_31.csv.gz  
 sbc_account2622_match_table_activity_types_20161116_20161117_0342_31.csv.gz

Expected Output

activity
click
impression
rich_media
match_table_activity_cats
match_table_activity_types

Code Tried up till now:

I want to access word which lies between [Number + (-)Underscore and End with (-)Underscore + Number]

 val x = "abc_account2621_match_table_activity_types_20161116_20161117_0342_31.csv.gz"

 val pattern3 = "(_([A-Za-z]+_[0-9]))".r
 var word=pattern3.findFirstIn(x).getOrElse("no match")
 word: String = _types_2

does this one sbc_account2622 always end in number?

JanLeeYu
– JanLeeYu

2017-07-26 06:06:01 +00:00
Commented Jul 26, 2017 at 6:06 — JanLeeYu
– JanLeeYu, Commented Jul 26, 2017 at 6:06

chengpohi · Accepted Answer · 2017-07-26 05:46:39Z

2

val x = "abc_account2621_match_table_activity_types_20161116_20161117_0342_31.csv.gz"
val pattern3 = """_([a-zA-Z_]+)_\d+""".r
pattern3.findAllIn(x).matchData.map(_.group(1)).toList

_([a-zA-Z_]+)_\d+ with matchData to capture group can capture this.

See regex101 for this.

answered Jul 26, 2017 at 5:46

chengpohi

14.2k1 gold badge28 silver badges43 bronze badges

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

Comments

Ori Marko · Accepted Answer · 2017-07-26 05:45:05Z

2

Use regex to find non number:

abc_account2621_([\D]+)_

For xyx_abc_... use:

([^_]+_[^_]+_)([\D]+)_

edited Jul 26, 2017 at 5:45

answered Jul 26, 2017 at 5:33

Ori Marko

59.3k26 gold badges157 silver badges259 bronze badges

1 Comment

Bhavesh Over a year ago

abc_account2621_ this word is not constant it can change it can be xyz_acb2145 etc

jwvh · Accepted Answer · 2017-07-26 05:57:59Z

1

I often find pattern matching with regex patterns to be handy.

val pattern = """\d_(\D+)_\d""".r.unanchored
input.collect{case pattern(x) => x}
// res0: List(activity, click, impression, rich_media, match_table_activity_cats, match_table_activity_types)

answered Jul 26, 2017 at 5:57

jwvh

51.3k7 gold badges42 silver badges70 bronze badges

Comments

JanLeeYu · Accepted Answer · 2017-07-26 06:07:23Z

0

You may try this one : \d_([a-zA-Z_]+)_[0-9]+_ with the flag set to global. try it here

answered Jul 26, 2017 at 6:07

JanLeeYu

1,0012 gold badges10 silver badges24 bronze badges

Collectives™ on Stack Overflow

Extract the word from String using Regex

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related