Mornin, all. Odd ball problem (for me) that may make sense to you all. I'm a newbie, so, there's that...
I don't have the luxury of buying/paying for a component that will make importing easy for me, so...
Importing a csv that's created by another process (from my company). It's 2 rows - one is the header, the second is the real data that I need. Problem with my csv is that it's a mixture of text and numbers, where only the numbers are encapsulated in quotes when there's a comma separator in the thousands place. (So... Field1Value, Field2Value, 0, "1,234", FIeldValue5.. etc.)
So, my flow basically takes the second row in (as a string), chunks it out into individual characters, and then loops through each character to remove the commas that are in the thousands place. Once I've removed the commas, I then change the separators (comma to pipe) so I have a clean string I can "split".
The problem I'm having is that it never ends. Well, sometimes it ends - If I reduce the size of the csv - I can get it to finish. One time I run it it'll be a minute and a half, and another time it'll be 10 minutes. And then sometimes it won't finish at all. But if I use the actual file, it never finishes - or at least, I assume it'll never finish, because after 24 hours, if it's not done parsing 2600 characters, then Power Automate is clearly not the way to do this...
My CLOUD flow is below (or at least, most of it). This is the part that seems to never finish, I think. It's got the spinny circles on my "Apply to each" and the "Replace Comma Quote with Pipe". Guessing - and it's only a guess - that the Apply to Each isn't finishing? Or is it something else?
Anyone got any suggestions for debugging this mess?
Thanks in advance.
mw
