Excel operation state

Help
, ,
1

Hey
while I’m retrieving data from excel im getting data but like this

Screenshot (72)
Screenshot (72)1920×1080 23.1 KB
instead like this but i want only [{26},{38},{and so on}]
i don’t want anything else

thanks advanced

2

Hi
May I know how the data is actually in Excel
@Mayur_Pawar

3

yeah sure
@Palaniyappan Screenshot (67)
in this format :point_up:

4

Apply this regex “(?<=:)\d{0,}” on your expression.

1 Like
5

how and where should i apply ?
@Manish540

Screenshot (74)
Screenshot (74)1920×1080 118 KB

6

Hi @Mayur_Pawar

What is your logic? Are you trying to fetch “B” column values?

7

as i showed above excel snap i trying to get data in json format and im getting that but the format in which i want is

Screenshot (72)
Screenshot (72)1920×1080 23.1 KB
like this i want only value 26,38,74 etc like that @aanandsanraj

8

Hi @Mayur_Pawar
Click on Matches of Configure Regular Expression and then give the expression

Thanks
Ashwin S

9

The result is getting with datatable column header. Try the below code without header
JsonConvert.SerializeObject(dt.AsEnumerable().[Select](Function(x) x("ColumnName").ToString()).ToList())

10

Apply regex for this output,

image
image1920×1080 59.4 KB

11

what can be regex for this ?
@Manish540

12

Check this post,

13

Check this regex manually in the below site,

14

should i use configure regular expression activity ? if yes where should i put this regex ?
@Manish540

15

i tried but not able to achieved can anyone help ?
thanks advanced

16

Yes.

17

can i share my workflow ? @Manish540

1 Like
18

Okay send the Workflow.

19

Did you try this?

20

yeah but not worked…
@aanandsanraj