Excel Action: Grabbing Info from Excel Formula Rather than Excel Cell
I am working with a csv file where the cell information is not grabbing everything that shows up in the formula box. If I double click the cell then it shows the correct format but Catalytic is pulling the data as it's show in the cell. Is there a way to grab the formula number rather than what the cell is showing?
Answers
-
@Michael_329698 what action(s) are you using to try to grab that data? If you open up the CSV outside of Excel what value do you see?
0 -
Looking at the raw output, it appears that this may be a case where a date/time string is being sliced incorrectly. If you started with this value "11-02-11 16:47:35.985 +0000", and wanted to get down to this value "16:47:35.985" but made a mistake, you could end up with "47:35.9".
0 -
@Dylan_478989 @Chris_401431 I created a work around for this...posted here
0