Read and split data from excel

[avinash.wankhede]

I have to read the excel file which Cell has for ex: - Outlook Email

I want to read only 1st word after the - i.e Outlook in this example

[Anil_G (Anil Gorthi)]

@avinash.wankhede

For reading the cell value you can use read cell activity

And then to extract the required value, say the cell value read is stored in str then

System.Text.RegularExpressions.Regex.Match(str,"(?<=-\s+)\w*").Value

Cheers

[mkankatala (Mahesh Kankatala)]

Hi @avinash.wankhede

Store the Outlook Email in a string variable like Variable

Assign -> Variable = "Outlook Email"
Assign -> Variable = Variable.split(" ").First

In this i used split function to split the two words by using the space and took the first one.
Check the below image for better understanding

If you want to take the Email from Outlook Email use the below one

Assign -> Variable = Variable.split(" ").Last

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@avinash.wankhede
Hi,
Use read range
In for each loop take assign Content=CurrentRow(“ColumnName”).ToString
System.Text.RegularExpressions.Regex.Match(str,“(?<=\w+\s+).*”).Value

[Parvathy (PS Parvathy)]

Hi @avinash.wankhede

Use the following regex expression:

System.Text.RegularExpressions.Regex.Match("Outlook Email","[\w]+(?=\s)").Value
Output: Outlook

System.text.RegularExpression.Regex.Match("your string Input","(?<=\s)[\w]+").Value
Output: Email

Hope it helps!!
Regards,

[Gokul_Jayakumar (Gokul Jai)]

Hello @avinash.wankhede
To read the Specific Cell, you can use the read cell activity and store the value in a variable.
By using Regex you can achieve your requirement.

System.text.RegularExpression.Regex.Match(ReadCellStr,"(?<=-\s)[A-Za-z.0-9]+").Tostring.trim

[avinash.wankhede]

currentItem.ToString().Split(“-”)(1)

with this I am spliting the - and reading the enitire text after that - i.e outlook email.

I need only OUTLOOK word

[mkankatala (Mahesh Kankatala)]

Use the split like this
CurrentItem.ToString.Split(" ")(1)

Could you please which have to be take to extract the outlook. Please give the exact text with in double quotes

[vrdabberu (Varunraj Dabberu)]

@avinash.wankhede

Store the Outlook Email to a variable.

Word = "Outlook Email"
Reuqired Data = Word.Split(" "c)(0)

Regards

[avinash.wankhede]

“2023 - Outlook Email” is there but from here I need only Outlook

[mkankatala (Mahesh Kankatala)]

Okay then

Assign -> Variable = "2023 - Outlook Email"
Assign -> Variable = Variable.split(" ")(2)

You can use the below regex expression too

[rlgandu (Rajyalakshmi Gandu)]

Hi
(?<=-\s*)[A-Z]+[a-z]+(?=\s)

Thanks

[Anil_G (Anil Gorthi)]

@Anil_G

System.Text.RegularExpressions.Regex.Match(str,“(?<=-\s+)\w*”).Value

@avinash.wankhede

Please try this…this would work as you need

cheers

[lrtetala (Lakshman Reddy)]

Hi @avinash.wankhede

Try this
Valg.Split("-"c)(1).Split(" ")(1)