Question
Flextronics
IN
Last activity: 26 Dec 2017 23:27 EST
TextTocoloumns
Hey guys I'm trying to perform TextToColoumns but I'm unable to do it. Please can someone help me here.I have attached the screenshot of my automation along with the error I'm getting when I run it.
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Pegasystems Inc.
US
What are you trying to do here? It looks like you're pushing the A2 value to the column, but it's unclear.
Flextronics
IN
Hey Grona Im trying to get the value from the cell A2 and convert it into coloumns.But the method do is unclear to me.
Flextronics
IN
Would it be right to use the getcellvalue function to select the cells for which I want to perform the operation?Or can you tell me what function to use in that case?
Pegasystems Inc.
US
You can use getcellvalue to pull the value from A2 and pass it, yes.
Flextronics
IN
How to give the input for comma and all?
Pegasystems Inc.
US
What do you mean? You're going to get the whole string from the cell value.
Flextronics
IN
Hey Grona wat I'm trying to ask is that on the text to coloumn method there are other parameters like Destination,Tab,Space,Semicolon and many others. How do we feed the input to those?
Pegasystems Inc.
US