Sheet name modification

T_Y_Raju · July 12, 2023, 8:09am

i have input sheet name in config file as Pous_CK_1000002_$2345.csv

i want to take only this Pous_CK_ so that i can make it dynamic

sheet from config file is in_config(“InputsheetName”).tostring

Yazan_Otaibi · July 12, 2023, 8:16am

hi @T_Y_Raju
Pous_CK_1000002_$2345.csv what is the fixed of this ?

T_Y_Raju · July 12, 2023, 8:17am

This is fixed Pous_CK_

Yazan_Otaibi · July 12, 2023, 8:19am

you are saying you want the fixed part !!

T_Y_Raju · July 12, 2023, 8:19am

yes i want the fixed part

Yazan_Otaibi · July 12, 2023, 8:21am

split(“Pous_CK_1000002_$2345.csv”,“10”)(0)

but its fixed !
why you want the fixed part !

T_Y_Raju · July 12, 2023, 8:24am

like i will be getting input files with same name as Pous_ck_with different numeric value

so every time i want the sheet name to standardized

T_Y_Raju · July 12, 2023, 8:25am

in_config(“Inputsheetname”).tostring.subtring(0,7) this method is not working

Yazan_Otaibi · July 12, 2023, 8:33am

@T_Y_Raju
try
Split("Pous_CK_1000002_$2345.csv","Pous_CK_1000002_$2345.csv".split("_"c)(2).tostring)(0)

Yazan_Otaibi · July 12, 2023, 8:34am

replace “Pous_CK_1000002_$2345.csv” with
in_confg(“Inputsheetname”).tostring

vrdabberu · July 12, 2023, 8:40am

Try this

variable = in_config(“InputsheetName”).tostring

RequiredData = variable.split("_"c)(0)+"_"+variable.split("_"c)(1)+"_"

Regards

lrtetala · July 12, 2023, 8:48am

Try this

FileName.Substring(0,8)

I hope it helps!!

T_Y_Raju · July 12, 2023, 8:56am

my sheet name in config file is Pous_CK_10000034_$1234.15.csv

iam writing expression as in_config(“inputsheetname”.substring(0,7).tostring

its giving error as cannot assign system.object to type system,string

lrtetala · July 12, 2023, 8:58am

Give like this
in_Config(“inputsheetname”).ToString.SubString(0,8)

mkankatala · July 12, 2023, 8:59am

Use the below regex expression to extract the desired output

System.Text.RegularExpressions.Regex.Matches(yourstringinput.ToString,“(.*\_(?=.*\_.*.csv))”)

vrdabberu · July 12, 2023, 9:01am

Store the value to a variable and try giving

variable = in_config(“InputsheetName”).tostring

RequiredData = variable.substring(0,8)

Regards

T_Y_Raju · July 12, 2023, 9:02am

it says index and length must refer to a location with in string
parameter name:length

Parvathy · July 12, 2023, 9:02am

Try using the following regex expression:

System.Text.RegularExpressions.Regex.Match("Pous_CK_1000002_$2345.csv","[A-Za-z]+_+[A-Z]+_").Value

Hope it helps!!
Regards,

lrtetala · July 12, 2023, 9:06am

Try to store config value in a variable by using assign activity

- Assign -> variable = in_config(“InputsheetName”).tostring
- Assign -> Output = Variable.SubString(0,8)

T_Y_Raju · July 12, 2023, 9:15am

how to use this function