Extract a specific text

Help
, , ,
#1

Hello,

I have 3 rows with description as follows;

row 1: /ENTRY 01 Jan TATA CONSULTANCY SERVICES 12E248768/ HUYEHJB/238 84975
row 2:/ENTRY 05 Jan Tech Mahindra 1234 6756 32434
row3:/ENTRY 02 Feb IBM E287485460.

I want to extract the company names TATA CONSULTANCY SERVICES,Tech Mahindra,IBM. How do i get it. The company name has a date in the beginning and has numbers at the end

#2

Hi @AditiGandhi

Use this component to check in between

Thanks
Ashwin S

#3

@AditiGandhi Is the Company Name always at that position say, like its’s the 4th position always in the text which you provided, if so, you can Split and take 4th position value

#4

Hi @AditiGandhi

You can use substring if value exsts in same position

Thanks
Ashwin S

#5

yes its always at 4th position

#6

@AshwinS2 the length of name of the company differs.

#7

i used this expression and i’m getting the output as you asked image

(?<=ENTRY\s{0,2}\d{1,2}\s[A-Za-z]+\s).[(A-Za-z)\s]+\s
let me know if this is working out for you or not!

cheers @AditiGandhi

#8

what is the complete expression???

#9

(?<=ENTRY\s{0,2}\d{1,2}\s[A-Za-z]+\s).[(A-Za-z)\s]+\s
this is the complete expression and i’ve used your sample string
@AditiGandhi

image
image938×444 10.4 KB

#10

can i know which activity have you used?I am using ‘matches’ activity and it is giving null result

#11

i’ve used Matches activity!

#12

@AditiGandhi i’m attaching you my workflow here cheers
Main.xaml (6.2 KB)

#13

I am unable to view that particular activity. Can you please send n image of it?

#14

image
this is the activity! @AditiGandhi cheers

#15

Yes, it worked. Thank you

#16

cheers
@AditiGandhi

#17

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