Forum Discussion

aniketbhoi's avatar
aniketbhoi
New Contributor II
8 years ago
Solved

Strip white spaces out of Excel

I currently have a pipeline that pulls an excel file from a Box location,Parses the excel file and then writes /inserts that data into a table. We encountered a case wherein the Pipeline failed wit...
  • del's avatar
    del
    8 years ago

    I tackle this following a CSV parser with this router configuration using an arrow function and the jsonPath wildcard:

    Note, your jsonPath may vary slightly - like ($,"$.*") instead of ($.original,"$.*")

    I got this idea from a post on this forum (I think from @tstack, but not sure), however, I’ve searched for 15 minutes and cannot find the original post to reference in this post.

del's avatar
del
Contributor III
8 years ago

I tackle this following a CSV parser with this router configuration using an arrow function and the jsonPath wildcard:

Note, your jsonPath may vary slightly - like ($,"$.*") instead of ($.original,"$.*")

I got this idea from a post on this forum (I think from @tstack, but not sure), however, I’ve searched for 15 minutes and cannot find the original post to reference in this post.

nisars's avatar
nisars
New Contributor III
8 years ago

Will give this a go! Thank you