Why does my text to columns activity throw error

[mark_rajkumar1 (mark rajkumar)]

Hi there,
Why does my text to columns activity throw error using studiox?

Error message is complilation failed or was cancelled.

When i disable this activity, it worked.

[Srini84 (Srinivas)]

@mark_rajkumar1

Can you share the screenshot of the activity and activity properties?
Also Is this in Excel application scope?

Thanks,
Srini

[Palaniyappan (Forum Leader)]

Hi

I think there is some compiler error with that activity in specific

Check with the error symbol or hover ur mouse over it to know what is that error

And would recommend to have a view on this thread to know on how to use this text to column activity

How to use Text to Columns activity

[UiPath Forum topic] This is how it looks in StudioX. I don’t know about Studio. Regardless I think its a formatting issue with how you are indicating the column. ExcelFileName.Sheet(“SheetName”).Range(“C:C”) is the formatting in the Advanced Editor. It’s probably not able to figure out what column you want to select as the source because you dont have the File Name and Sheet Name parameters in your current formatting. [forumpost] That’s what the formatting looks like in StudioX. I would as…

Cheers @mark_rajkumar1

[mark_rajkumar1 (mark rajkumar)]

This is my error mates

[Srini84 (Srinivas)]

@mark_rajkumar1

Can you share the properties of the activity
Also share the Input value you are giving

Hope this may help you

Thanks,
Srini

[mark_rajkumar1 (mark rajkumar)]

This my property panel and inputs @Srini84

[Anil_G (Anil Gorthi)]

@mark_rajkumar1

Can you try selecting only the sheetname in destination please istead of A1 and then check

Cheers

[mark_rajkumar1 (mark rajkumar)]

@Anil_G it does not work. I played around with the activity, it works with all the delimiter except for the other where it is / as per screenshot.

[Anil_G (Anil Gorthi)]

@mark_rajkumar1

Is it possible to share a sample or xaml you are trying

Cheers

[mark_rajkumar1 (mark rajkumar)]

@Anil_G basically i m using excel and text to column activity to do this

[mark_rajkumar1 (mark rajkumar)]

Hi there @Anil_G my text to columns activity is working except only when i click Delimiter and use this symbol \ with doube qoute. Is there any solution?

[Anil_G (Anil Gorthi)]

@mark_rajkumar1

You can try reading the data and use generate datatable activity and write back…let me test from my side using text to column also

Cheers

[mark_rajkumar1 (mark rajkumar)]

Ok thanks @Anil_G do let me know the outcome

[Anil_G (Anil Gorthi)]

@mark_rajkumar1

I did test with / and it worked as expected. I did not see any issue as such

cheers

[mark_rajkumar1 (mark rajkumar)]

@Anil_G i was talking abt this symbol for a path way.

[Anil_G (Anil Gorthi)]

@mark_rajkumar1

Did try and the result is good

cheers

[mark_rajkumar1 (mark rajkumar)]

@Anil_G the symbol you use is wrong. It suppose to be the other way round. Look at the screenshot carefully.

[mark_rajkumar1 (mark rajkumar)]

@Anil_G please review

[Anil_G (Anil Gorthi)]

@mark_rajkumar1

Sorry for the delay.

Yes I did check it and yes its failing for that specifier

@loginerror - Can we please look into this

cheers

[mark_rajkumar1 (mark rajkumar)]

@loginerror what will be the next step?