Specific parts of the file name

Help StudioX
,
1

even there are too much topic for kind of this i couldn’t find what im looking for if you can help or forward i appreciate

here is the situation,

i need to take the following numbers from the file name and search it in excel when i find them i will write something else to there.

this is the name of the file, these numbers and their digits can change but locations are static
1__ABC AB_01_ABCD_14857_Tesesses_384_ABC-ZXNAS MXDERLQZ KEXALSIH_62755-2024-5_13-06-2024_23_33

first number; 1 it can be two or three decimal also

second number that after AB; 01

third number that after ABCD; 14857

how to read them and search in another file, thanks

1 Like
2

If the structure is always the same, you could use the Split Text activity:

And then get the items you want.

3

can you please share how did you customize the seperator?

4

or maybe regex code?

5

Indeed, I can see why the first video might be confusing. See here for a more detailed one:

1 Like
6

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