Hi all, I have a string that looks like this: Name: Paquito Adress: HelloStreet21 Tel: 034840184 FAX: 4891384 Nr.: ASFEW1231 MobilTel.: 837491741 Email: oaijdoiqew13132@gmail.com I want to extratct the value of Nr. only, so in this case it would be “ASFEW1231” Thanks in advance for any hel…

@chusikowski give a try on strvar.Split(Environment.NewLine.toArray).Where(Function (s) s.StartsWith(“Nr”)).Select(Function(s) s.Split(":"c)(1).trim).first()

Hi @chusikowski You can check out this article for your issue. [image] How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right Tutorials Hi, if you are a beginner in the world of automation and would like to know how you can manipulate t…

@chusikowski let’s say your full text is var_strFT. Use string class remove method to remove the NewLine from the entire string i.e. var_strFT.Replace() method by specifying the Environment.NewLine method to remove newline cahracters. And then you can substring characters from var_strFT.Substring(id…

Hi @chusikowski Use regex (?<=Nr.:).* By using ismatch activity Thanks Ashwin.S

Hi ppr, thanks for your reply, this looks promising but I get an error message saying “can’t convert type string to char”

see corrected statement in post

Get Substring from Multiple Line String

Help

pattyricarte (Patty Boy) January 24, 2020, 12:44pm 2

Hi @chusikowski

You can check out this article for your issue.

cheers

Happy learning

2 Likes

Topic		Replies	Views
Get certain line numbers from string Learning Hub	9	3376	April 5, 2020
Get a specific value from string Help uiautomation , activities , question	9	5291	November 8, 2019
Extracting substring Studio studio , question , workflow_diff	16	996	January 7, 2023
Get substring from text file Off-Topic Discussions	15	8229	May 31, 2018
Substring middle values Activities excel , activities , question	16	2461	August 23, 2021

Get Substring from Multiple Line String

Related topics