How can i extract 8904231549845 this value from entire item description column and create a new col and insert the value into it?

Help Studio
, ,
1

CASABLABNCA1.xlsx (51.0 KB)

2

Lets assume yo are interested on the 13digit code. We can use Regex to extract it
grafik

Extraction and updating the dedicated row we can do within the block of a for each row

3

How can i extract and write it back to excel? Please tell me in detail

4

For working with regex have a look here:

so in general a flow could look lik this:

  • read range
  • for each row
    • regex: Value extraction
    • dedicated column updating
  • write range
1 Like
5

it is taking 2 mints of time for 174 rows is there any other way in which we can reduce the time?

6

lets get identified which code part is consuming the major block.
Can you check if preserve format was activated while read range?
Maybe you can share some overview screenshot from the implementation of the workflow
Thanks

7

Thanks i got the solution

8

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