Split & assign

[sayanghosh333 (sayan ghosh)]

Hello,
I want to split the following filename “ProcessA_CH0C_Derivate_JV_Template_CH_012020.xlsm” using underscore and assign each of the split items to separate variables. Any idea how?

[pattyricarte (Patty Boy)]

string.split("_"c) then assign it to array variable and do the iteration using the foreach activities in your desire @sayanghosh333

cheers

Happy learning

[fernando_zuluaga]

Text: “ProcessA_CH0C_Derivate_JV_Template_CH_012020.xlsm”
Split1: Text.Split("_"c)(0)
Output: ProcessA
Split2: Text.Split("_"c(1)
Output: CH0C
Split3: Text.Split("_"c)(2)
Output: Derivate
and following that you can get all the split buddy
Regards!