Excel Action: Grabbing Info from Excel Formula Rather than Excel Cell

Michael_299203
Michael_299203 Posts: 10
edited September 2020 in Questions

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?

Tagged:

Answers

  • Dylan_191182
    Dylan_191182 Posts: 92 admin

    @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?

  • Chris_573086
    Chris_573086 Posts: 14 admin

    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".

  • @Dylan_478989 @Chris_401431 I created a work around for this...posted here